Custom Serial Number Create

AppSheet AppSheet Q&A
1

I am trying to make an app for myself.

1st Question
here is a column for serial numbers. I used the formula “count(select(sales[Sales No],True))” for adding new serial. But when two-person go to add a new entry at the same time, The serial comes the same and makes it duplicate. How to defend it.

2nd Questions
I want to create the serial by first two letters from username or usermail & last 3 digits from the count result of today new added.

Like

User name -1-- eoshila@abc.com
User name -2-- rocker@abc.com

24.08.21
first entry serial – eo001
2nd entry serial – ro002
3rd entry serial – ro003

25.08.21
first entry serial – ro001
2nd entry serial – eo002
3rd entry serial – eo003

(Note: Every day the serial will start from 001)

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 …

https://community.appsheet.com/search?q=serial%20numbers

3 Likes