Can the "Last Modified" date for a sheet by pulled across from Sheets and displayed in wpdatatables or on Elementor page to allow reader of webpage to know when data was last updated.
I am sorry, but we do not have a built-in solution to pull the information when the data was last updated from your source Sheet.
You will need to add a custom field to your Sheet which will include a Google's function/formula to always show the last update time for each row, or a similar function.
I believe you should be able to find some easy tutorials about that online to make it work, I am just not sure if you can get it to always show the 'last time anything on the Sheet was updated' - or if each row can just show the last update time and/or date.
That is not covered by our Support, but I hope it helps as an idea.
2. Just one important note : If you add any kind of formula to the Sheet, then you need to use this workaround method - to connect a table from data from a Sheet with Formulas, as shown on our Guide.
Can the "Last Modified" date for a sheet by pulled across from Sheets and displayed in wpdatatables or on Elementor page to allow reader of webpage to know when data was last updated.
Hi John,
I am sorry, but we do not have a built-in solution to pull the information when the data was last updated from your source Sheet.
You will need to add a custom field to your Sheet which will include a Google's function/formula to always show the last update time for each row, or a similar function.
I believe you should be able to find some easy tutorials about that online to make it work, I am just not sure if you can get it to always show the 'last time anything on the Sheet was updated' - or if each row can just show the last update time and/or date.
That is not covered by our Support, but I hope it helps as an idea.
2. Just one important note : If you add any kind of formula to the Sheet, then you need to use this workaround method - to connect a table from data from a Sheet with Formulas, as shown on our Guide.
I hope it helps.
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
Thanks Milos for prompt response - given me ideas, but back to the drawing board !!
John