Hello Glide Community,
I’m looking to the best way to have in my results tab a component showing the last update (entry) made in all my tabs.
So I have a sheet with 5 different tabs connected to 5 different form button. Participants can enter data potentially in all tabs but also to only one.
I want in my app results tab to have a component showing the date and time of the last entry made in, regarding all tabs/form. => Last Update : ??/??/?? 05:46pm
What is the best way to do it ?
Thank you in advance for your help and advice
In the Sheet you want to have that data, possibly create 5 single value columns to 5 timestamp columns in 5 sheets, return the last value.
Then possibly use a max formula inside a math column to get the latest value from those 5 single value columns, I’m not totally sure it works with datetime.
1 Like
Another alternative is to create a Sheet with just one column, then redo your forms to overwrite a timestamp value in that Sheet alongside an add row action.
thank you. I’ll try to do it that way and will let you know.
thank you for the quick answer
1 Like