Hi, I'm trying to create a manual table that users will be able to use in order to add their weight and other parameters from the front end.
I'd like to pre-fill the "Weeks" columns with 1,2,3,4 so that at least four rows would already exist (even though with 0.0 values for the measurements) and make THAT visible to all users.
The users should be able to see the 4 rows in the table, AND edit only THEIR data.
I was hoping I would be able to prefill the table on the back-end and the resulting table would be shown to users (who would go and update it further), but it seems like it's not the case. Is there a workaround?
Unfortunately, that is not possible is you turn on option Users can see and edit own data. When you turn on this option and you insert that 4 values it will be visible only to you. What you can do is to make that table that you need and insert that 4 values with option Users can see and edit own data. Then you can make from that table new one(from table name which you can find in field MySQL table name for editing on EDITING tab in table settings of that first table). This table will show all data for all users, but you can change look of that table with conditional formatting that will hide all others rows except that four that you insert. Like that you will have 2 tables on page. First one showing just that four rows(not editable),and second one will show only users data.(editable)
Hi, I'm trying to create a manual table that users will be able to use in order to add their weight and other parameters from the front end.
I'd like to pre-fill the "Weeks" columns with 1,2,3,4 so that at least four rows would already exist (even though with 0.0 values for the measurements) and make THAT visible to all users.
The users should be able to see the 4 rows in the table, AND edit only THEIR data.
I was hoping I would be able to prefill the table on the back-end and the resulting table would be shown to users (who would go and update it further), but it seems like it's not the case. Is there a workaround?
Thank you!
Hi Ross,
Thank you for your purchase.
Unfortunately, that is not possible is you turn on option Users can see and edit own data. When you turn on this option and you insert that 4 values it will be visible only to you. What you can do is to make that table that you need and insert that 4 values with option Users can see and edit own data. Then you can make from that table new one(from table name which you can find in field MySQL table name for editing on EDITING tab in table settings of that first table). This table will show all data for all users, but you can change look of that table with conditional formatting that will hide all others rows except that four that you insert. Like that you will have 2 tables on page. First one showing just that four rows(not editable),and second one will show only users data.(editable)
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables