Hello folks!
Trying to build an app & want to understand how to connect users with their respective data at the backend. I’m using Gsheets as my database.
I would want to manually update data in the sheets and the users should be able to view the updated data respectively. Find attached screenshot for reference.
The ‘cost sample data’ is just a random table made by glide.
I made a template first, then created an app using template - linked my Gsheet but was facing same issues.
Then i deleted that app version, went back to the template & these are the screenshots for the same.
Your App is not connected to a Google Spreadsheet. If it was, the table icons would be green. Looks like you imported data from a spreadsheet rather than connecting one.
You will need to duplicate each table as a tab in your google sheet. Duplicate any basic and computed columns. Duplicate any tabs, screens, logic to use the new google sheet tables. Basically rebuild the whole app.
If you wanted to use google sheets as a data source from the beginning, you would have needed to start with google sheets as the data sources instead of glide tables.
You can still have mixed data sources, so if you only have one or two tables that need to be google sheet based, then you only need to recreate those tables in your google sheet and rebuild only the parts of the app that will use those new tables.