Skip to main content

View the latest field

Hi, I’m totally new to Airtable and so far I’ve been fascinated by it. :smiling_face_with_sunglasses:
I started doing is something that allows me to keep the daily balance of different accounts, see image,

So I capture daily transactions and therefore the actual balance is the last recorded .

How can you make a query or a summary, which brings me only the data of the most recent registration of the different accounts?

Thank you very much for your help

Welcome to the community, @Juan_Gutierrez! :grinning_face_with_big_eyes: Is it safe to assume that every account is updated every day? If so, you could create a view that only shows records that match today’s date. Will that suit your needs?

Welcome to the community, @Juan_Gutierrez! :grinning_face_with_big_eyes: Is it safe to assume that every account is updated every day? If so, you could create a view that only shows records that match today’s date. Will that suit your needs?


Many thanks Justin, I forget that I need to think in views :man_facepalming:

Terms & ConditionsAccessibility statement