Help

Last Location of an Item

Topic Labels: Formulas
Solved
Jump to Solution
1519 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Abraham_Gluck
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Abraham_Gluck
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

2 Replies 2
Zollie
10 - Mercury
10 - Mercury

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.

Abraham_Gluck
5 - Automation Enthusiast
5 - Automation Enthusiast

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