Hi!
I’ve been toying with Bubble for some days now and have few questions regarding the Data > App Data view:
- Can I customize the row/columns displayed here? They are added automatically, but once you have more than 7, only 7 appear. Can I choose among the 7? That would be much more convenient.
- Is there a way to overwrite/substitute existing entries when uploading data through the CSV file? I guess not because there is a unique ID for each entry? My use case is that my CSV is getting richer, in the case I’m creating a new field in a table, all my entries would need to be updated with this new field but all previous fields are the same.
- I have a Data Type “Product”. How did I manage to have in App Data “All Products (modified)” and “All Products”?? I understand it’s a duplicate, but how did I do that (so that I don’t do it anymore) and is there a risk in deleting the modified entries altogether?
Many thanks!
Hi @echangers49,
Yes, you can customize by clicking on the pencil icon to the right of the data type in question. This will pull up a popup for you to select which fields you want to see. Notice that this is creating a modified view.
You can get to the same window by clicking on “New View” on the top left. You’ll just have to first select the data type for the view you’re modifying.
So, the “All Products (modified)” that you’re seeing is not a duplicate of your data - it’s the same data. If you delete a record within a modified view, you’re deleting it period. “Modified” is just to indicate that the table has a different view set up from the default.
The modified views are helpful because you can rename it (at the top) and constrain the records (at the bottom). For example, a modified view of Ingredients could be called “Spices” and the constraint would be Type (field) = Spices. The list in that table would then only be Ingredients that are spices, but again, if you delete one here, it’s the same as deleting from the All Ingredients table.
As for the CSV overwrite, there isn’t a native way to do this, but I’ve seen a few workarounds that you can search the forums for. A common one I’ve seen is to create a temporary table to upload the new CSV, and then use a workflow to replace values in the actual table based on some other identifying field… and then clear the temp list.
Gaby | Coaching Bubble
4 Likes
Oooh ok now I understand what these “Views” are, it makes total sense, got how to customize it and what the “modified” version is.
But I can safely delete the “All Products (modified)” view, right? (not the records in it, just the view).
CSV overwrite, ok it’s smart, I’ll try that.
Many many thanks @romanmg!
Yes, correct. You can delete the view safely as it’s just an alternate view for filtering/sorting.
Great!
1 Like
