Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Last Date Published?

262 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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.