# 🔥 \[PLUGIN RELEASE\] Advanced Dynamic Tables for Bubble (Excel-like) **URL:** \ **Category:** Plugins\ **Created:** [April 9, 2021, 6:53pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600 "2021-04-09T18:53:40Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 9, 2021, 6:53pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/1 "2021-04-09T18:53:40Z")
> 🚀 Populate your table with data and update data dynamically at any time. > Update any table’s option dynamically without page reloads. > Includes sorting, search and filtering data out of the box. Check our demo to see it in action! Plugin uses latest DataTables library ([https://datatables.net](https://datatables.net/)) under the hood . 🔥 Some features: - Two styling themes - Conditional formatting 🎨 - Row selection - Columns reordering - Populate your table with data dynamically at any time without page reloads - Responsive table automatically adapts to any screen size - Multiple styling options: hoverable rows, compact mode, striped rows, borders etc - 84 languages included - Advanced settings (enable/disable search for some columns, enable/disable sorting for some columns, …) ![table](https://us1.discourse-cdn.com/bubble/original/3X/6/5/65b3f10e1e89683ed5d3cd0299d55da4453adbd5.jpeg) 🔗 [Demo 1 (Default theme)](https://digitaleyedemo.bubbleapps.io/datatable) | [Editor](https://bubble.io/page?type=page&name=datatable&id=digitaleyedemo&tab=tabs-1) 🔗 [Demo 2 (Semantic UI theme)](https://digitaleyedemo.bubbleapps.io/datatable-semanticui) | [Editor](https://bubble.io/page?type=page&name=datatable-semanticui&id=digitaleyedemo&tab=tabs-1) 🔗 [Demo 3 (5000 records)](https://digitaleyedemo.bubbleapps.io/version-test/datatable-large) | [Editor](https://bubble.io/page?type=page&name=datatable-large&id=digitaleyedemo&tab=tabs-1) Plugin page: > **[Advanced Dynamic Table Grid / Excel Plugin for Bubble, by Digital Eye](https://bubble.io/plugin/excel-like-data-table-and-grid-1617804294068x151014387640434700)** > > Advanced Dynamic Table Grid / Excel Plugin page on Bubble, by Digital Eye. Add Advanced Dynamic Table Grid / Excel in one click to your app. Bubble lets you build web apps without any code. 📚 [Full Description, Documentation & Screenshots](https://bubble.digital-bird.com/plugins/tables-grids-excel) Feel free to post a comment with any kind of questions, bug reports or feature requests! ---
**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\ **Post date:** [April 10, 2021, 2:58am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/2 "2021-04-10T02:58:51Z")
Dope! @BubbleSam ---
**Author:** ![jared.gibb](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jared.gibb/32/123329_2.png) [@jared.gibb](https://forum.bubble.io/u/jared.gibb)\ **Post date:** [April 10, 2021, 3:11am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/3 "2021-04-10T03:11:21Z")
Nice job! I made my own personal version a short while back! It’s a great library and tool! ---
**Author:** ![Siddhartha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/siddhartha/32/40316_2.png) [@Siddhartha](https://forum.bubble.io/u/Siddhartha)\ **Post date:** [April 10, 2021, 10:06pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/4 "2021-04-10T22:06:43Z")
Awesome!!! What terrific timing as I was only looking for something like this yesterday. Love the way you’ve done it as it should fit my needs perfectly. Looking forward to getting up in the morning so I can have a proper play 🙂 Thanks @BubbleSam ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 10, 2021, 10:11pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/5 "2021-04-10T22:11:27Z")
Oh thank you @Siddhartha for such an awesome feedback! The plugin was approved and published yesterday 😃 I’m very happy that it could be helpful for you! Feel free to share your thoughts! ---
**Author:** ![Siddhartha](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/siddhartha/32/40316_2.png) [@Siddhartha](https://forum.bubble.io/u/Siddhartha)\ **Post date:** [April 10, 2021, 10:16pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/6 "2021-04-10T22:16:28Z")
Quick question. It looks like you’ve built the search box right in to the table, which is a great idea. I was going to use my own selector, but think the built in search option is so much neater (if that is how it works), and more practical for users, but would there be an easy way to use that search criteria to display a total of one of the columns underneath the table. For example, if there was a profit column and someone search for Widget A, is there any way I could display a total below the table (in a separate element) that would give the total profit of Widget As. Don’t worry if it is a no, as I total get that this isn’t what this plugin is for, but figured I’d ask just in case. Great work. ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 10, 2021, 10:38pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/7 "2021-04-10T22:38:08Z")
@Siddhartha Just making sure I understood you correctly, so basically you want to get the current search term and make your own request to the database, right? If so, then it’s not currently possible but I’ll try to integrate this feature very soon! It’s something that will be really helpful! I probably will add a “Search term” state so it will be possible to get it anytime. UPD: I’ve just added a bunch of new options (show/hide pagination, search etc) and also new “Search Term” state which contains the current value in the search input 🙂 Hope it could be helpful for you! ---
**Author:** ![jamie.baggaley](https://avatars.discourse-cdn.com/v4/letter/j/6bbea6/32.png) [@jamie.baggaley](https://forum.bubble.io/u/jamie.baggaley)\ **Post date:** [April 11, 2021, 8:00pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/8 "2021-04-11T20:00:30Z")
Is it possible to have the table populate based on the user selecting the columns that they want? For example if there was a check box option and the user selects columns 1 , 3, 5 could the table populate those columns only and ignore the rest of the data? ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 11, 2021, 8:27pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/9 "2021-04-11T20:27:01Z")
Great question @jamie.baggaley ! Yes, it’s possible to show/hide some columns dynamically. I will add this to our demo and will let you know! ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 11, 2021, 9:30pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/10 "2021-04-11T21:30:32Z")
hi @jamie.baggaley , I’ve just added the show/hide feature to the demo app: [https://digitaleyedemo.bubbleapps.io/datatable](https://digitaleyedemo.bubbleapps.io/datatable) ![DataTables___Digital_Eye](https://us1.discourse-cdn.com/bubble/original/3X/c/f/cf754a94f983d7ef28e69a09b0aaaeabc5e11f9a.jpeg) ---
**Author:** ![mr9sky](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@mr9sky](https://forum.bubble.io/u/mr9sky)\ **Post date:** [April 12, 2021, 7:01am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/11 "2021-04-12T07:01:44Z")
Wonderful stuff. So can I use this to make a invoice with multiple list items? ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 12, 2021, 8:25am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/13 "2021-04-12T08:25:55Z")
> [@mr9sky](#): > > So can I use this to make a invoice with multiple list items? Thank you for your question! As far I understand, you want to render a list of products like on this screenshot: ![invoice](https://us1.discourse-cdn.com/bubble/original/3X/9/1/9164faa0f612695b023b01bee72b8ab8509c3026.jpeg) Since it’s just a simple table, it should be possible to use this plugin to render it 🙂 ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 12, 2021, 11:36am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/14 "2021-04-12T11:36:10Z")
🎉 Yay! We worked hard last weekend to add new awesome features to our **Advanced Dynamic Table** plugin 🏋️‍♀️ ## **What’s new in release 1.3.X** - Show / hide search bar - Show / hide pagination - Enable/disable ordering (sort) - Show / hide info bar (“Showing 1 to 10 of 129 entries”) - Show / hide pagination controller (number of records per page dropdown) - Added possibility to dynamically show / hide some columns - Added new state: Search Term. It contains the current search term in the search bar You can preview and test all these features in our [demo app](https://digitaleyedemo.bubbleapps.io/datatable). As usual, you can find the [latest docs here](https://bubble.digital-bird.com/plugins/tables-grids-excel). ---
**Author:** ![rpetribu](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rpetribu/32/90852_2.png) [@rpetribu](https://forum.bubble.io/u/rpetribu)\ **Post date:** [April 14, 2021, 12:51pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/15 "2021-04-14T12:51:34Z")
Hi! Noticed that in mobile, the tabble header does not slides horizontally, just the rows… is it right?? ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 14, 2021, 1:35pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/16 "2021-04-14T13:35:35Z")
Hi @rpetribu , That’s a nice catch, thanks! Actually this is how DataTables lib works on mobile but there is a workaround for that. I’ve just updated the demo, it should work as expected on mobile now 😉 ---
**Author:** ![user2](https://avatars.discourse-cdn.com/v4/letter/u/ecb155/32.png) [@user2](https://forum.bubble.io/u/user2)\ **Post date:** [April 14, 2021, 3:58pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/17 "2021-04-14T15:58:48Z")
I just purchased and installed the this Plugin. I am getting the following error when the “Populate” workflow executes. What is the issue? ![image](https://us1.discourse-cdn.com/bubble/original/3X/7/9/79522c45e52a34b09958463da5fcf588d91259eb.png) ---
**Author:** ![jared.gibb](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jared.gibb/32/123329_2.png) [@jared.gibb](https://forum.bubble.io/u/jared.gibb)\ **Post date:** [April 14, 2021, 5:15pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/18 "2021-04-14T17:15:47Z")
Is your initialize table code tuning before the table is visible? ---
**Author:** ![user2](https://avatars.discourse-cdn.com/v4/letter/u/ecb155/32.png) [@user2](https://forum.bubble.io/u/user2)\ **Post date:** [April 14, 2021, 5:20pm UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/19 "2021-04-14T17:20:48Z")
Yes - thank you. The table was not visible before the load. I changed that and it works. ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [April 15, 2021, 9:29am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/20 "2021-04-15T09:29:16Z")
# Advanced Dynamic Tables v1.4.2 is here! This small patch adds a new field “Horizontal scrolling”. ![Digitaleyedemo___Bubble_Editor](https://us1.discourse-cdn.com/bubble/original/3X/b/8/b8030c6caac85aaba811109f36793d6b61207cfe.jpeg) When a table is too wide to fit into a certain layout, or you have a large number of columns in the table, you can enable horizontal (x) scrolling to show the table in a viewport, which can be scrolled. This is particularly useful when you want to show the table on mobile devices. Special thanks to @rpetribu for pointing this out! ---
**Author:** ![rpetribu](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rpetribu/32/90852_2.png) [@rpetribu](https://forum.bubble.io/u/rpetribu)\ **Post date:** [April 15, 2021, 10:54am UTC](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600/21 "2021-04-15T10:54:53Z")
Perfect! Thanks for this update 👍 [Next page](https://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600.md?page=2)