Hi Coda Community:
I’d like to create a form for our online store that generates a warranty claim. Each Waranty Claim should have a unique Warranty Number, for example “WA0020”. How can I formulate the solution for the column “Warranty Number”?
I’m trying with “value for new rows: Concatenate(“WA”,RowId(thisRow))” but the result is “WA4”, for example. That means, no zeros are added and when a row is deleted (for example, WA4) it will continue with the next.