šŸ”„ [PLUGIN RELEASE] Advanced Dynamic Tables for Bubble (Excel-like)

Would be interested in you could confirm whether these features are in the works:

  • Customisation of fonts, colours etc (spruce it up to be more ā€œmodernā€)
  • Ability to have a horizontal table so it displays like this:

Name: John Doe
Age : 40

As opposed to:

Name⠀⠀⠀ Age

John Doe ā €40

  • Ability to add images, bbcode
  • Ability to add buttons/icons where you can add them into a column eg; an edit icon allows a workflow to be started.

@BubbleSam ^

Hi @barnetrpc !
Thank you for your interest and great feature suggestions!

I definitely will add more styling options very soon (custom fonts, colors and table styles).

Unfortunately, I can’t guarantee that support of complex cell data such as bbcodes / buttons / checkboxes etc will be available soon because this plugin is limited by the libs it is using under the hood. However, I understand the need and I will try to find a solution. Probably even a new tables plugin should be created to cover different use cases.

+1 on styling!

Any chance you have an ETA on this? I have a client project due Monday, and if I could style it before showing it off, that would be killer!

Hi @justin.hume,
I will work on this during this week, probably tomorrow.
Do you have any special requirements for styling?

What would it need to style it like the Semantic UI? DataTables example - Semantic UI

Advanced Dynamic Tables v1.5.0 Released! :tada:

Some highlights:

  • Plugin now supports 2 styling themes: Default and Semantic UI
  • New styling options: table color, inverted color (for Semantic UI theme only)
  • Better table rendering performance
  • Better plugin fields grouping
  • Under the hood improvements

:link: Demo (Semantic UI theme) | Editor

:link: Demo (Default theme) | Editor

Default theme:

Semantic UI theme:

Hi @justin.hume ,
Would you be interested in testing new Semantic UI theme? :smiley:

Of course! You da man!

I’ve just updated the docs to reflect the latest changes! The docs url is unchanged

No complaints so far! Great job @BubbleSam ! You might want to add something in the documentation about how you can also use :format as text in order to list things’s things, as well as concatenate multiple fields. Super useful!

I am running into a potential loading problem where I have a crazy amount of columns of data (34 to be exact) that are being hidden dynamically. A load for 6 things is taking 10 seconds (but only showing 5 columns).

I’m wondering if there is any way for us to do an ā€œadd columnā€ and ā€œremove columnā€ workflow so I can call them one at a time instead of preloading all 34 columns. Thoughts?

Hi! I have a question: can you populate a table with a specific sorting? It seems that the only criteria that the table has on default is the unique id.
Thanks!

RaĆŗl

Great idea! I’m putting this into my feature requests list!

This is something that I want to implement in the next release! :wink:

Hey Sam! Great Plugin- quick Q, is it possible to create a table where columns are date ranges, and the rows are searches for data? I’m trying to build table-based business dashboards, where I can see how many users signed up (for example), each week for the past 4 weeks, and calculate percentage increases, etc.

@BubbleSam - Stellar work on this plugin, Do you anticipate a feature for the ability to select multiple rows? I imagine it to be kind of the same way the built-in bubble App Data table is with the ability to select multiple rows and perform a ā€œbulk deleteā€ per se.

image

The end goal would be to ā€œMake a Change to a List of Thingsā€ for the selected Things(Bulk Actions).

Using custom states I was able to create/add to a list of Things on the Row Click action but I can’t tell which Thing/Rows are in my ā€œSelected Listā€ based on the table.
(That ā€œWhen Row is Clickedā€ workflow ability is GOLD)

The better question might be, is there any way to Conditionally Format the Rows appearance?

Also, I am having trouble populating/formatting data that is a list when using the plugin. For instance, I have a list of Orders that I am populating the Table with.

Each Order has a ā€œList of Locationsā€ associated. Each Location has a Name field that is a text field.

In the Table I am trying to show the Orders List of Location’s Names (List of Texts)

I feel like it should be possible using ā€œGroup Byā€ function, I keep getting a one-to-one relationship in the table - each Location item associated to one Order, which makes sense why it is happening but I can’t figure out how to manipulate the Initial ā€œPopulateā€ Search while maintaining the number of records I get in return.

Any help would be greatly appreciated!

Amazing work here!!!

Advanced Dynamic Tables v1.6.0 :tada:

We continue improving the experience with our plugin to let you build yet more powerful and beautiful tables!

Here are the main highlights:

  • Reorderable columns
    • Related field: Reorderable_columns (y/n)
    • Related event: Column reordered
  • Working with large data. New ā€˜Scroller’ mode if you need to display large amount of data in the table
    • Related field: Large data (yes/no)
  • Select one or multiple rows
    • Related fields: Selectable rows (Disabled, Single, Multi, OS); Blur selection (yes/no)
    • Related state: Selected rows (a list of the rows unique IDs)
    • Related events: Row selected, Row deselected
  • Select a column to sort by default
    • Related fields: Default ordering (col index), Ascending order (yes/no)
  • Limit searchable cols
    • Related field: Limit searchable columns : a list of columns to disable the searching for
  • Limit orderable cols
    • Related field: Limit orderable columns: a list of columns to disable the sorting for
  • Change the number of results per page (pagination)
    • Related fields: Nb of records per page, "Show All" localization
  • New styles:
    • Row selected color
    • Control text color
  • New actions:
    • Order a column by index
    • Destroy table

New Demo | Editor (about 5000 records in the table)

It’s possible now! Check the fields: Default ordering (col index) and Ascending order (yes/no)

Hi, do you have a screenshot of what you are trying to build, please?

Hi there, yes it’s possible now! Please check the latest release notes and demos! You will need to activate the row selection mode (there are 3 different modes). After that, you will have access to Row select / deselect events and Selected rows state.

As far I understand, you want to show the list of locations in one cell for the related order?

Ask and you shall receive!!! Awesome job on the multi-select.

Yes - This is exactly right, I could really use the ability to show a dynamic list of texts in a single cell. I can’t get the formatter to differentiate further in the initial search expression, that is why I was trying to use the Group By: on the List of texts (could be off track with that though).

Thanks for the help!

I could really do with finding out how to make the background colour of a row change based on the data in a column eg;

If Status in ā€œOn Sceneā€ then I can change the styling of the relevant row.

I am also using the system for a live update system like repeating groups. The problem I have is that when new data is created, despite me ā€œRefreshingā€ the DataTable the new data doesn’t display until I have refreshed my page fully.

Is it possible for you to have the DataTables dynamically update when new data matching the column criteria is met. This would be a LIFESAVER.

If something like this is already possible, or maybe if I’m not understanding fully how the ā€œrefreshā€ functionality should work, let me know.