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)

[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)

[Espegg]

My apps script code create an unique id in column A when you create a new row in the sheet. I need this cause not all my new rows are created with App Sheet with the help of uniqueid() function, but directly in the Google sheet.

So my problem is, that when i try to create a new row in App Sheet, the value of the key field ID (column A) is required, but it is already generated by my apps script code, so I not need to enter manually the value in app sheet.

how could I solve?

[baba_sawane · Accepted solution]

Hi Espegg,

As @TeeSee1 said you can update you appsheet rows with your script after they have been inserted in your worksheet. For example, use uniqueid() and add a new column [Created with appsheet Y/N ?], and if No then your script update this row uniqueid().

Issue is that you can't generate your uniqueid via appscript and see it in an appsheet form for a row that has yet to be created.

[Espegg]

Ok thanks.