Creating a unique staff number

[Ing_Fred_Fiifi_]

Please help me create a unique staff number
Base on example
DSFF- 001
DSFF -002
DSFF -003
DSFF- 004

PLEASE HELP ME I WANT IT IN THAT FORMAT

[Steve]

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 …

[MultiTech]

Hey @Ing_Fred_Fiifi_Arthu, welcome to the community.

Also: you might check out the following post; it’s full of tons of helpful tips to help you get stared with using the community to find answers.

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

---