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.
Last Date Published?
+27If 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.