UNIQUE ID

AppSheet AppSheet Q&A
,
21

Just wonder:

for my existing rows i use the formula

=MINUSC (DECIMALE.HEX( CASUALE.TRA(1; 4294967296); 8 ))

to add directly in GoogleSheet ID Values (copying / past only the values after creating the codes).

Then for the new records i use from within AppSheet

UniqueID()

My question is: when create a new record AppSheet checks for the old ID codes created with the formula above (and available in the same ID column) and so there’s no risk at all AppSheet creates duplicated ID?

1 Like