Linked databases and primary fields, how to show actual data in the data tab?

[JS7319]

My app has a few field names that connect with other tables, and one of the ways I test to see if a workflow has worked is by going into the data tab and seeing if its saved the right data to the table.

As I have multiple fields inter connected through the tables, I can only show one primary field to display in the table, and it took me a while to realise that actually the primary field data will show in a field that actually is supposed to display something else (that is, the value of another linked table).

I resolve this whilst building I had to therefore sample the data by building out repeating groups in the front end to display what is actually stored (and not masked by the primary field).

Here’s an example

In the data tab, this is what is shown:

But in the front end, its this

Is there a way I can avoid this building of repeating groups just to test data workflows and check what is stored? I might not be understanding primary fields properly or there might be another simpler way around this.

[tylerboodman]

Hey @JS7319 I think I still need to respond to a DM of yours…

This won’t help testing your workflows but maybe a visualization of your database would help.

What I hope to See in Bubble

We were already building a schema generator for MSSQL and I saw this post. I love what @lindsay_knowcode is doing here but wanted to add something to the conversation with respect to @melon suggestion. We just published a free plugin that will generate a DBML diagram based on your Bubble Schema. Disclaimer: It does not create the database relationships just yet and does not map option sets to enums. I am going to work on the references next but wanted to publish this to get feedback while we fi…

SQL DBML Schema Plugin for Bubble, by BuildIt Branding

[JS7319]

Thanks @tylerboodman. Yeah it actually took me a few hours to realise that the primary fields mask the real data in the the cells which is just weird. I actually built the front end after remembering one of your messages to not look at the data tab.

It might even answer my question to you in the DM so let I’m going to build out a front end to display the table data and see if what I was doing was actually the correct expression and workflow.

[JS7319]

How do you use this app, installed and says drag to page, but then what?

[tylerboodman]

You put the element on a page then hit the copy button from your app preview (not the editor) and paste it’s output into dbdiagram.io - Database Relationship Diagrams Design Tool

Check the thread there might be a bug still where you have to add extra linebreaks

[ben13]

I just posted an update to the plugin. I wonder if the issue is with the copy code because I had previously added line breaks but the copy/paste has to replace those to get correct output.