Last Date Published?

694 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.