Okay
  Public Ticket #2926016
Multisite
Closed

Comments

  • Kelvin Thom started the conversation

    Hello. If I plan on using wpdatatables on a multisite network, do I need a license for each separate network site? I will be using the multisite network with different paths ( example.com/site1, example.com/site2,) I want the site admins for each site to be able to create their own separate table lookups and not be able to see anyone else's data. Only the data where they are the owner for creating the data. I just need to know if I need wpdatatables for 1 site or unlimited sites.

  • [deleted] replied

    Hi Kelvin

    Thank you for reaching out to us.

    A basic licence is valid for one domain and unlimited number of subdomains. So if you activate the licence on test.com you will also be able to activate it on test2.test.com, test3.test.com... 

    I hope this helps, do let us know if there is anything else we can assist you with.

  • Kelvin Thom replied

    Hmm, ok so then it should work on test.com/site1, test.com/site2, etc.

  • Kelvin Thom replied

    Also I would like for each site to be able to create their own separate table lookups and not be able to see anyone else's data. Only the data where they are the owner for creating the data. Is this possible to keep the data segmented by owner?

  • [deleted] replied

    Hi Kelvin

    If you use the plugin in a multisite on each site you will have a separate backend setting and table. Each subdomain will have its own database, so all tables and charts are unique per subdomain as well.

    You can link data to specific users on one website as well. To do this the table needs to be editable (so you would need to import the file, to create a manual table), and also you need to have the User ID field in the table. Meaning, if John has user ID = 5, when he logs into your WordPress site, and looks at the table, he'd only see his data if you selected the User ID column as the "User ID column" in the Editing tab above the table. If there's no user ID column, and they aren't logging into WordPress, this will not work.

    You can also add the placeholder %CURRENT_USER_ID% as the predefined filtering value in column settings of "User ID" column, and the table will automatically be filtered per the ID of the currently logged in user. You can enable the Show all rows in back-end option from the Editing tab of the table to see all entries in the back-end. You can also edit the table but if you edit the table as an administrator your User ID will be saved when you make the change so make sure to turn off the Users see and edit only own data option before editing.

    8572558340.png

    Please see the video below

    How to create editable tables in WordPress where users edit only own rows - wpDataTables 2.0

    If you want to have a specific column shown for all users you will have to add user ID number 1 next to each one of the values in that column, then copy and paste the same row values below and add user ID number 2 next to them and so on for as many users as you have. You can use the Excel like editor to copy-paste the values so you wouldn't have to add them manually one by one.

    4868874550.png

    You can set this column not to be editable by setting Editing to None, so the users will be able to add the data in the empty fields only.

  • Kelvin Thom replied

    Perfect! Thanks for the explanation and examples. I will save this info. You can close this ticket now.

  • [deleted] replied

    You are most welcomesmile.png

    If there is anything else we can assist you with please don't hesitate to open a new ticket.

    Have a wonderful day!