Hi. I am using the Editable Data Table like Excel Plugin.
When a user adds another row (thing), I would like to pre-specify the field values of some columns (text). How can I do that?
I see something that says “Values for autocomplete”, can this be used to pre-specify/assign value to certain fields when a new row is added? If yes, then what is the syntax to be used?
Thanks,
KO
Would be good to know if that is possible.
plugin is very sensitive, one extra space here there does not work. not much documentation also
Hello, @kalyano, @ayotunde1234. Thanks for reaching out.
Unfortunately, it is not possible. You see, the plugin will display on the page your database table, that you have already created, with columns and data types for those columns, that you have already added when you were designing your table.
Example:
On the demo page, we have a table called Stats. It has several columns, in which data types are number and text, in general. If I click the + icon in order to add a new column, I will be able to insert text values into the Month column, because in my database this column has the data type = text.
So, I will be able to type only numbers into the Rating column input field, because the Rating column has data table = number.
Regarding the “Values for auto-complete” field - it is existing on the plugin element, but it is not designed for the new row autocompleting with the data. And it is actually not working for the moment. We will fix or remove it soon because it is not functional.
Yes, indeed, this plugin does not have much documentation. We hope to add more soon. Apologies for the inconvenience.
Regards,