Hi,
I would like to massively update a collection by downoading it → changing values on the .csv file → upload it back with same records overwritten with new information.
What happens is that it does not allow to use the same ID so it creates a copy of the records.
I would delete all the collection and then upload it back but I would lose all the information of those records linked in other collections.
I would appreciate who can help me to understand if what I need is feasible or any workaround.
Regards,
Dario
A solution that has been shared a few times here in the forum is to use a list with the Countdown component.
-
Create a new True/False property for that collection called “Updated”.
-
On a separate screen, create a list of the collection you want to update with the Countdown component, and filter by “Updated = False” (which, before you start, will include every record).
-
Set that Countdown component to 1 second and add an action for when the count finishes that a will Update the record however you want it to, and make sure to include turning the “Updated” property to True.
-
This way, as they’re updated, the records disappear from the list (due to the filter) and load new ones that haven’t been updated, until every record is updated.
Hope this is what you were looking for. I think it was Victor who shared this solution once.