Show data specific to MAX (VALUE) date

[Jarryd_Williams]

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?

[ScottWorld · Accepted solution]

I have covered this topic in 4 recent posts:

Display Last Comment Automations

Welcome to the community, @David_Short! I’m assuming you’ve already created a linked record field between your two tables, so you can link multiple issues to each individual asset? After that, Airtable makes the rest of the setup process unnecessarily complex: First, you have to create a rollup field in your Assets table that points to the Date field in your Issues table. Use the formula MAX(values) Then you have to go back into your Issues table and create a lookup field that looks up the r…

Calculated field in view from latest linked record? Views

Welcome to the community, @Les_Gray! This is pretty tricky to setup in Airtable. I’m assuming that your “owners” table is linked to the “valuations” table, so each owner can be linked to many different valuations. First, you’ll need to go into the valuations table, and you will need to create some sort of a date field so you can determine which valuation is the latest valuation. Then, go back into your owners table and create a Rollup field which points to that date field in your valuations …

Current record based on a date in a group Formulas

Even though this would be a piece of cake in any other database platform, Airtable doesn’t make this process very easy nor intuitive. It is QUITE the process. Solving this will require creating 3 additional fields: 2 new fields in the Certification table (a lookup field and a formula field), and 1 new field in the Client table (a lookup field). Here’s what you’ll need to do: First, you’ll need to go back into your Certification table, and create a lookup field that looks up the new rollup f…

Select the top record on a specific view Views

This is a little bit tricky to setup in Airtable. First, you’ll need to go to the “Seller Details” table in your Airtable base, and you will need to create a Rollup field which points to your “Created Date” field in your “Artwork Bids” table. Use the rollup formula MAX(values), which will give you the latest bid date for that particular item. Next, go back into your “Artwork Bids” table, where you will want to create a lookup field that looks up that brand new rollup field that you just create…

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

[Jarryd_Williams]

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:

[ScottWorld]

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]

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

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