Rowid coda form

1

Hi

i could have sworn i had this working but guess not.

i am using a coda form for people to log faults with equipment we have. the form needs to generate a fault id number (this works) and the number needs to be visible on the published form so that the person reporting can write the number on the equipment.

i have cur following forma for generating the fault id

Format(
“FAULT_ID {1:0000}”,
thisRow.RowId()
)

but on the form this always returns FAULT_ID 0000 on the form. but once you submit the form it shows up on the table with the row id number as it should.

yes i have include reference tables enabled and i get the same behaviour within coda.

any help would be greatly appreciated.

1 Like
2

So from my understanding, when someone is filling out a form, technically the row isn’t created yet so it doesn’t have a row ID to be used in your formula.

3 Likes
3

that makes sense. so is there a formula for retrieving the next available row id?

1 Like
4

Next available rowID is the max current row + 1 as long as you keep track of deleted rows rowID

1 Like