I have particular needs for a table application and was wondering if wpDataTables can do the following:
1) I need people to complete a Gravity Forms form which is written to a table. As part of this form, they would choose a person from a dropdown (that field would be called 'Manager' when written to the database).
2) Once they have all completed the form, I need to be able to add to the resultant table, a set of fields which can be completed by the Managers at a later date.
3) These Managers would log in to WordPress using a membership plugin (if needed) and would only have access to the people in Step 1 who had identified them as their Manager. They would be able to view and update all records where they were the Manager, and not have access to any other records.
4) I would also need a set of users who had access to everything in the table
Has anyone done anything like this? is it feasible?
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
With Gravity Forms-based tables, you can enable the option for users to see only their own entries, but defining which manager will see which rows in the table is not possible.
Only Administrators of the website have access to the tables in the back-end, and at the moment there's no way to change that.
Maybe you would be able to achieve this if you skip the use of our Gravity Forms add-on, and use SQL Query-based tables instead. Pulling data from Gravity's database tables is somewhat complex, as they store data in multiple tables, so they have to be joined together through the query to display the results.
If you are able to do this, you may be able to link the manager user to the wp_users entry and be able to display only the rows where their user ID is found.
Hi,
I have particular needs for a table application and was wondering if wpDataTables can do the following:
1) I need people to complete a Gravity Forms form which is written to a table. As part of this form, they would choose a person from a dropdown (that field would be called 'Manager' when written to the database).
2) Once they have all completed the form, I need to be able to add to the resultant table, a set of fields which can be completed by the Managers at a later date.
3) These Managers would log in to WordPress using a membership plugin (if needed) and would only have access to the people in Step 1 who had identified them as their Manager. They would be able to view and update all records where they were the Manager, and not have access to any other records.
4) I would also need a set of users who had access to everything in the table
Has anyone done anything like this? is it feasible?
Many thanks in advance.
Hello Gavin
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
With Gravity Forms-based tables, you can enable the option for users to see only their own entries, but defining which manager will see which rows in the table is not possible.
Only Administrators of the website have access to the tables in the back-end, and at the moment there's no way to change that.
Maybe you would be able to achieve this if you skip the use of our Gravity Forms add-on, and use SQL Query-based tables instead. Pulling data from Gravity's database tables is somewhat complex, as they store data in multiple tables, so they have to be joined together through the query to display the results.
If you are able to do this, you may be able to link the manager user to the wp_users entry and be able to display only the rows where their user ID is found.
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
Hi Aleksandar,
Many thanks for getting back to me with such a detailed response.
Best wishes,
Gavin
You're welcome, Gavin
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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