This would only be possible with Conditional Formatting.
So, you would add these values as integers and add " GB" (note the space before "GB") as a cell suffix, like this:
Cell value "100" would become "100 GB" when you add the suffix;
Cell value "200" would become "200 GB" when you add the suffix;
Cell value "500" would become "500 GB" when you add the suffix;
Cell value "1000" would become "1000 GB" when you add the suffix.
After that, you would need to apply a Conditional Formatting rule where each cell that contains "1000" would be replaced with "Unlimited", like this:
The only issue here is that the Number Range slider wouldn't see this custom cell content, so it would show values between "100" and "1000". This is the only way to achieve anything similar to what you want to see.
that's a good idea, but as you mention, the slider then has a wrong filter. This is difficult to implement. So please just close the ticket unless you can still manipulate the silder. ;-)
Hello support-team,
How I can show a value "unlimted" in a integer Column?
Is there a solution for this?
Data excample:
I have different Webhosting offers with different traffic values "100 GB", "200 GB", "500 GB" and also "unlimited".
Now I need a Filtering with a "Range slider" (number range slider)
with a range 100 GB ---- 500 GB --- unlimited. Is that posible?
Best reagards
Jens
Hello Jens
This would only be possible with Conditional Formatting.
So, you would add these values as integers and add " GB" (note the space before "GB") as a cell suffix, like this:
Cell value "100" would become "100 GB" when you add the suffix;
Cell value "200" would become "200 GB" when you add the suffix;
Cell value "500" would become "500 GB" when you add the suffix;
Cell value "1000" would become "1000 GB" when you add the suffix.
After that, you would need to apply a Conditional Formatting rule where each cell that contains "1000" would be replaced with "Unlimited", like this:
The only issue here is that the Number Range slider wouldn't see this custom cell content, so it would show values between "100" and "1000". This is the only way to achieve anything similar to what you want to see.
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
Hi Aleksandar,
that's a good idea, but as you mention, the slider then has a wrong filter.
This is difficult to implement. So please just close the ticket unless you can still manipulate the silder. ;-)
Thank you.
Jens
Will do, Jens, sorry I couldn't be of any further assistance here.
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