Imagine you’ve got a spreadsheet full of important info, like company contacts. Each one has a unique ID. You want to move all this into Baserow and link new rows you add with data that’s already in another table. With Baserow, you can import and link data to existing tables using Make automation. Here’s what you need:
- Set up your Baserow database
- Populate data
- Create a database token
- Add a spreadsheet module to list rows
- Add Baserow module to list rows
- Add Baserow module to create new rows
- Test & schedule the Make scenario
Let’s guide you through the process.
3 Likes
That’s nice and it works. In my case the situation is a bit more complex because I can also “update a row” and not only “create a row”.
To go back to your example, that contact can have multiple companies where he/she works. And it may be already present in the tables. So instead of creating a row I need to update a row adding a new company where he/she works WITHOUT deleting the previous ones. How to do that?
Just for reference for anyone willing to update a row with linked table and not only create, the solution I found is: Update linked data from another table without overwriting - automatically with make - #7 by baseuser
Thank you @baseuser for sharing the solution 