If i understood, you wish to manually define which values should come up as available choices for filtering, right?
If that is the case, you can do it like this :
-
- You can split the values up individually, ( or manually input any values you need)
to use in a filter, even if they are pulled together in the same cell,
here is an example.
The table pulls the values from all cells, so since you have multiple values together in one cell, it sees it as a unique value.
What you can do is open this column's settings, go to the Data tab. In there, change "Possible values for column" from "Read from table on page load" to "Define values list":
Then, in the "Values list", manually input the individual values that should be included in this column, and that's it. It should allow you to select each value on the filter, as an individual selection.
; here is the resulting filter multiselectbox of this example:
If you need more details, please contact us for further info. Thanks.
i need some help with placeholder / filtering
i use an exel file with many people entry
i got these 3 ppls for exemple:
1. Smith Jhon David
2. David Jhon Smith
3. Smith Michael Jhon
4. Michael Smith David
how can i use placeholder in order to show only 1. Smith Jhon David and 2. David Jhon Smith? (as u can see is the same person)
if i put to %var1% "smith" i will get all 4 entries
if i put "jhon" i will get 1, 2, and 3
if i put "david" i will get 1, 2, and 4
i have to use %var2% and/or %var3% etc? if yes, how can i do this?
Hi, Kudor
Thanks for reaching out to us
If i understood, you wish to manually define which values should come up as available choices for filtering, right?
If that is the case, you can do it like this :
-
- You can split the values up individually, ( or manually input any values you need)
to use in a filter, even if they are pulled together in the same cell,
here is an example.
The table pulls the values from all cells, so since you have multiple values together in one cell, it sees it as a unique value.
What you can do is open this column's settings, go to the Data tab. In there, change "Possible values for column" from "Read from table on page load" to "Define values list":
Then, in the "Values list", manually input the individual values that should be included in this column, and that's it. It should allow you to select each value on the filter, as an individual selection.
; here is the resulting filter multiselectbox of this example:
If you need more details, please contact us for further info. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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