Okay
  Public Ticket #3363633
SIngle User
Closed

Comments

  • Karl Williams started the conversation

    Hi, I am running a habit coaching membership. 

    I want to be able to show the data for a single logged-in user on their dashboard and also display the data in a leaderboard with other users. 

    Is this possible?

    Thanks

  •  1,846
    Miloš replied

    Hi, Karl.

    1. In terms of limiting a table to only show rows for each logged in user ( for the currently logged user ID),

    we have this feature :

     Creating Editable Tables in WordPress where users can see and edit only their own data.

    Please check out more details on that hyperlink, let me know if that helps for limiting the data per each user on their dashboard.

    If you mean to achieve something else, please elaborate a bit more and if you can show us any kind of examples what is needed with screenshots or a Video.


    2.  If you wish to allow editing only for the rows that belong to the "currently logged user",

    you can use the feature mentioned above,  but that limits that the user can only see and edit their own rows;

    on the other hand if you need another table that will show "all rows",

    you can achieve this with two separate tables.

    -

    The first SQL Table ( or Manual Table) can be with that limitation and allowed editing;

    while for this other "public table" /leadearboard,

    you can make another SQL Table.  First check in the initial Table, under Editing tab in table settings, what is the MySQL Table Name.

    Then you can make a new SQL Table with a Query like :

    SELECT * FROM TableName

    This new table will pull the same data from the database, but you can set up completely different limitations/disable editing,  show/hide different columns, filters, etc...

    -

    Let me know if that helps, or if you need a different use-case, please elaborate a bit more and we can advise.

    -

    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Let me know if you have any additional questions. smile.png


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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