hope you can help me. I have made a simple App (with AppSheet) that use a Google Sheet file. The goal is managing different tasks I'll assign to my co-workers. In my app I see all the tasks listed in a table, I can open each row, see the task as a card and with an action button open the form to edit the person who is working on that task and the day of assignment. However, in the Google Sheet data source I need a sheet that records every edit that has be done through AppSheet.
I tried using the onEdit installable trigger on the sheet and a script (written in AppsScripts) that records every edit, but unfortunately it doesn't work. The trigger is never called by the changes that AppSheet made. Have I done something wrong? Is there another way to do that? Thanks in advance.
Your use case is achievable in AppSheet alone, no need to employ App Script since it may not directly capture the changes made on your spreadsheet since it is not user initiated.
You need to have a last_edit (date/timestamp) column in your Google Sheet data source, then on AppSheet, set an expression (aka formula) in your column properties for it to be automatically populated with the current date and time whenever the form is opened.
You can refer to these resources for more information:
Hope this helps.