Dear All I am new to glide and I do not understand, how Glide syncs the data between Glide Tables and my Google Sheets. Is there a tutorial I could look at and educate myself? Just some questions: How do I connect a Glide table with a Sheet table? How can add and delete zables while developing the project? How do I create an ID column? How can I ensure that a column only stores unique data, e.g. for an email address? As you can see - newbie :slight_smile: Thanks for your help. Cheers René

[image] brodmuehler: How do I connect a Glide table with a Sheet table? Glide Tables and Google Sheet tables are different data sources. You can mix them in the same project, but they are still separate data sources. [image] brodmuehler: How can add and delete zables while developing the project? If you are connected to a google sheet, you will always see all sheet tables, whether you use all of them or not. If you need to add a new sheet table, then you will need to do that from within Google sheets. Likewise when deleting a google table If you want a new glide table, you can add that through the glide data editor, and in the same manner, you can right click on a glide table to remove it. [image] brodmuehler: How do I create an ID column? In the glide data editor, add a new column and select Row ID as the column type. [image] brodmuehler: How can I ensure that a column only stores unique data, e.g. for an email address? You’ll need to clarify this question. If you mean each row needs to be unique to each user, then you can add an email column and set that column as a row owner. If you mean that multiple users will share the same column cell in the same row, then when you add a new column through the data editor, you need to select ‘User Specific’.

Hallo many thanks for the quick response. Understood the data sources now. :slight_smile: What I meant with unique data is, that an email should be unique and there shouldn’t be two users with the same email address. That also means that I would expect that should a new user be added with an email address already in the table, there should be a warning and the app should not save this user unless he has a unique address. I hope that makes sense. Cheers René

[image] brodmuehler: What I meant with unique data is, that an email should be unique and there shouldn’t be two users with the same email address. That also means that I would expect that should a new user be added with an email address already in the table, there should be a warning and the app should not save this user unless he has a unique address. When the user logs in the the first time, Glide records their email address and stores it in the user sheet. That means, if the user signs in again, Glideapps will not create a new row for that ID. However, if you are adding your users manually and you want the app to give you a warning if entered email address already exists in the database then probably you can create a custom form and use some conditions which I believe our experts can explain in simpler language :blush:

[image] How do I create a custom form? FAQ I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

Newbie - Data & Data Sync

Ask for Help

Jeff_Hager January 23, 2023, 7:47pm 5

Topic		Replies	Views
Glide table not updating Ask for Help	7	1002	August 29, 2021
Integrating Google Sheet into Glide Tables Ask for Help	9	642	March 18, 2024
Table Users sync with Google Sheet Ask for Help	2	537	September 23, 2022
Manage Data in Glide Table Ask for Help	12	621	August 18, 2022
Is Data from Glide Tables sync to Google sheets? Ask for Help	7	1684	February 25, 2021

Newbie - Data & Data Sync

Related topics