Furthermore, this plugin would benefit me greatly if there were an option to display items vertically. I have a table that simply has the users details on.
First Name, Second Name, Email, etc
I would love it if the plugin could format it vertically. so itâs like this:
First Name: XYZ
Second Name: XYZ
Email: XYZ
Sorry for spamming up this thread, just been thrown this error:
The plugin Advanced Dynamic Table Grid / Excel / action Populate a DataTable threw the following error: TypeError: Cannot read property âsplitâ of null
at Object.instance.data.populate (PLUGIN_Advanced-Dynamic-Table-GridâExcel-initializeâDataTable-.js:98:50)
at eval (PLUGIN_Advanced-Dynamic-Table-GridâExcel-element_actionâDataTable-Populate-.js:3:90) (please report this to the plugin author)
As far I know, there is no specific event we can subscribe to refresh the table automatically. I suggest you to do like this:
Create a custom âPopulate Tableâ event:
Once you know that the database was modified, simply call this event. It will instantly update your table.
Iâm currently working on a new release so I will check whether itâs possible to implement some of the proposed features (especially the conditional formatting!). Thank you for your feedback!
Lots of comments here and Iâm happy for the plugin! One question, can I mix data linked through a common variable with this plugin? Many table plugins donât allow for different data types in the same plugin.
Hi @josh10 ,
Thank you for your question! A column is defined as a comma-separated list of values. If you can build this kind of list, you will be able to show it in the table!
Conditional formatting allows you to automatically apply formatting: font colors, background colors, font weight to one or more cells based on the cell value. To do this, youâll need to create a conditional formatting rule.
This seems like a very straightforward thing to do but can we add automatic emptying to anything that comes out as an empty thing of an empty thing? Such as [object Object].
I think itâs possible with the Toolbox plugin. You need to create a list first and convert it to a string with comma-separated items like for any other column.
Here I have a field âitemsâ which is a list of things. Item expression will build a list of lengths which is accessible via the ListItemExpression A's list state.
You can pass this list to the table
I am interested in installing this plugin but I want to make sure of a feature first.
I have 4 tables: âUserâ, âSmartphoneâ, âSmartphone provisionâ and âClientâ. The table âSmartphone provisionâ is linked to both tables âSmartphonesâ and âUserâ (by their unique id) since it has a Smartphone attribute and a User attribute. Moreover, the Client table is linked to the User table by the Company ID. You can see the graph below to understand the situation better.
How can I display in a Grid the name of the user, its company and the IMEI of its smartphone on the same row ?
I want to make sure that this Company match with this rowâs User up (displayed in another column).
Indeed, it seems that there is no constraint in data source settings like âUser = currentâs rowâs Userâ or something like that but I may be wrong.
Now you can show this list as a column in your table.
Same logic for the IMEI column.
However, need to pay attention to the initial sorting. For example, in the example above the users list should be sorted in the same way as for the 1st columns (user names) and SmartphoneProvisions list should be sorted correctly as well (1st provision for the 1st user etc).
That sounds awesome! Would work great on an app Iâm working on for a client now. The support for multiple data types is very nice, as I felt that was a slight limitation in the other version. Keep me posted!