hello everyone can help me I need to create a custom ID ADI001, ADI002, ADI003 โฆ HOW CAN I DO IT?
Do you have more than one app user?
@cesar_salgado You canโt have sequential key column values in AppSheet. See this article for why: help.appsheet.com - Sequential Keys Sequential Keys help.appsheet.com
@Aleksi_AlkioThere are several users
Thenโฆ as Tony replied, it wonโt work.
@cesar_salgado The formula below is how I generate my IDs.
I put it in Initial Value and give it an ISBLANK() Editable_If formula.
Itโs no where near as Random as UNIQUEID(), but it gives me the very useful ID Prefix that I want.
I usually use 2 columns for my Key anyway, giving me a very unique โ_ComputedKeyโ which works great for me because when the app strings all my IDs together, I can see that, for example, Photo P574849 came from Job J456778, and Customer C432121 and Invoice I345667.
With this kind of set up, maybe you wouldnโt need sequential numbers. CONCATENATE(โADโ,RANDBETWEEN(1000000,9999999))
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |