Unique ID as key

AppSheet AppSheet Q&A
, ,
1

Hi
I have few tables that have row numbers as key. I want to have a stable key, for which I’ve created another column ID and putting UNIQUEID() as app formula. Also I’m marking this column as hidden as I don’t want this to be shown unnecessarily to user.

But the problem is when I save or regenerate the structure, the app formula is automatically being removed. Any reason why it is happening?

If this is a standard app behaviour, then what could be the way out to have a stable key, b’s any of my existing columns can’t be used as the key.

2

Neeraj_Malik:

putting UNIQUEID() as app formula. Also I’m marking this column as hidden as I don’t want this to be shown unnecessarily to user.> > But the problem is when I save or regenerate the structure, the app formula is automatically being removed. Any reason why it is happening?

Please have UNIQUEID() as the initial value instead of app formula for the key column. You can also keep it hidden.

With an app formula, the value of the column could change, as a result the app editor removes the app formula.

4 Likes
3

Thanks @Suvrutt_Gurjar

1 Like