Okay
  Public Ticket #3640215
Table Sorting
Closed

Comments

  •  1
    Gene started the conversation

    I have a form i've setup using formidable forms: https://scpreservationtoolkitfull.flywheelsites.com/preservation-tools/find-an-expert/submit-your-profile/

    There is a checkbox selection "Professional Capabilities" and I would like my WPTables table to sort these based on what is submitted via the form on this page: https://scpreservationtoolkitfull.flywheelsites.com/preservation-tools/find-an-expert/

    I have the filter for that table setup, and i've defined the values in WPTables, however when the user submits the form it saves all the checkbox selections for that individual submission as one string... not the pre-defined one's i've defined in the table settings, thus breaking the sorting.
    How can I do this properly?

  •  1,845
    Miloš replied

    Hi Gene,

    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


    2. If I understood, you already did all this, and now when a new row is entered, that somehow 'breaks' this filter selection?

    We are not able to reproduce that, so can you please send me remote access to check the Table back end setup?


    Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.


    And point us to the Table ID.

    Thanks.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    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