Restrict LOOKUP to record with max value in field

[Haydn_Sonnad1]

Hello!

I’m looking for a way to restrict a lookup to only the record with the max date in a date field.

Context: Managing a vehicle fleet

Bases:

1. Registration
   

2. VIN
   

Desired outcome
Only display the license plate that is associated with the registration record that has the max “license plate exp date” value.

I’m not sure how to go about this. Seems like there may be a way to do so by

1. creating a view in the registration base that only shows the records with the most recent
2. restricting the lookup to that view

but can’t figure out the first step there.

Any help appreciated.

[ScottWorld · Accepted solution]

See this thread, but do the latest date instead of earliest date:

Rollup or Formula to take FIRST record added to a Linked Record Field Formulas

Assuming there is a Date attached to each Event: Follow the example shown in this video: BuiltOnAir Podcast Season 8 Episode 2 Essentially, you’ll be adding a Formula and a Rollup field to the Titles table to get the minimum/earliest date, and a Lookup and Formula field to the Events table to see if that event contains the earliest date for the linked title. Then your {Discovered At} field would use the conditional toggle to only show the name of the Event where the Formula field is “true” for…