I need to be able to link a User ID to a specific User on my Website using wpDataTables. I am unable to find a way. I imported an existing table from a excel document and already possess users. I now need to link the User ID so that the specified users can only view their own portion of the Table. I also need to know if some users, example Administrators can view and edit all dat but others can only view their own data.
Yes, of course, this can be done. Please take a look at our documentation and see how this can be done. Please make sure to check out the video on that page, as it explains how you can allow admins to view and edit all entries.
Thank You for the reply. My issue is not that it can be done, it is more of an issue to link existing users with a user id to an already populated table. I imported quite a massive table and already possess users that needs to access the information linked to their profile.
My other question is that at times, i receive more than one user of the same company and they must be able to both access the info under that company, is this possible.
In order to achieve this, you'd need to add an ID column to the existing Excel file, and assign a unique ID to each customer (same ID for two or more customers that come from the same company).
Then, you'd need to create a manual table from that Excel file (use the third option when creating the table - import). That table is being stored in PHPMyAdmin with auto-assigned name, for example "wp_wpdatatable_15".
So, to create the final table, you need to create an SQL query based table, where you'd generate a query with CONCAT function in mysql. On this link you have example how to achieve this with query.
Good Morning
I need to be able to link a User ID to a specific User on my Website using wpDataTables. I am unable to find a way. I imported an existing table from a excel document and already possess users. I now need to link the User ID so that the specified users can only view their own portion of the Table. I also need to know if some users, example Administrators can view and edit all dat but others can only view their own data.
Thank you
Hello Danie.
Thank you for your purchase.
Yes, of course, this can be done. Please take a look at our documentation and see how this can be done. Please make sure to check out the video on that page, as it explains how you can allow admins to view and edit all entries.
I hope this helps.
Best regards.
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
Good Morning Aleksander
Thank You for the reply. My issue is not that it can be done, it is more of an issue to link existing users with a user id to an already populated table. I imported quite a massive table and already possess users that needs to access the information linked to their profile.
My other question is that at times, i receive more than one user of the same company and they must be able to both access the info under that company, is this possible.
Kindest Regards
Hey Danie.
Understood.
In order to achieve this, you'd need to add an ID column to the existing Excel file, and assign a unique ID to each customer (same ID for two or more customers that come from the same company).
Then, you'd need to create a manual table from that Excel file (use the third option when creating the table - import). That table is being stored in PHPMyAdmin with auto-assigned name, for example "wp_wpdatatable_15".
So, to create the final table, you need to create an SQL query based table, where you'd generate a query with CONCAT function in mysql. On this link you have example how to achieve this with query.
I hope this helps.
Best regards.
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
Thank You very much for the info. If i am unable to achieve this, i will make contact again. Seems fairly simple.
Kindest Regards
Sure thing, Danie.
Please let me know.
Best regards.
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