Require a date field entry to be after a date ente...

[Leo_Flint]

Hello lovely community!

I have a table [Assets] with new entries being created based on video assets in a dropbox via a make(integromat) integration. thats working nicely.

each file ends with a version tag “_v2205181930” which is _v YY MM DD hh mm - which i can extract, read and convert to a date format that airtable understands.

each file auto-links itself to an entry in a [Main] table using a 3 digit ID number. this also works nicely.

if i have two entries in [Assets]

101_SomeRandomWords_v2205181930.mov
101_SomeRandomWords_v2205182000.mov

both linked to entry “101” in [Main]

i want for any entry in [Main] that has more than one linked asset, to compare the date tag in each, find which is the newest and for any older entires tick a checkbox column called “Old”

I cannot for the life of me work out how to achieve this having tried mutiple formulas, lookups, rollups and even poked aorund at scripting [not my area of expertise]

Thank you

[Kamille_Parks · Accepted solution]

See the response here:

Get and show latest status by person via form & view Ask the community

It’s been covered a few times here: Team Members Table: get a Rollup field to show the MAX(values) of the {Date of Entry} field Status Messages Table: get a Lookup field of that^ Rollup field. Status Messages Table: get a Formula field that does IF({Date of Entry} = {Lookup field}, 1, 0) Filter your view by where the Formula field = 1

See also this episode of BuiltOnAir where this type of setup is covered: BuiltOnAir Podcast Season 8 Episode 2 - YouTube

Instead of it being a Checkbox field, it would be a formula where IF({Latest Date} != {Date}, "✔")

[Leo_Flint]

Thank you @Kamille_Parks very helpful!