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
Thanks,
Asif
checkout these first and ask a more specific question if you get stuck
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
User | Count |
---|---|
39 | |
28 | |
24 | |
24 | |
13 |