Hi i read the documentation and see the videos and i have a last question. can users change their own table and chart, without see or change the other tables?
You have to create a custom column, and name it how you wish, in this example I named it user ID.
First I made a table named Clinic_copy.
Then I made a new column, user ID.
Now, this is the most important detail. When you select ID column for editing, in this case wpDataTables automatically guessed the right column - it will be wdt_ID, this Is the row identifier. Every row has its unique ID. Please check this screenshot :
- Then, when you select the user ID column, this is the User identifier. It must be an integer field, and this field is going to be automatically populated, by the currently logged user ID, when they create a new entry.
This user credential for user "casualty " has user ID 3 in the wp_users database table.
Here is an example, when I am logged in as Administrator, the user ID is 1, this is our Placeholder section, showing the current user ID :
-
Then, I made a Test page and placed this Copy Clinic Table there.
When I log out of Admin and log in as a user causality, as I input a new row, that user can only see the rows he made ( as mentioned earlier, this user ID is 3) :
then every row that user casualty makes, is going to have user ID 3 in this column.
Hi
i read the documentation and see the videos and i have a last question.
can users change their own table and chart, without see or change the other tables?
Hello Mohammed,
Thank you for reaching out to us.
Here is an example i made with a Clinic table.
You have to create a custom column, and name it how you wish, in this example I named it user ID.
First I made a table named Clinic_copy.
Then I made a new column, user ID.
Now, this is the most important detail. When you select ID column for editing, in this case wpDataTables automatically guessed the right column - it will be wdt_ID, this Is the row identifier. Every row has its unique ID. Please check this screenshot :
- Then, when you select the user ID column, this is the User identifier. It must be an integer field, and this field is going to be automatically populated, by the currently logged user ID, when they create a new entry.
This user credential for user "casualty " has user ID 3 in the wp_users database table.
Here is an example, when I am logged in as Administrator, the user ID is 1, this is our Placeholder section, showing the current user ID :
-
Then, I made a Test page and placed this Copy Clinic Table there.
When I log out of Admin and log in as a user causality, as I input a new row, that user can only see the rows he made ( as mentioned earlier, this user ID is 3) :
then every row that user casualty makes, is going to have user ID 3 in this column.
I hope that I explained everything clearly.
Kind Regards,
Uros Jovanovic
[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