Hm I think if I were you I'd just have a formula field to handle this, and get an automation to trigger whenever the formula field gets updated, and to paste the value of the formula field into the multi-select
e.g. if your logic is the following
- Linked field 1 = not empty, multi select option "Linked_Field_1_Filled" added
- Linked field 2 = not empty, multi select option "Linked_Field_2_Filled" added
Then I'd have a formula field that would look like:
IF(
{Linked Field 1}, "Linked_Field_1_Filled"
) & "," &
IF(
{Linked Field 2}, "Linked_Field_2_Filled"
) & ","
And here's an example of copy pasting the formula field values into a multi-select

Hm I think if I were you I'd just have a formula field to handle this, and get an automation to trigger whenever the formula field gets updated, and to paste the value of the formula field into the multi-select
e.g. if your logic is the following
- Linked field 1 = not empty, multi select option "Linked_Field_1_Filled" added
- Linked field 2 = not empty, multi select option "Linked_Field_2_Filled" added
Then I'd have a formula field that would look like:
IF(
{Linked Field 1}, "Linked_Field_1_Filled"
) & "," &
IF(
{Linked Field 2}, "Linked_Field_2_Filled"
) & ","
And here's an example of copy pasting the formula field values into a multi-select

Thanks Adam. Having a formula field in the way you expressed was the first approach I implemented. Then I realised that I needed a multi-select list because I am integrating airtable with something else at the front-end and that something else does not allow me to have a dropdown list to select options for filtering records if the options are expressed in a formula.
Thanks Adam. Having a formula field in the way you expressed was the first approach I implemented. Then I realised that I needed a multi-select list because I am integrating airtable with something else at the front-end and that something else does not allow me to have a dropdown list to select options for filtering records if the options are expressed in a formula.
Ah okay, sorry, I'm a bit confused. When you say "multi-select list", are you referring to a multiple select field?

Ah okay, sorry, I'm a bit confused. When you say "multi-select list", are you referring to a multiple select field?

Yes 🙂
Yes 🙂
Hm okay. After we create the formula field we're using an automation to paste the value in the formula field into the multiple select field though, right?
Hey Adam, I think I have a similar issue. I have 4 currency fields (A, B, C, D), then a multi-select field with options A, B, C, D. If any of the currency fields are >$0, I want the multi-select field to contain the corresponding field name(s).
e.g. if a record has $100 in currency field A and $200 in currency field C, I want the multi-select field to contain "A, C".
I was able to use a "update record" automation to do this, but I can only get it to work for 1 field - currency field A is >$0 so the multi-select returns "A", but when I add another automation for currency field B >$0 --> multi-select returns "B", it overwrites the one for A. How can I get the multi-select field to return more than 1 option based on conditions?