In my automation I have a trigger when a synced table from another base updates a {risk} field.
Automation is currently like this:
When a record is update (synced table - {risk} field
Find record in project list table which matches the trigger record
Update record (airtable id from Find Record step) {Risk Type} (field in the project list table) with {Risk} value in the Synced table {risk} field. But I want to concatenate the values in {Risk Type} field. Another words I want keep a previous value and add the new updated value.
{Risk} field in the synced table is a single select
{Risk type} field in the project list is a multiple select
Both have the same select values
Scenario: week 1: {Risk} field is set to PTO, result {Risk Type} is set to PTO
Week 2: {Risk} field is set to Scope, result {Risk Type} is set to PTO, Scope
