Google Sheet won't update

AppSheet AppSheet Q&A
,
1

hi all. I read previous posts to find answers, but I had no luck.

I summarize my problem in this scheme:

  1. If I manually fill in Google sheet fields, AppShet updates correctly.

  2. If I delete record on Appsheet, this record is also deleted on Google Sheets.

  3. If I add a record in Appsheet (this is my goal), Appsheet does not store my record, and does not transfer it to Google Sheet fields.

Please help me find this problem.

2

Benni_0-1672589278249.jpeg
Benni_0-1672589278249.jpeg1920×1080 129 KB

tank you

3

Probably an issue with how you’ve set up your keys.

https://help.appsheet.com/en/articles/1023086-what-is-a-key

1 Like
4

HI.

Thank you for your reply. Yes, I added an ID column to my google sheet. I configured appsheet to recognize this column as a “key”.

Benni_0-1672611131059.jpeg
Benni_0-1672611131059.jpeg1920×1080 157 KB

Now I have another problem. I can’t automatically enter the key code.

I have this error: “Unable to add row to table ‘Attività’. → Value ‘e685301a’ in field ‘codice id (chiave)’ cannot be converted to type 'Number’.”

format of this field is number.

Where am I going wrong?

5

As specified in the UNIQUEID() - AppSheet Help article, that function returns a Text value–not a Number value. Configure the column’s data type as Text.

2 Likes
6

Thank you and Happy New Year!!

1 Like