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
Best answer by Justin_Barrett
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?
+21Welcome 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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.