I have two linked tables in the same base i) Accounts ii) Meetings. I would like to update the “status” field (single select) on the Accounts table based on the the “meeting outcome” field (single select) on the Meetings table.
For example if I create a new record in the Meetings table for Account#5 and I set the Meeting “status” field to “Successful”, I would like to automatically change Account#5’s record in the Account table to “Won”. Conversely, if I create a new record in the Meetings table for Account#5 and I set the Meeting “status” field to “Unsuccessful”, I would like to automatically change Account#5’s record in the Account table to “Lost”.
Can this be achieved with automations? I haven’t used scripts and am not a programmer so not to comfortable using that approach.