Forum Academy Marketplace Showcase Pricing Features

🔥 [PLUGIN RELEASE] Advanced Dynamic Tables for Bubble (Excel-like)

Hey @BubbleSam ,
Thanks so much for this plugin. I am quite new to Bubble so still struggling a bit here.

I create a dynamic table using your plugging showing customer name and order date. When clicking on a specific line, I want to have a pop-up showing all the details of the customer orders e.g customer name, order date (which are captured in the dynamic table) but also e.g. delivery address and order status (which are not).

How do I do that?
At the moment, I can click on the line and show the pop-up; but then I struggle to find a way to render the order data in the pop-up (whether the data is populated in the dynamic table or not).

Any thoughts?
Thanks!
Tom

Hey there @BubbleSam - is there a way to make the table “taller”? I’d like to to be about 800px high, but I can’t seem to get it to grow vertically…

If this can get the same nice formatting and options as this plug-in it would be very useful and work extremely well. Can I ask what the cost of the plugin will be? Will it have the ability for buttons to be clicked and run workflows from these buttons?

I am looking for something like this, but the appearance of this plugin is much nicer, I only need the ability for buttons to be displayed.

I hope you will continue to update this plug-in, if so, I would like to see some more conditional options, like the ability to update the background of the cell rather than just the text. Custom fonts and colours I am still hoping for too.

It would be nice to add options to centre, left or right-align the heading text of columns along with the cell data too!

You should use the Row click event and the Clicked row state proving the record id:
https://bubble.digital-bird.com/plugins/tables-grids-excel#row-click-event
Once you know the record’s unique id you should be able to use Bubble’s Search for function. Hope it helps! :slight_smile:

Do you also want to change the rows height or show more rows? How the final result will look like?

Hi @barnetrpc ,

The Editable Tables plugin was released yesterday! :tada:

You can check the full list of its features in the docs and as usual, feel free to contact me if you need any further information!

Hey pal. I’d like to show more rows if possible…but I want the viewport to be taller…

Do you have to do anything additionally for the edited cell information to be updated in the database, or is that automatic? I got my data in, but the editing isn’t being updated. In the docs I see there’s an event called “cell edited” and related states, but it doesn’t explain how to use any of those…also it mentions that some columns can independently be set to disable editing, while others can be editable (which is what I want for PKs) but doesn’t show how to use that either. Is there another full documentation page that I’m missing?

Hey there Sam,

Great updates on this plugin and the Editable Tables has incredible potential.

Regarding the question - Do you have any updates/advice on how to display a list of items inside of a single cell?

Thanks!

Once the Cell edited event triggered, you can access a bunch of states including: edited_record_id, edited_col_id, edited_value. This will allow you to update the DB.

You can check the Demo 1, some columns are read-only there.

PS for further questions about the Editable Table plugin let’s move to this thread please.

Have you tried the Toolbox plugin that I recommended above? It’s pretty useful to build custom lists of things that can be displayed in a table’s column.

Will you continue to update this plugin?

Sure! All your features are already in my features list. Thank you for all your suggestions! I’m sure it will be useful for many people!

1 Like

Awesome, I have a few more questions now :joy:

  1. Does the populate table event propagate for all users, eg; if I call “Populate Table” when I press Button A. Will that table refresh for all? I will presume not, if not, is there a way to trigger an action on data changing?
  2. Could you elaborate on if/how it is possible to sort data by Creation Date or even better by status eg; if Status = Pending then show highest

This is actually possible with a slightly more complex config. Here is a simple Demo and Editor (Rows are clickable).

The data is updated automatically for all the users / in different tabs…

If you are using a “Search for” function, you should be able to sort your data as well:

@BubbleSam Download as CSV creates some big problems when you have dates (or any field with commas in it). Can we get a fix to this? Client is having a breakdown over it xD

I am thinking all it needs is each column field to be wrapped in double quotes.

Thanks @BubbleSam for that.
I am still struggling with basics it seems!

I am retrieving from the “dataTable’s Clicked Row” is a list of ALL the unique IDs from the sale table (which is my source in the row ID of your plugin). This is only retrieved by the way when clicking on the first line of the table.

How can I retrieve only the unique ID from the line I clicked in the table?

And this is how I set up the text element in the pop-up to do a search for. Obvisouly at the moment it does not work.

Where am I going wrong here?
Thanks!
Tom

Thank you for reporting this! Could you please upgrade to the latest version? It should fix the issue!

Hi there,
Could you please check this app:
Demo | Editor
When you click on a row we show a popup with the clicked row id. Using that row id it is possible to edit the row data.
The clicked row id should be a text value (an id), not a list of IDs.
Also, could you please upgrade your plugin to the latest version?

If the issue persist, could you please create a simple app / page to reproduce the problem and send it to us?

Lifesaver ! Thanks a lot @BubbleSam

Now I have a follow-up request. I want to have multiple filters in addition to the search bar.
For instance I have a list of orders with customer, order date and status. If I want to search for a customer name for a order when status is e.g. pending, how can I do this?
Is it possible “inside” the plug-in? Or should I create a dropdown option outside the datatable and then somehow link it?

Thanks again for the awesome work and support!
Tom

Apologies, I somehow missed your post…
Unfortunately, we do not provide a built-in filter for the moment (only the search bar).
So you should create filtering controls outside the plugin, filter the data and populate your table with that data

It is very possible we will add built-in filtering features a bit later!