Help

Automation to use a formula within update field

Topic Labels: Automations
468 1
cancel
Showing results for 
Search instead for 
Did you mean: 
rfscott2016
6 - Interface Innovator
6 - Interface Innovator

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

 

1 Reply 1
Sho
11 - Venus
11 - Venus

In this way, the values of two select fields can be combined.

2023-09-19 090921.png