Hi! I wanted to know if you have any idea or maybe best practices on how to approach this: I have a column which lists different locations; there are only 5 different locations, but you can choose more than one. The cell input is basically a string which either consists of just one location or a list of multiple locations which are comma-separated (see attached screen).
If I want to use filtering options with this column there is unfortunately no way to use (pre-selected) checkbox or select-box because wpdatatables correctly treats the cell input as a string. My goal is to use a select box which shows all the options which are right now divided by comma instead of the different strings.
You can go to that column's settings, and under Data tab change "Possible values for column" from "Read from table on page load" to "Defined values list".
Then you can add them one by one, and it will work in mutli-select box filter, and editor.
Yeah, there seems to be a bug with the select-box and "Clear Filters". Our developer are aware of this, and they will work on the solution in the future. By the way, did you update the plugin to the latest version (3.0.1)? I didn't check locally, but the issue may have been resolved with it.
2. When you go to Column settings/Data, please change "Number of possible values to load" to "All", and that will load all possible options, and the select box will appear much faster.
Hi! I wanted to know if you have any idea or maybe best practices on how to approach this: I have a column which lists different locations; there are only 5 different locations, but you can choose more than one. The cell input is basically a string which either consists of just one location or a list of multiple locations which are comma-separated (see attached screen).
If I want to use filtering options with this column there is unfortunately no way to use (pre-selected) checkbox or select-box because wpdatatables correctly treats the cell input as a string. My goal is to use a select box which shows all the options which are right now divided by comma instead of the different strings.
Is there a smart way to do this?
Thanks in advance.
Best,
R
Hello Reimer
You can go to that column's settings, and under Data tab change "Possible values for column" from "Read from table on page load" to "Defined values list".
Then you can add them one by one, and it will work in mutli-select box filter, and editor.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Reimer
Yeah, there seems to be a bug with the select-box and "Clear Filters". Our developer are aware of this, and they will work on the solution in the future. By the way, did you update the plugin to the latest version (3.0.1)? I didn't check locally, but the issue may have been resolved with it.
2. When you go to Column settings/Data, please change "Number of possible values to load" to "All", and that will load all possible options, and the select box will appear much faster.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
You're welcome Reimer
I'm glad I could be of service.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables