# Problem with replacing data

**URL:** https://community.glideapps.com/t/problem-with-replacing-data/64524
**Category:** Ask for Help
**Tags:** data-sync
**Created:** [July 30, 2023, 8:09pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524 "2023-07-30T20:09:15Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![Kris\_Hale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kris_hale/32/60331_2.png) [@Kris\_Hale](https://community.glideapps.com/u/Kris_Hale)
#### Post date: [July 30, 2023, 8:09pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/1 "2023-07-30T20:09:15Z")

</div>

my app allows my customer to provide a data table that is a list of voters, and the app builds them a map and a survey to give voters. The customer would be using the app to contact voters across the country, so there would need to be an option to use a new table with new data. However, when I attempt to add in a new table of voters and remove the prior one, it gives a warning that all the components of my app will be deleted. Is there a way to accomplish this where I would be able to upload a new data sheet and remove the prior one, or will it always delete the built features of my app if i remove the original table?

currently the only thing i can think of is to add in the new table, update the entire app to read off of that table now, and then delete the prior table. but, if i miss one feature that is still assigned to the prior table, it can break something or remove something and cause problems.

---

<div class="post-metadata">

### 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: [July 30, 2023, 11:42pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/2 "2023-07-30T23:42:44Z")

</div>

Can’t you just delete old data and upload the new data to that same table, assuming they’re the same structure?

Deleting a table, as the warning said, will remove all components for that table.

---

<div class="post-metadata">

### Author: ![Kris\_Hale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kris_hale/32/60331_2.png) [@Kris\_Hale](https://community.glideapps.com/u/Kris_Hale)
#### Post date: [July 31, 2023, 12:27am UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/3 "2023-07-31T00:27:52Z")

</div>

I’m not sure how you mean, f go you mean just copy and paste? I’m not sure how clunky that works be when there are thousands of rows

---

<div class="post-metadata">

### 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: [July 31, 2023, 1:13am UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/4 "2023-07-31T01:13:08Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/41894bb7d598a1c3baa7cd8807cd54ea8ead13dc.png)

You can right click on the table and click Import.

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [July 31, 2023, 2:39pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/5 "2023-07-31T14:39:28Z")

</div>

Hola!

Are your data tables Google Sheets or Glide tables? I think they are GT right?

If so, use the **Replace** option to get what you want.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b773a528e193f9dfe1e6e93a06c419240a90a4fc.png)

Glide will replace your old data and keep the same components already configured.

Saludos!

---

<div class="post-metadata">

### Author: ![Kris\_Hale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kris_hale/32/60331_2.png) [@Kris\_Hale](https://community.glideapps.com/u/Kris_Hale)
#### Post date: [July 31, 2023, 10:16pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/6 "2023-07-31T22:16:29Z")

</div>

So if my client has multiple volunteers in multiple states on the same day using the app with different data in each state, will i have to create a new copy of the app for each one? I dont understand how to make it work with just adding to the same spreadsheet.

---

<div class="post-metadata">

### 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: [July 31, 2023, 10:54pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/7 "2023-07-31T22:54:26Z")

</div>

One app means one central source of data. It seems that you want to be able to have separate data sources for different users. That’s not how it works because the data is ultimately stored on Glide servers, and the app refers to that central data store.

Your options are to create multiple apps, each with a different data source (and make extra work for yourself because you have to maintain multiple apps), or create one app with one set of tables, but use the appropriate Filters and Row Owners to determine who can see what.

Screens and components become deeply attached to their underlying table, so removing a table and attempting to replace it with a new table means it’s a brand new connection, so existing screens and components will break.

Rather than rebuilding parts of your app every time you want to add new data, you should be using the existing tables and import new data into those existing tables. There is an exception with google sheets where you can fully replace one google worksheet with another, but it sounds like you will have multiple users using different data at the same time, so fully replacing a google worksheet would not work for you. In that case, you are better off utilizing filters and/or row owners depending on how secure the data needs to be. It would be one set of tables and you just need to import additional data as @ThinhDinh pointed out above.

---

<div class="post-metadata">

### Author: ![Kris\_Hale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kris_hale/32/60331_2.png) [@Kris\_Hale](https://community.glideapps.com/u/Kris_Hale)
#### Post date: [July 31, 2023, 11:00pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/8 "2023-07-31T23:00:16Z")

</div>

Okay i was suspecting row owners would be the answer, but it honestly really confuses me how to set that up. i have read the documentation and seen some videos on it, but are there any videos available where someone shows a similar process and how to order the data this way?

---

<div class="post-metadata">

### Author: ![Kris\_Hale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kris_hale/32/60331_2.png) [@Kris\_Hale](https://community.glideapps.com/u/Kris_Hale)
#### Post date: [July 31, 2023, 11:02pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/9 "2023-07-31T23:02:27Z")

</div>

another problem is that i my cap out how many rows are needed very quickly. I was thinking i would need a business plan and to use the added features of bigquery or bigtables to link to my data outside the app, but i am not sure how that works, i have spent a few days trying to research it and now getting very far in my understanding

---

<div class="post-metadata">

### 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: [July 31, 2023, 11:18pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/10 "2023-07-31T23:18:22Z")

</div>

Here are some videos that may be useful if you haven’t seen them.

> [@🛡️Roles and Row Owners DEMYSTIFIED](https://community.glideapps.com/t/roles-and-row-owners-demystified/22956):
>
> wave Hey all, I meant to share this earlier today—I spent some time last night playing around with Row Owners and Roles (two Glide features I don’t often get the chance to use) and ended up learning quite a bit. The result? Another tutorial video for you all about how and when to use Row Owners and Roles, their benefits and limitations. Enjoy! [[Glide: Row Owners and Roles DEMYSTIFIED] ](https://www.youtube.com/watch?v=RmMLZINOwjQ) Wondering WHY you can’t assign row owners to a computed column (If then else, lookup, template…

> [@thinking Row Owners vs. User Specific Columns](https://community.glideapps.com/t/row-owners-vs-user-specific-columns/58205):
>
> Row Owners and User Specific Columns in Glide both provide a way to secure, privatize, and personalize user data, but which one should you use in your no code app? Join me as I walk you through a few different scenarios as to when you’d use each (and when you WOULDN’T use either!). [[Glide: Row Owners vs. User Specific Columns] ](https://www.youtube.com/watch?v=sclFwC6eov8)play_button User Table vs Profile Tableplay_button Demystifying Roles and Row Owners

> [@locked\_with\_key Secure Your Data with Row Owners and Public Profiles](https://community.glideapps.com/t/secure-your-data-with-row-owners-and-public-profiles/52139):
>
> wave Hey fellow Gliders! Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally expose private info. Let’s fix that. In this important tutorial, I demonstrate how and why to enable Row Owners, create a Public Profiles table, and onboard new users in order to safely create a community app that doesn’t reference the User Profile table. [[Glide: Secure Your Data with Row Owners and Public Profiles] ](https://www.youtube.com/watch?v=JPgZeDSPQMw) You can also reference this article in…

Row limits are definitely a consideration depending on how much data you have. I personally have not worked with big tables. There are some minor limitations as far as using some computed columns with them. Also the fact that only small chunks of data are sent to the user device at any one time. Normal tables send all data to the user device immediately when they open the app. Also, if multiple users are updating data in a big table, it does not automatically sync to all other user devices. That new data needs to be refreshed by the user. This is unlike normal tables, which keep everything in sync on team time. But it all depends on what you need and how you will use that data. For the most part, they should work very similar to normal tables.

---

<div class="post-metadata">

### 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: [August 1, 2023, 12:13am UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/11 "2023-08-01T00:13:53Z")

</div>

> [@Jeff\_Hager](#):
>
> There are some minor limitations as far as using some computed columns with them.

> **[Big Tables](https://www.glideapps.com/docs/essentials/data-sources/big-tables)**
>
> Scale your app with up to 10 million rows of data.

Above is the list of limitations. You have to deal with many things and if you plan to use it, I advise to use it with the 14 day trial of business plan so you can know if you want to work around those limitations for scaling purposes. If you use a normal table now and want to change it to a big table later, chances are that you will have to rebuild a lot of things.

---

<div class="post-metadata">

### Author: ![Kris\_Hale](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kris_hale/32/60331_2.png) [@Kris\_Hale](https://community.glideapps.com/u/Kris_Hale)
#### Post date: [August 5, 2023, 10:02pm UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/12 "2023-08-05T22:02:18Z")

</div>

I have tried implementing the import data feature to add new data to my original table and am not able to get it to work, it crashes in all the methods i have tried. [Continued Problems replacing data](https://community.glideapps.com/t/continued-problems-replacing-data/64735)

---

<div class="post-metadata">

### 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: [August 6, 2023, 12:39am UTC](https://community.glideapps.com/t/problem-with-replacing-data/64524/13 "2023-08-06T00:39:18Z")

</div>

> [@Continued Problems replacing data](https://community.glideapps.com/t/continued-problems-replacing-data/64735/3):
>
> Can you give us a recording of your attempt to import? I think there’s something wrong here.
