more like a “best practices” question:
- I have a Collection.
- That Collection contains 7 columns and around 400 rows.
- One of the columns (it has a numeric value inside) I need to update daily, from another sheet which I have locally and I work with.
- What would be the best way to run such a daily update?
I was checking the forum and the functionality, it looks like the option “import csv” doesn’t help here, as it adds rows, not updates them, so I feel like the only options are:
a) Update the rows manually, one by one.
b) Place results from my local sheet to Google Sheets first, and then set up a connection between GS and a Collection in Adalo.
Does it so? Is there any other good option anyone could think of?