I have a wpdata table with 300 records. Each record is a "dog trick." What I'd like, is for each user to be able to checkmark several tricks that they are working on. I'd like that data saved, so when they return to the website a month later, their checkmarks are still there. Is there any way to accomplish this?
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
The only way to render a checkmark symbol/image in our tables is with Custom HTML.
You could manually try to make custom HTML and CSS, but in my opinion it is much easier to just find a free image of a checkmark that you can use, and use the link/URL path to that image,
then the image will render in a String Cell of our tables.
-
For example, in my table, if i edit a cell and set it to one of our image paths like this :
In my String Column of a table, it looks like this :
But for editing, it gets a bit tricky, with our current capabilities.
To go in more details for your use-case, i did some testing and the best i could come up is to add a String Column to and Editable Table, such as if you have a Manual Table.
First set the Editor Type of this column as "One Line Edit", this way you can input one row of data with this custom HTML of a checkmark image.
Then, add one row of dummy data with this image path ( The safest will be to download this / or any other checker image, and save it in your WP Media Library, then past the URL from your library inside the HTML img source tag).
After that, you can set the Editor Type to "Single value selectbox",
and allow to add an Empty Value, like in my screenshot. ( Make sure to also set number of possible values to "all", as we have a small bug right now, if we set to a fixed value there)
Now, when a user tries to edit this field, they will get two choices, the custom HTML for your checker image,
or a blank value.
If they choose the one with the HTML "img src" the checker will render in the cell.
-
Alternative approach can be to set up a value of "yes", or "1" or anything else like that.
Then you can add a Conditional Rule to this Column, in Conditional Formatting tab,
like "if the cell value is yes, then transform it to checker image". Like this screenshot :
If you try the second method, you won't need that "one row of dummy data",
but you can set a predefined possible value of editing as "Yes", in the Column settings/Data tab,
and allow an empty value for the selectbox.
Then a user will see possible value of "blank" or "Yes", for each trick,
if they choose "Yes" - it converts the cell to the checkbox.
-
2. In regards to each user having different checkmarks set for themselves,
then when they come back later - their checkmarks are still there,
i did not fully understand this point.
-
If you mean to have one same table, and same rows - while different users would see the same cell checked when user A logs in,
while if user B logs in, he sees the same row but without a checkmark;
something like that is not currently possible.
If you mean to achieve this, for same "row ID" to show different data for different users,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
Or, if you simply mean for each user to have their own rows of data, and to allow them to only see and edit their rows,
I have a wpdata table with 300 records. Each record is a "dog trick." What I'd like, is for each user to be able to checkmark several tricks that they are working on. I'd like that data saved, so when they return to the website a month later, their checkmarks are still there. Is there any way to accomplish this?
Attached files: Untitled-1.png
Hi, Kyra.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
The only way to render a checkmark symbol/image in our tables is with Custom HTML.
You could manually try to make custom HTML and CSS, but in my opinion it is much easier to just find a free image of a checkmark that you can use, and use the link/URL path to that image,
then the image will render in a String Cell of our tables.
-
For example, in my table, if i edit a cell and set it to one of our image paths like this :
In my String Column of a table, it looks like this :
But for editing, it gets a bit tricky, with our current capabilities.
To go in more details for your use-case, i did some testing and the best i could come up is to add a String Column to and Editable Table, such as if you have a Manual Table.
First set the Editor Type of this column as "One Line Edit", this way you can input one row of data with this custom HTML of a checkmark image.
Then, add one row of dummy data with this image path ( The safest will be to download this / or any other checker image, and save it in your WP Media Library, then past the URL from your library inside the HTML img source tag).
After that, you can set the Editor Type to "Single value selectbox",
and allow to add an Empty Value, like in my screenshot. ( Make sure to also set number of possible values to "all", as we have a small bug right now, if we set to a fixed value there)
Now, when a user tries to edit this field, they will get two choices, the custom HTML for your checker image,
or a blank value.
If they choose the one with the HTML "img src" the checker will render in the cell.
-
Alternative approach can be to set up a value of "yes", or "1" or anything else like that.
Then you can add a Conditional Rule to this Column, in Conditional Formatting tab,
like "if the cell value is yes, then transform it to checker image". Like this screenshot :
If you try the second method, you won't need that "one row of dummy data",
but you can set a predefined possible value of editing as "Yes", in the Column settings/Data tab,
and allow an empty value for the selectbox.
Then a user will see possible value of "blank" or "Yes", for each trick,
if they choose "Yes" - it converts the cell to the checkbox.
-
2. In regards to each user having different checkmarks set for themselves,
then when they come back later - their checkmarks are still there,
i did not fully understand this point.
-
If you mean to have one same table, and same rows - while different users would see the same cell checked when user A logs in,
while if user B logs in, he sees the same row but without a checkmark;
something like that is not currently possible.
If you mean to achieve this, for same "row ID" to show different data for different users,
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
Or, if you simply mean for each user to have their own rows of data, and to allow them to only see and edit their rows,
you can try our feature for this as explained on this Documentation.
Let me know if that helps, and if you meant to achieve something different, please elaborate a bit more on that point.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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