We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1689451
Visibility of the data in the table
Closed

Comments

  • billmondei started the conversation

    Hi,

    Is it possible to make the data in a table private to every user, but also let the admin see the data of all users? (But the rest of the users are not supposed to see each other's data)

    Example:

    People on my weigh-loss site would like to enter measurements every day. They are supposed to see only their own data, not anyone else's. But as admin, I need to see their progress, so I need to be able to see their measurements.

  • [deleted] replied

    Hi billmondei,
    Thank you for your inquire.

    It is possible to allow users to see and edit their own data. You can find more information about it in our - Documentation. For admin to be able to see all the data from users you need to create one more table which will be MySQL query based table and will contain all the columns from previous table. So if you created manual table for users which creates table in your database called "wp_wpadatables_1" you will create MySQL based table from query 

    SELECT * FROM wp_wpadatables_1

    and in it admin will be able to see all the data. We do have plans to develop option which will allow admins to see all the data in the same table in the backend in the near future.