View last entry date and time regarding all tabs "last update"

#1

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

#2

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
#3

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.

#4

thank you. I’ll try to do it that way and will let you know.
thank you for the quick answer

1 Like