I am experiencing an issue where data is not being registered to my Google Sheets, but only when using a specific Form View in my attendance management app.
Details of the issue:
Symptoms: When I submit data through the “Time-in/out” Form View, the data does not appear in the Spreadsheet.
Errors: No specific error messages are displayed. The sync seems to complete normally without any sync errors (red icons).
Automations: I have an Automation set to trigger after registration, but it doesn’t seem to be running either.
What I’ve confirmed:
Data registration from other forms/functions within the same app is working perfectly fine.
When I manually add data directly to the Google Sheet, it reflects correctly on the AppSheet side.
Question: What could be the cause of data not reflecting in the spreadsheet even though the “Save” button is pressed and no sync errors occur?
I would appreciate any insights or suggestions on what to check. Thank you!
I have already double-checked the “Source Path,” “Worksheet Name/Qualifier,” and “Source Id.” Everything is configured correctly.
As proof, when I manually enter data directly into the sheet specified in the “Worksheet Name,” the values are correctly reflected in the AppSheet view. This confirms that the connection between the app and the spreadsheet is active.
Despite this, data submitted through the AppSheet form still does not appear in the sheet. I am still looking for the cause of this one-way issue.
I wanted to give you an update on this. I managed to find the root cause and solve the issue!
It turned out to be a misconfiguration in the “Enum” type settings.I decided to copy the app for testing purposes, and when I did, an error message appeared in the Preview view that wasn’t showing up in the original app. That alert helped me pinpoint the mistake immediately.
Everything is working correctly now. Thank you for your support and for pointing me in the right direction!
