WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Adding columns and populating data to table on the fly (4 posts)

  1. spbilleaud
    Member
    Posted 5 months ago #

    My site, PartnerSimple.com, is using--

    • TablePress: 1.3
    • TablePress (DB): 23
    • TablePress table scheme: 3
    • Plugin installed: 2014/02/25 03:15:50
    • WordPress: 3.8.1
    • PHP: 5.4.24
    • mySQL (Server): 5.5.35-cll
    • mySQL (Client): 5.5.35

    I am also using the theme Customizr (child) with Gravity Forms 1.8.4 and Groups 1.4.7.

    My goal is to use the table created in TablePress to compare information provided by two or more users. I think the solution will involve a SQL query and a set of conditional statements that I don't know how to write.

    Here's a description of where I am: the information to be displayed on the table will be exactly 7 items selected by users from a Gravity Forms checkbox list of 40 items. I have created a table listing the 40 items in column A and a header in row 1.

    When no fewer than two users select 7 items, I want TablePress to populate (i) column B with the first user's name in header row 1 and place an X next to 7 of the 40 corresponding items, and (ii) column C with the second user's name in row 1 and display his or her remaining selections in the same way. Any additional users will be handled the same way.

    I have a few ideas of how to approach this task but no clue how to implement it. For example, on the page where the user selects which results they wish to see, I can provide a set of fields in which each user can include the userID of each other user against whose results they want theirs compared.

    The rest is mystery. Any ideas? I also open to alternative ways of accomplishing this task which don't involve using TablePress.

    Many thanks in advance!

    https://wordpress.org/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 5 months ago #

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, I'll have to disappoint you here. This is not something that is possible with TablePress really. TablePress is not meant to be a database system and does not possess querying mechanism that would be necessary here.
    You should consider a custom PHP/mySQL solution for this project.

    Regards,
    Tobias

  3. spbilleaud
    Member
    Posted 5 months ago #

    I appreciate the insight. That was becoming my suspicion anyway. I just didn't have any other experience with this plugin so just wanted to make sure.

    Thank you,
    Susan

  4. TobiasBg
    Member
    Plugin Author

    Posted 5 months ago #

    Hi,

    no problem, you are very welcome! Sorry that I couldn't provide a solution here.

    Best wishes,
    Tobias

Reply

You must log in to post.

About this Plugin

About this Topic