Airtable mass row update suggestion

[ApoloP]

Good day Everyone.
I am trying to update a table using ‘update row by number’ from spreadsheet component.
But it is skypping some rows.
I am no tied to this solution if someone can suggest a faster/better/(stronger :P) way to update a table with 1500 rows I am all ears .
Thanks in advance.

[Markhor]

Yes you can update bulk number of records by using this extension

[FREE] KevinkunAirtable extension

V2 Update 2020/12/24 fix bug of “can not update value with space”, now in the formula, use " and " to quote the value with space. add perperty of FetchIdAndTime. if set to true, in the SelectFinished event you will get ‘id’ and ‘createdTime’ for each record. [2020-12-24_200204] add method ‘UpdateById’ and ‘DeleteById’ for update or delete one record, which is faster than by filter.[2020-12-24_200214] v1: Write a short description Why another extension about Airtable?Because this one is di…

[wangsk789 (kevinkun)]

but due to the limitation of the api, you can only update up to 10 records at one time, even if you use this extension.

And you need to update so many records？

[ApoloP]

Thanks for your responses.
I have a table with 1500 rows and 7 columns.
I need a way to send the table form tinydb to airtable to upload it to the cloud.
I am open to suggestions.

[wangsk789 (kevinkun)]

so this is only once work?
maybe try to import data on airtable website, not from app inventor side.

[ApoloP]

Thank you @wangsk789
Sadly is not a once work I think a call with a wait could do the job) but I have been told is not a good practice to use wait instructions in kodular.

[wangsk789 (kevinkun)]

use a clock.timer to wait, not a while loop

[ApoloP]

I read Airtable forums and they said we are not supposed to use airtable as the back end our our aplicattion. I could migrate to fire base, but…I am uploading it to cloud via email instead. Thanks for your responses @Markhor and @wangsk789 .