# Newbie - Data & Data Sync **URL:** \ **Category:** Ask for Help\ **Created:** [January 23, 2023, 3:36pm UTC](https://community.glideapps.com/t/newbie-data-data-sync/57036 "2023-01-23T15:36:48Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![brodmuehler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brodmuehler/32/244_2.png) [@brodmuehler](https://community.glideapps.com/u/brodmuehler)\ **Post date:** [January 23, 2023, 3:36pm UTC](https://community.glideapps.com/t/newbie-data-data-sync/57036/1 "2023-01-23T15:36:48Z")
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 🙂 Thanks for your help. Cheers René ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 23, 2023, 4:06pm UTC](https://community.glideapps.com/t/newbie-data-data-sync/57036/2 "2023-01-23T16:06:38Z")
> [@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. > [@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. > [@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. > [@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’. ---
**Author:** ![brodmuehler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brodmuehler/32/244_2.png) [@brodmuehler](https://community.glideapps.com/u/brodmuehler)\ **Post date:** [January 23, 2023, 4:33pm UTC](https://community.glideapps.com/t/newbie-data-data-sync/57036/3 "2023-01-23T16:33:36Z")
Hallo many thanks for the quick response. Understood the data sources now. 🙂 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é ---
**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\ **Post date:** [January 23, 2023, 6:14pm UTC](https://community.glideapps.com/t/newbie-data-data-sync/57036/4 "2023-01-23T18:14:16Z")
> [@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 😊 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 23, 2023, 7:47pm UTC](https://community.glideapps.com/t/newbie-data-data-sync/57036/5 "2023-01-23T19:47:07Z")
> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014): > > 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](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…