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!