Backend data setup

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.

1 Like

Which plan do you have?

1 Like

The Maker plan

1 Like

Can I please see a screenshot from the Data Editor that shows all tables?

1 Like



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.

1 Like

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.

1 Like

I now have attached the sheet. What next?

Basically is there a tutorial or walkthrough of the entire setup similar to my requirement that I can use to set this up?

1 Like

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.

2 Likes

okay, I’ll let you know how that works after I try. Thanks Jeff!

2 Likes