Exclude Auto key value in the enter form

[Espegg]

I have in my google sheet a script that generate an automatic unique ID generation with apps script in column A and in App Sheet  (data panel view) I have set this column as as KEY VALUE field.

Now, App Sheet ask me in the enter form, when I try to create a new record, the mandatory ID value to insert....

So how to exclude it?

0 Likes

[TeeSee1 · Accepted solution]

I am not sure when your Apps Script code generates key values but you definitely have to have a key when you create a row within AppSheet.

Would it work if you simply put a UNIQUEID() when you create a row withing AppSheet and overwrite it with your Apps Script? (Edited: assuming you do not create anything else that uses the initial key value before you overwrite it)