Hi, I'm looking for a tables plugin and found you as an option. My problem is, I don't see a way to people edit their own data but in the front-end the whole table is visible
I'm trying to build a database of products where manufactures that have an account can create, edit and delete their entries (but not from others) but the entire list is open to the general public. Also, I wish that admins can manage everyone's entries.
You can't have a table where users can only add and edit only their own data, and still have the whole table visible to them. If you enable "Users see and edit only own data", that's what they'll get.
The only workaround would be to have 2 tables on the page; one - original table, where users can see and edit only their own data, and another (MySQL query based table), which would be created with SELECT * FROM MySQL_Table_name_for_Editing (where "MySQL_table_name_for_editing" is the table's name from the Editing tab above the table of the original table.
I hope this helps, do let us know if you need any further assistance.
Hi, I'm looking for a tables plugin and found you as an option. My problem is, I don't see a way to people edit their own data but in the front-end the whole table is visible
I'm trying to build a database of products where manufactures that have an account can create, edit and delete their entries (but not from others) but the entire list is open to the general public. Also, I wish that admins can manage everyone's entries.
Hope you understand what I mean.
Hi Luan
You can't have a table where users can only add and edit only their own data, and still have the whole table visible to them. If you enable "Users see and edit only own data", that's what they'll get.
The only workaround would be to have 2 tables on the page; one - original table, where users can see and edit only their own data, and another (MySQL query based table), which would be created with SELECT * FROM MySQL_Table_name_for_Editing (where "MySQL_table_name_for_editing" is the table's name from the Editing tab above the table of the original table.
I hope this helps, do let us know if you need any further assistance.