Create unique ID based on other column values

I would like to know how can I create a unique ID for each entries based on other column values. For eg: invoice number based on date and first few letters of company name and row number


checkout these first and ask a more specific question if you get stuck :slight_smile:


Thanks Simon,

I managed to do it. But since that was the Key, Appsheet was not accepting formulas for the key. Also it was the first column and I was using another column value which comes after. So while using the formula in initial value, the succeeding column value was not capturing while saving the form entry.

Solved it after rearrange the columns.

Is there any better way ?

Cheers !

Not sure what you mean by this

I don’t understand why this would change anything