MARKETPLACE
PLUGINS
TABLE / GRID FOR THINGS AND EXCEL
Table / Grid for Things and Excel logo

Table / Grid for Things and Excel

Published November 2020
   •    Updated March 2025

Plugin details

A set of table widgets for displaying (basic)excel-sheets and Things.
Features:

* Easily display a List of Things or API data
* Easily display an excel-sheet (displays a single tab of a column based table)
* Display nested values (/Order/Customer/First Name) (in the Advanced Table)
* Download the grid's data as Microsoft Excel-sheet
* Single/Multi select - selection is usable in other widgets
* Excel-sheet current selected rows available as list of JSON
* Paging, Sorting, Search filtering, Scrolling
* Manage "whitespace" behaviour (wrapping)
* Display List-fields
* Apply custom javascript functions to make aggregations or custom formatting
* Display images in cells (& optional fullscreen popup) (not for excel)
* Optionally specify a button-column, the buttons will trigger a workflow.
* Drag and drop File(s)
* Events/states to detect selection, doubleclick, filedrop, etc.
* Mode to allow right-mouse-selection to provide better usability when combining with context-menu plugins.
* Loads of look & feel customization.
* Up to 60 columns (15 via widget configuration, additional 45 configurable via a workflow action).
* Documentatin (see link in the instructions section)

Experimental: Utilityaction to read the row-count of an xlsx / .csv file.


--- ⚠️ When updating from 1.x to 2.0.0 ---
Update 2.0.0 updates the plugin to support the the "responsive design" paradigm.
This conflicted/obsoleted the following setting:
- Vertical Overflow (Show vertical scrollbar, Dynamically increase widget height,Dynamically increase & decrease widget height).

* This update has caused loss of functionality for showing scrollbars (rather than expanding in height) on the traditional layout.
* Currently a known issue is that the widget does not render correctly when part of mutliple items in a layout. Current workaround is to wrap the widget in it's own group.


Other errors may still existing. Please contact me asap when unexpected problems occur regarding sizing/layout.
--- ⚠️ When updating to 2.0.0 ---


⚠️Warning, when formatting data as HTML, be sure to be in control of the data you're formatting as HTML as to prevent other users injecting code in your application.


I'm currently taking feature & improvement requests. Feel free to share your thoughts or ask for help by sending an e-mail to:  bubblepluginsupport@yocto.in


Tested on IE11, Edge,(Chromium), Firefox and Chrome

👍 Do you love the plugin? Consider supporting further support/development by subscribing  or leaving a review. It's just one cup of coffe each month:)

Pro tip: Subscriptions are prorated and therefore a really cheap way to try this plugin without buying!

$3

One time  •  Or  $2/mo

4.9 stars   •   14 ratings
505 installs  
This plugin does not collect or track your personal data.

Contributor details

Yocto Increments logo
Yocto Increments
Joined 2020   •   4 Plugins
View contributor profile

Instructions

This package features three variants of the table / grid widget.
1. The Basic variant: For displaying Lists of Things in a tabular fashion. Just drag the widget on your page and provide it with data. Play with the settings to optimize your results.

2. The "Excel" variant: Simply upload/input the excelsheet you want to have displayed and you're ready. Additionally play with the settings to optimize the look and feel.

3. The "Advanced" variant: This variant is "advanced" as it is not "click and go". Instead it requires "field expressions" where you specify the field that should be displayed.

For example, imagining you provide the table with a list of "ShoppingCart" Things where a Shopping-cart has a CreationDate field, and is linked to a Customer.
In this case the "/CreationDate" expression would yield the Creation Date. And the /Customer/Name would yield the name of the customer.

It's also possible to use JavaScript functions within the field expression, see the Demo Page for some examples.


-- Downloading the widget's data as Excel file
The data can be downloaded as excel-file using a workflow.   Simply trigger the "downloadData" action under "Element Actions"  


More documentation at:
http://meta.cdn.bubble.io/f1679430099475x664403263956924700/Yocto%20Table.docx

Types

This plugin can be found under the following types:
Background Services   •   Element   •   Event   •   Action

Categories

This plugin can be found under the following categories:

Resources

Support contact
Documentation
Tutorial

Rating and reviews

Average rating (4.9)
By far the best HTML table plugin
November 7th, 2024
I tried the others, and though more installs, though more review - this is by far better. Refresh just works. Loading by datatype is great. Thank you @lindsay_knowcode
1) Issue with height and 2) error when using certain fields
July 30th, 2024
ISSUE 1) Height works fine on version 2.13.0 but the moment I update to version 2.13.1 or 2.13.2 the table height is limited the Min Height specified even though 'fit to content' is supposed to apply but it is not. ISSUE 2) On the one datafield , when used in the table, the table totally dissapears. When tested in the debugger it returns the following error: The plugin Table / Grid for Things and Excel / element Table/Grid for Things threw the following error: TypeError: n.length is not a function at String. (https://meta-l.cdn.bubble.io/f1684575098391x424933895747264100/shared24.min.js:41:276) at Function.each (https://coregroup.world/package/pre_run_jquery_js/dee903a9e36db713e4c86d0cdd96d921e37be0c1293ed8dee29e2e4d7713b9ff/pre_run_jquery.js:2:3003) (please report this to the plugin author)
greate !!!
February 9th, 2024
great table and great support
Amazing plugin and fast response from developer!
December 29th, 2023
This plugin does EXACTLY what I needed it to do. The tables are easy to put together. There was one feature that I needed (adjusting the color of the headers and footers of the table). I reached out to the developer, and he got back to me in less than 2 hours and then implemented my suggestions within a matter of days. Amazing! Wish I could give 10 stars instead of 5.
best table
August 9th, 2023
no bugs, best support, best table
Bubble