My KEY gets changed by AppSheet every time I ...

My KEY gets changed by AppSheet every time I save my work. How can I stop Appsheet to change change it an leave the key how I set it up? it Moves the Key to a grayout autogenerate data field

0 4 362
4 REPLIES 4

Hi @Dan_Ozarchevici1, Could you please add what column type of key you are trying to set and how you are generating it? Also to what other column the key is defaulting to?

Does AppSheet editor show any warning message?

You should change the formula to initvalue of the field.

Iโ€™m totally new to Appsheet so please be merciful. I think you put some formulas in key that is recalculated every edit. You should put UNIQUEID() or your key generator formula in โ€˜Initial valueโ€™ field and nowhere else. Then save and check if

it

still continue to change.

Harry2
New Member

@Dan_Ozarchevici1 Hi Dan, as others have pointed out, if youโ€™re using an app formula, you should use an initial value instead. For more information about the differences between app formulas and initial values, please check out this article:

help.appsheet.com - App Formulas and Initial Values App Formulas and Initial Values help.appsheet.com

Top Labels in this Space