I have two tables, Projects and Employees. Employees are assigned to a Project as a linked record. I'm trying to create an automation that on record updates and creation of the employee field on the Project, a note field is updated with something like "Employee A assigned to Project B on X/X/XX" to keep a history of the assignments.
How do I find the note field of the Employee to update when the change happened on the Projects table? The Find Records action won't let me select the Employee Name or RecordID.
