WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Can a field in tablepress reference another field in another table? (5 posts)

  1. barnsley242
    Member
    Posted 1 year ago #

    Is it possible for a TablePress field to reference another field in another TablePress field in another table?

    Here's what I am trying to do:
    I would like users to upload their own data to a field (I can do this bit by using another plugin to restrict access to a specific user).
    But I would then like a master table - which pulls in all the data from all other users together (i.e. pulls in data from several fields and makes one big table).

    e.g.
    Imagine 10 golf score charts where 10 individual users upload their scores.
    Then, imagine a master table which is created from all 10 of the above separate tables.
    The collated table would allow sorting - so would look like 1 big league table.

    - The benefit of this is security - as no other user could amend anyone elses table row.
    As far as i'm aware there is no other way of letting individuals contribute to a table securely and only edit their table row?

    http://wordpress.org/extend/plugins/tablepress/

  2. barnsley242
    Member
    Posted 1 year ago #

    I don't think is going to work as stated above - because it seems that role access to TablePress is either a YES or NO blanket access, therefore:
    anyone who has access to one table in TablePress will have access to all tables (and so not secure to let everyone edit other entries).

    So the only way I can see this working - is if another database driven table is used alongside TablePress and then get TablePress to reference this data..?

    If I can use another table, I was hoping I could do some kind of referencing like this (below) inside a tablePress field?
    [table id=1; row=4; field=3;]

    so, firstly - is it possible to insert some kind of query string inside a tablePress field?

  3. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    thanks for your question, and sorry for the late answer. As I was on vacation, I didn't have a chance to reply earlier.

    You are right. If a user can access/edit a TablePress table, he can access/edit all tables (unless you intercept/extend the capability handling with custom PHP code).

    Now, accessing external database tables from TablePress is not possible. (You can however access other TablePress tables with a similar Shortcode as you posted, but that won't help here.)

    So, in summary, this means that a custom PHP/mySQL solution will be better for your use case. With that, you could manage the individual upload/data entry, and then use PHP to create a summary table. If you then want that to be sortable, you'll just need to load and invoke the features of the external DataTables JavaScript library from http://www.datatables.net (that's the library that TablePress uses) manually.

    Regards,
    Tobias

  4. XtremePC
    Member
    Posted 11 months ago #

    You can however access other TablePress tables with a similar Shortcode as you posted

    do you mind sharing how we can share data between 2 different tables as you mentioned?

  5. TobiasBg
    Member
    Plugin Author

    Posted 11 months ago #

    Hi,

    thanks for your question. That mentioned Shortcode is available as a TablePress Extension. Please see http://tablepress.org/extensions/table-cell-shortcode/ for more information.

    Regards,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic