We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3212518
Filtering with multiple values in cell
Closed

Comments

  • Remo started the conversation

    Hello,

    i'm asking here because i didn't find an answer on the documentation page (probably my fault)


    In my table i have a column "Language" and this column has values like these:

    IT

    EN

    DE

    IT,EN,DE

    ES


    so i have cells that represent only one language and cells that represent more languages. Is there a way to consider IT,EN,DE as 3 different entities?


    my goal is to have in the filtering dropdown only single voices: IT EN DE ES

    Right now i also see as filtering voice the complete string IT,EN,DE along with the others.

    Maybe is the comma that is a wrong separator?

  •  1,894
    Miloš replied


    Hi, Remo 

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    - You can split the values up individually, to use in a filter, even if they are pulled together in the same cell,

    here is an example.

    5678157465.png

    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.

    2222083284.png

    ; here is the resulting filter multiselectbox of this example:

    9888788418.png

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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