# Having issues and troubles with the Glide app **URL:** \ **Category:** Ask for Help\ **Created:** [October 6, 2022, 7:13am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004 "2022-10-06T07:13:13Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 6, 2022, 7:13am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/1 "2022-10-06T07:13:13Z")
We have our starter project live app on the internet, but we wanted to enhance some features and add new functionality to our app, we did this by duplicating the original live app. After spending months making the product enhancements and testing thoroughly on the duplicate app, we had plan to unpublish the original live app and change the custom url to the duplicate app and then publish, basically migrating from one app to other. Today morning when we opened the app to confirm if everything is fine and ready to publish, we noticed that we lost all of our data in the user profile sheet and other glide sheets. We had about 150 rows of user information, which is reduced to only 10 rows, similarly with the other glide sheets too. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f7a49d7b9488441c6ea6768730c22f9a9e21b822.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e3600ddc37dc431f9d7b89cbd420d1403215bc2.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85f5d3b55f3f7144f862437c2b6020b5d508d52d.png) This is a very bad experience with the app ever, we had lost all of our work, effort and time. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 7, 2022, 12:32am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/2 "2022-10-07T00:32:17Z")
So do you mean that Glide Tables are not synced properly? ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 7, 2022, 5:06am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/3 "2022-10-07T05:06:33Z")
No, and even after doing many changes and edits, at the end we will get this warning. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/95bf8c870be5fb3f9c5e5c5dd9931c3fb02f5d23.png) If reloaded , all the changes are lost again. And have to start from 0. For every changes, we are at least giving some time for the app to save and start working again. ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 7, 2022, 5:14am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/4 "2022-10-07T05:14:36Z")
**FYI: My internet speed is around 100-120 mbps.** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8599e9d81274d2f840095ae91f728fbcbd5204d.jpeg) ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 7, 2022, 5:21am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/5 "2022-10-07T05:21:03Z")
@ThinhDinh Just Reloaded, it’s back to 10 rows again. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94f0230cbbfd77a355a9287eb5d35ab97a5a34eb.jpeg) ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 7, 2022, 5:55am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/6 "2022-10-07T05:55:00Z")
Another issue spotted is, whosoever views the app from their account, their email id is appearing here. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37a63ca4fac724dca614257e754acb1153b5c756.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7d81be84e2ba6536e44ecf3e737d602eac3d107.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aee7deeecea46492d0243c4cf5e23318d17dffb8.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 8, 2022, 12:26am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/7 "2022-10-08T00:26:36Z")
> [@Th.Nitin](#): > > Another issue spotted is, whosoever views the app from their account How do you have that column configured? ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 10, 2022, 6:37am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/8 "2022-10-10T06:37:14Z")
It uses row number to form a relation between the “copy of CompanyRewardForEmpl” and user profile sheet. The it uses this relation to extract email id from the user profiles glide sheet ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 10, 2022, 6:44am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/9 "2022-10-10T06:44:40Z")
Row Number? Where does that come from? How do you know the Row Number in the “copy of CompanyRewardForEmpl” table will match the correct Row Number in your User Profiles table? Normally for something like this you would be matching on either UserID or Email address. ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 11, 2022, 6:37am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/10 "2022-10-11T06:37:06Z")
But to bring email ids to a new sheet, what would you do?. I generally form a row number column, which I use to extract email id column from the user profile sheet. Yes, I know forming the relation on row number column is very prone to errors and mismatch, but I don’t know any another method either. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 6:48am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/11 "2022-10-11T06:48:10Z")
> [@Th.Nitin](#): > > But to bring email ids to a new sheet, what would you do?. It depends. I’d need to understand the larger context. How are records in that “copy of CompanyRewardForEmpl” sheet created? If they are created in Glide, you should be able to include a User reference when each row is created. If not, you might be able to use a VLOOKUP to add them in. I don’t know. I have no idea what the data in your sheets looks like or how the sheets/tables can be related. ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 11, 2022, 9:19am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/12 "2022-10-11T09:19:12Z")
The records in “copy of CompanyRewardForEmpl” is populated in 2 parts, 1. Some of the values directly come from gsheets as a default, so that when the particular email id is registered he/she will see these default values immediately, instead of blank ones in the input fields. like this: 2. Using these default values we use glide formulas, templates etc. to calculate further. like this: Now, email id should be linked to the particular row, so that data is visible to the user, earlier we used to rely on the gheets to update the email id column, this process used to take 2-3 mins, until then the user used to see blank values, now to this sheet there is no element though which we can bring the email id to this sheet so I followed this approach. Numbered the rows and then extracted the email ids. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/019ed493b3c0c3558ed1e5c96d3b25f5affc85c0.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 9:35am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/13 "2022-10-11T09:35:33Z")
How is the following column configured? ![Screen Shot 2022-10-11 at 5.30.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b158de7272434fd77f761a4599d27bec105b570c.png) Is that taking the corresponding Row from your Users sheet? If that’s the case, that means that you are depending on the order of the users being _identical_ in both sheets, yes? So if a row was ever deleted or inserted in either sheet, then it breaks. I notice that you have an EmployeeID in the same sheet - couldn’t you add that same column to your Users sheet and use that to create a relation? ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 11, 2022, 11:02am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/14 "2022-10-11T11:02:53Z")
Yes, you are correct the Email Ids column is taking corresponding email row in the user profile sheet. > [@Darren\_Murphy](#): > > I notice that you have an EmployeeID in the same sheet - couldn’t you add that same column to your Users sheet and use that to create a relation? See We have 2 types of users: 1. Registered 2. UnRegistered Glide doesn’t generate Employee Id automatically. If one subscribes to our product we give them the employee Id generated by us or the organisation they are working with. For new user who is not registered and just visited our app to test, there is no employee id generated so, it is not a good choice to go with employee id. As you can see in the below image there are many blank cells with no employee id. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd95070927cecaec8a5d3836bf5d99d1f7f37c96.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 11:07am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/15 "2022-10-11T11:07:12Z")
> [@Th.Nitin](#): > > For new user who is not registered and just visited our app to test, there is no employee id generated so, it is not a good choice to go with employee id. Okay, understood. I think what I would be doing is looking for a way to get the email address column populated with static values. You mentioned that earlier you were doing this in the GSheet, but it was too slow. Have you explored options for doing it in Glide? When are rows added to that sheet? Is it when a user registers (signs in), or at some other time after that? What is the process for adding rows to the sheet for new users? ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 11, 2022, 11:20am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/16 "2022-10-11T11:20:26Z")
Yes, as soon as the new user sign in, a new row gets added to the User Profile sheet, in the other sheets there are already pre added rows, after the new email id gets populated in the user profile sheet we bring that email id from the User Profile sheet to any respective sheet, we do this using single value method ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a71a7fe0f98d1cf77bc516662d12cfdf7f1c7636.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1866c637cd9011a4d7035fbde6e347a0cf7a3045.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 11:31am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/17 "2022-10-11T11:31:37Z")
Okay. The problem with your current method is it is _very_ easily broken. As I mentioned earlier, all it would take is for a single row to be inserted or deleted in any sheet, and everything breaks. I’m not sure if this could work for your use case, because I’m still not really understanding how the rows in your secondary sheets are added, but what you might be able to do is create a single screen onboarding for new users, then make them tap a button before they access the rest of the App. Then you could have an action attached to that button that adds a row for that user to each of your secondary sheets. At that point, you could set their email address immediately. If you’re not sure what I mean, make a copy of the App below and study it. It demonstrates exactly what I am talking about. > [@How To: Use a Public Users table to keep private user data secure (Glide Tables only)](https://community.glideapps.com/t/how-to-use-a-public-users-table-to-keep-private-user-data-secure-glide-tables-only/51391): > > Here is a copyable concept App that demonstrates how to keep User Profile data secure through the use of Row Owners, and at the same time share a subset of each users data via a Public Users table, using Glide Tables only Key points: A simple onboarding screen forces new users to complete their basic profile information. When a user completes the onboarding, their Public Profile is created The Users table and Public Users table are kept in sync by using an onSubmit action on the User Profile … ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 11, 2022, 11:40am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/18 "2022-10-11T11:40:06Z")
> [@Darren\_Murphy](#): > > Okay. The problem with your current method is it is _very_ easily broken. As I mentioned earlier, all it would take is for a single row to be inserted or deleted in any sheet, and everything breaks. Yes Absolutely. > [@Darren\_Murphy](#): > > I’m still not really understanding how the rows in your secondary sheets are added I manually pre add the rows once a while, like 100-200 rows in a respective glide sheet and similarly in the gsheets too, so that when a new user sign in he/she will see the default values easily. **\> FYI: No. of rows added in glide may or maynot be equal to the number of rows in gsheet.** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/8899d0e1e36831f92fc89498c95f5f5316bde55a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2ff593b077b5993950aa37b4beaa4b84ba27c0eb.png) As you can see in the above image there are some default values in the cell, if I use a button to add rows automatically it will create a void row just like this where there will be no default values. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/744c7c843f54b71f3249b80271e066dbcce92c89.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 11:49am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/19 "2022-10-11T11:49:02Z")
Okay, I’m not sure what else to say. It looks like you’re doing a lot of stuff in your Google Sheets that would be better done in Glide. But untangling all that and fixing it is not something that we can do by exchanging messages and screen shots here in the Community. If you want to get this fixed properly, I’d encourage you to reach out to a [Certified Expert](https://www.glideapps.com/partners) and pay them to help you with it. ---
**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\ **Post date:** [October 11, 2022, 11:57am UTC](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004/20 "2022-10-11T11:57:35Z")
I know @Darren_Murphy it is a very big web, if glide has a feature where one unique row id is shared among all the sheets not different (the row id will be same for 1 user across all the sheets and will be unique), then it would be beneficial just like in MySQL, using this unique row id we can performs tasks like joins. What’s the point having different Row Ids in different sheets. If it there, then there should be something which is shared among all the sheets. Anyways, thank you for your time and effort 😊 [Next page](https://community.glideapps.com/t/having-issues-and-troubles-with-the-glide-app/51004.md?page=2)