Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Last Location of an Item

Topic Labels: Formulas
Solved
Jump to Solution
462 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, Thanks in advance for reading my post.

I have a table which includes a list of equipment, and then I have another table that contains dates of bookings (a booking is per day), location of booking and other fields.
I would like to be able to see on the first table the last location of a booking and it’s date.
Is that possible to do?

1 Solution

Accepted Solutions

I found a similar post that has a template base that does almost the same

See Solution in Thread

2 Replies 2

Hey Abraham! Yes, if you use a few fields together. The most important of them is a linked record field, which connects the two tables. Once that’s set up, you can use a rollup field to sort associated dates by most recent. And then (optionally) a formula field to pluck the first date from that list.

I found a similar post that has a template base that does almost the same