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?
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.
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.
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?
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
@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.
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?
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!
Hey @BubbleSam,
I missed your answer as well!
Thanks for the update. Would be awesome to have this functionality. Right now I had to revert back to RG with a combination of multi dropdown / searchbox / input elements. And with it the pain of formatting.
But ready to jump back on your plugin when this multi-search feature is live!
Hi @tom17 , whatās your exact use case, please? Is it possible for example to pre-filter all the records and after that pass all of them the Dynamic Tables plugin?
Hey @BubbleSam - do you know if there is a way to show a list of items in one field with a bit of formatting? I have a ālist of activitiesā in one record, and I want to show the list separated with bullets or something similar. Pic here: