Adding columns and populating data to table on the fly

  • Resolved spbilleaud

    (@spbilleaud)


    11 years 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://www.ads-software.com/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    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

    Thread Starter spbilleaud

    (@spbilleaud)

    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

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

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

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Adding columns and populating data to table on the fly’ is closed to new replies.