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?
LinkedIn
Twitter
