How to format the Serial number

AppSheet AppSheet Q&A
1

AbdullaNsour_0-1696411379246.png
AbdullaNsour_0-1696411379246.png1702×529 139 KB

I encountered an issue with my serial number generation. Initially, I attempted to incorporate the date and numerical sequence into the serial number, but the problem lies in the incorrect arrangement of all the numbers. The current representation appears as follows:
2310041
2310042310042
2310042310042310000

What I aim for is the following pattern:
2310041
2310042
2310043

how can I fix it

2 
CONCATENATE([Date as Number],COUNT(Purchase Invoice[Purchase Inv]))

Simon, 1minManager.com

1 Like
3

yes it’s work if we don’t delete the previous item,
However, if any of the previous elements are deleted, the number will be returned again with a value that was previously issued in the database. Like this :

AbdullaNsour_1-1696426769208.png
AbdullaNsour_1-1696426769208.png1131×617 119 KB

the Serial Number should not duplicated