Okay
  Public Ticket #3142259
tech question
Closed

Comments

  • Mohammed started the conversation

    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?

  •  1,187
    Uroš replied

    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.

    9060471295.png

    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 :

    7863918915.png

    - 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.

    3868223118.png

    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 :

    5429141708.png

    -

    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) :

    8005514896.png

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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