Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Nov 30, 2021 04:21 PM
I have a basic two table design: tblACCOUNTS and tblACTIONS. The tblACTIONS has these fields: Description, Date, Status, and Account. The latter is the link back to the tblACCOUNTS records.
tblACTIONS will have lots of records for each Account, but typically only a few with Status=Open and only one with Status=Open AND the most recent Date for that one Account.
I want to have two fields in the tblACCOUNTS that show me the latest Action record Description and Date, where these query/filter criteria apply (in pseudo SQL):
the result being my tblACCOUNTS shows not only my tblAccount native fields, but also the date and description of the “last action” (as defined in the above pseudo SQL) for that account on the one row.
Can I do this? How?
Tks.
Nov 30, 2021 06:53 PM
Welcome to the community, @Daniel_Poor1!
Check out this thread, which will likely help you: