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.
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.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.