I have a base called "Tasks" where each record has an Assignee.
I created a new base called "Timesheet" to enter the time spent on each Task with a form or interface.
When a new Timesheet record is associated with a Task record, I would like the Timesheet table to add automatically the Assignee for the Task related to that Time entry.
I'm trying to get this done by having an Automation that looks for Timesheet records which have an Associated Task not empty, then finding the corresponding Task in the Task base, and finally adding the same Assignee to that Timesheet record.
However, the Automation does not allow me to search using the "Associated Task" field because it says "No valid nested options".
Is there a way to get around this? Or a better way to connect my tasks and assignees to a timesheet?
Many thanks!!! 🙂