I want to make custom UNIQUEID() for Customer Id

AppSheet AppSheet Q&A
1

I’m creating a Customer List so I want generate the custom id such that each customer gets unique id. Example, CC001, CC002,

Thanks in advance

2

Serial Numbers, If You Must Tips & Tricks ?

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …

3 Likes
3

Thanks for your suggestion.

1 Like