Column ID for Appsheet

[GerardoxOrtiz]

When linking a Google Sheet to an AppSheet, I have a constant problem: the ID column. I've tried numerous methods, including scripts, and the AppSheet always gives me error messages about the ID. I'm not a programmer; I'm a regular Google Sheets user with basic knowledge. Whenever I have problems, I primarily refer to the Gemini AI, but it makes a lot of mistakes; it's not that smart yet. But from what I see, it's possible to do it with a script. Does anyone know if there's a "universal" script that works even if tabs or rows are added or removed, and that I can use in all spreadsheets?

[WillowMobileSys]

You haven't described what the problem actually is.

If you are referring to an ID column used as the row key, typically, you would set the Initial Value in that column to the expression of UNIQUEID() so that for ANY new row added by the app, the ID column is automatically populated with a unique value as the key.

If your issue is something more than this, please clarify.

I hope this helps!

[GerardoxOrtiz]

Thank you very much, WillowMobileSys, for the response.
I created a virtual column in Appsheet with the "UNIQUEID()" formula and marked it as a key, but when I click "SAVE," the key is always marked again in the _Rownumber column. I also have a tab where I put drop-down menu items, but the problem is that if I add data there, the list doesn't update in the Appsheet. I tried a script they gave me, but it doesn't work. I repeat, I don't know anything about scripting; I'm an architect, an average computer user with no programming knowledge. Here's the link to the spreadsheet: https://docs.google.com/spreadsheets/d/1GTbCAzy8WIki8AVCD4AUSDT1qgC4BGcxhZDniZaUelc/edit?usp=sharing