Question About Displaying Specific Rows in a Google Spreadsheet-Linked Datatable
Hi Support Team,
I have a question regarding creating a datatable linked to a Google Spreadsheet.
I successfully created the datatable and linked it to the Google Spreadsheet, which works perfectly. All the data appears correctly in the table on my website (URL: see above).
My question is: How can I display on my website only the specific row from the datatable that corresponds to the email address of the logged-in user?
For a table linked from a Google Sheet, I presume you have a column in your source Google Sheet, which stores all the values for each user Email, right?
Now, in the table back-end, you can add %CURRENT_USER_EMAIL% in column settings -> Filtering, under "Predefined filtering value". Here is a screenshot example. Just make sure this column's filter type is set as "Text".
If you don't wish to allow the front-end user to change or see the filter - you can hide this column from front-end and it will still pre-filter the table. Here you can learn how to hide/show columns.
Question About Displaying Specific Rows in a Google Spreadsheet-Linked Datatable
Hi Support Team,
I have a question regarding creating a datatable linked to a Google Spreadsheet.
I successfully created the datatable and linked it to the Google Spreadsheet, which works perfectly. All the data appears correctly in the table on my website (URL: see above).
My question is: How can I display on my website only the specific row from the datatable that corresponds to the email address of the logged-in user?
Thank you for your help!
Best regards, Peter
Hi Peter,
For this - you can use our dynamic placeholder
Please check more details on how our Placeholders work here.
For a table linked from a Google Sheet, I presume you have a column in your source Google Sheet, which stores all the values for each user Email, right?
Now, in the table back-end, you can add %CURRENT_USER_EMAIL% in column settings -> Filtering, under "Predefined filtering value". Here is a screenshot example. Just make sure this column's filter type is set as "Text".
If you don't wish to allow the front-end user to change or see the filter - you can hide this column from front-end and it will still pre-filter the table.
Here you can learn how to hide/show columns.
Let me know if that works for your use-case.
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