Data source keeps breaking in my app

I’m working on an app that uses data list viewers. For some reason the data source has broken now on three or four separate occasions and I don’t know why.

I’m using a google sheet as the data source. It is called InspectorsListByType. It’s a single file with several tabbed sheets in it. I’ve never used a local Thunkable list for the data. And I’ve never had more than one file using this name. But as you can see from the picture below, Thunkable is showing two separate data sources in “My Data Sources.”

To make matters worse, in the design view Thunkable is showing four data sources by the same name, two local and two google sheets.

Every time this happens, I need to reprogram 220 blocks of data with source information. It’s a complete time suck and I don’t know how to prevent it from happening again. Any suggestions?

1 Like

If you copy a project using a copy link, it converts any google sheets (I think airtable too?) to a localdb. The duplication could also be the result of duplicating a screen or of loading a saved screen that included it.

Having said that, as long as the google sheet is /working/ ok, does it matter if Thunkable has decided to display it twice on your selection dropdown? I’d be inclined to wait to see if it causes a problem before I relinked all my blocks. But maybe it isn’t. You say it has broken - how? What’s the behavior that’s broken?

1 Like

The data doesn’t display properly. Just my opinion but it’s ridiculous that it copies it to a local database or changes the data source. I’m copying the project at certain points so that I have a restore point in case I screw it up as I move forward.

I understand the change if you’re sharing the file for somebody else to look at. You don’t want them to be able to mess with your existing data source. But when you’re copying for yourself, it should act like any other copied file. It should be the same as the original, data references and all.

Don’t get me wrong. I’m not angry with you. I just think it’s a ridiculous setup and it’s creating a lot of extra work for no reason.

Having multiple files with the same name is also a problem. How do you know which one you’re actually linked to? Even in Windows they’ll place parentheses and a number around the second or third or fourth file with the same name if they are located in the same directory.

1 Like

Well good, because that would be misdirected!

2 Likes

Yes, I know that. Sorry if I came across Ike a bull in a china shop. You’ve been very helpful and I really appreciate it!

2 Likes

Nah, I getcha. It’s frustrating when things get buggy, for sure!

1 Like