RowID unreliable when adding multiple rows

[Filmos]

When adding multiple rows at once using FormulaMap, the RowID formula is extremely unreliable.
Not only does it work after a delay, but it also appears one row at a time.
This means that, if you have other columns dependent on the RowID formula, the calculating looks something like this:
Add multiple rows --> calculate all formulas --> update RowID of the first row --> recalculate everything --> update RowID of the second row --> recalculate everything -->...
This can create formula chains which takes hours to calculate.
What’s more, because this is a lot of quick formulas instead of a single long one, the disable calculations buttons doesn’t show up and even hard reloading the tab won’t help you, after the reload it will continue calculating.

A simple workaround would be to create your own id for each row when creating it instead of relying on the RowID function.
But this is still a huge issue which is hard to debug and can cause an enormous of headache and frustration.

And here is a demo which illustrates what I mean:

[Paul_Danyliuk]

I solved this by adding an ‘action’ that waits until all RowIDs have been assigned. Hold on, I’ll post the demo doc later today.

[Paul_Danyliuk]

Here @Filmos

Waiting for the rows to be saved to Coda (for Row IDs to be assigned)

When you create many rows at once in Coda (or lately, even one or two), their Row IDs are not assigned immediately but after some time. I assume that this happens because Coda needs to store the row on the backend first. It also applies some rate limiting, that’s why if you create lots of rows, their Row IDs will only appear one after one with some delay. You can observe this behavior by clicking the Create 20 rows button and looking at the Data table. Sometimes though you need to perform some …

[Paul_Danyliuk]

An update to solving this problem: just use UIDs instead of Row IDs:

PSA: Link to recently created rows by UID, not RowID()

Requirement: with a button create a row and bring it up into focus (e.g. as a modal) Problem: to bring out a row into focus, you need its RowID() so that you could construct its URL like: OpenWindow(Format("#_tu9Wb/r{1}&modal=true", CreatedRow.RowID()) However, RowID() at this point may still be blank because the row is not yet stored to the server. And it will always stay blank if the doc is used in Play mode. Solution: instead of RowID() use “true” 10-alphadigit unique row ID (UID) that is…