Last Date Published?

[Dylan_Campbell]

I am looking for some help. I am trying to find a script or suggestion that will help my team see when an author last ran. When an editor adds a new record, I want something that will search through one column to check the authors name and if there’s a match take the run date from the column it matches and put into a column with the new record.

[Kamille_Parks]

If you have a table for editors/authors (Table A), and are linking each author to the new records in Table B, you can use a Rollup field in Table A that uses the MAX(values) aggregation to list the latest date associated from the linked Table B records.

Airtable Support

Rollup field overview

A rollup field performs calculations, create aggregates, and build formulas on specific cells from records that are linked to another field in your table. IN THIS ARTICLE Add the rollup fieldChoos...