How can I make it so that the logged-in user can only view their own entries? I have all the entries going into google sheets and I have the user ID in a column.
How can I display a table using google sheets and make it so that the user can only view their rows on that google sheet??
The only way you can do this with a table linked to Google Sheets is to add the %CURRENT_USER_ID% placeholder as a predefined filtering value to the User ID column:
This needs to be a text filter in order for the plugin to recognize the placeholder.
Then, once you do that, we can help you with some custom CSS that would hide the filter from the page, so your users aren't able to change the value they filter by.
How can I make it so that the logged-in user can only view their own entries? I have all the entries going into google sheets and I have the user ID in a column.
How can I display a table using google sheets and make it so that the user can only view their rows on that google sheet??
Thank you!!
Hello Dylan
The only way you can do this with a table linked to Google Sheets is to add the %CURRENT_USER_ID% placeholder as a predefined filtering value to the User ID column:
This needs to be a text filter in order for the plugin to recognize the placeholder.
Then, once you do that, we can help you with some custom CSS that would hide the filter from the page, so your users aren't able to change the value they filter by.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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