I have a nutritionist client i'm building a client tracking table for, she wants to be able to track client data so I need them to be able to enter their own data (and only see their own data), also create some graphs and charts from this.
Do you have any good examples / tutorials of how this has been achieved before? Example a personal trainer tracking clients macros or nutritional info.
Is it possible to have a mySQL data table where rows are locked or filtered to the current user?
Is there a better solution that I might not have thought of?
You could enable "Users see and edit only own data" and people would only be able to edit and view the data they've entered if you pass their User ID in the integer column.
If I understood you correctly - the trainer should be able to see all the data, correct? If that's true, you could either enable "View all rows in back-end", or create an SQL query based table where you would pull the first table with
SELECT * FROM wp_wpdatatable_#
# is the database ID of the table, and it can be seen in the Editing tab, when you enable it for the first table.
Hey Guys,
I have a nutritionist client i'm building a client tracking table for, she wants to be able to track client data so I need them to be able to enter their own data (and only see their own data), also create some graphs and charts from this.
Do you have any good examples / tutorials of how this has been achieved before? Example a personal trainer tracking clients macros or nutritional info.
Is it possible to have a mySQL data table where rows are locked or filtered to the current user?
Is there a better solution that I might not have thought of?
Hello Matthew
You could enable "Users see and edit only own data" and people would only be able to edit and view the data they've entered if you pass their User ID in the integer column.
If I understood you correctly - the trainer should be able to see all the data, correct? If that's true, you could either enable "View all rows in back-end", or create an SQL query based table where you would pull the first table with
SELECT * FROM wp_wpdatatable_#
# is the database ID of the table, and it can be seen in the Editing tab, when you enable it for the first table.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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