Help

Show data specific to MAX (VALUE) date

Solved
Jump to Solution
3940 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Jarryd_Williams
5 - Automation Enthusiast
5 - Automation Enthusiast

Good Day!

I was wondering if I could get some help with a scenario:

In the scenario a particular individual could have multiple records linked to them within another table. In the scenario let’s use contracts as an example.

1 individual could have multiple contracts with start and end dates, along with an attachment.
In the “Master” table we can quite easily look up the Start and End Dates based on a MAX(VALUE), but my question is this:

How would I go about linking THAT SPECIFIC contract to the given dates without showing all other contracts?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

I have covered this topic in 4 recent posts:

I also covered this topic in depth on this week’s BuiltOnAir video podcast:

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

I have covered this topic in 4 recent posts:

I also covered this topic in depth on this week’s BuiltOnAir video podcast:

Thanks. To be honest I had seen this solution and similar, I just found it to be unnecessarily complicated. But I guess it gets the job done.

Thanks for the help. :slightly_smiling_face:

If there was an easier way, I would’ve posted it. You should email support@airtable.com and ask them to make this easier.

Jarryd_Williams
5 - Automation Enthusiast
5 - Automation Enthusiast

@ScottWorld Thanks so much for the help. I have forwarded the request onto Airtable.

I appreciate you taking the time. Very helpful. :blush: