UNIQUE ID with my code

AppSheet AppSheet Q&A
1

Can you suggest how to use the unique id with my code like RAM/0000,RAM/0001 and how use that in form

2

You could use the concatenate formula, like this…

Concatenate(“RAM/“,Uniqueid())

That would give you something like this…

RAM/abc829d2
RAM/ei78iiyw
RAM/2840174a

3

You would put that in the app formula row. That way it would generate a new value for each form. I hope I understood your original post right.

Not quite sure how to make it RAM/ and then only 4 numbers.

4

Can you suggest to me in number also

5

Sorry, I do not know how to do that. Good luck though!

Have a Wonderful Day! - Nick Barry RPC

6

The challenge is that if two or more users are filling the form at the same time, you will have the same code more than once.

7

For 4 numbers you can use:

concatenate( “RAM/”, RANDBETWEEN(1000, 9999))

Change the upper and lower ranges to get any number range you want.

1 Like
8

Click through the following link for help.

[Serial Numbers, If You Must](https://community.appsheet.com/t/serial-numbers-if-you-must/19325) 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 …

2 Likes
9

Doesn’t this come up as a yellow warning if there is no explicit ‘key column’ defined for the table? Like it suggests against using _ROWNUMBER as a key?