You should be able to have both fields’ values by putting a comma in between the 2 fields.
First choose Field B’s value, then put a comma, then choose Field A’s value.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
You should be able to have both fields’ values by putting a comma in between the 2 fields.
First choose Field B’s value, then put a comma, then choose Field A’s value.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Just check if there is a value in the original linked record field first. If there isn’t a value already, the comma might cause problems. You can use a condition in the automation to check for the existence of prior linked records.
Just check if there is a value in the original linked record field first. If there isn’t a value already, the comma might cause problems. You can use a condition in the automation to check for the existence of prior linked records.
Great catch! What I wrote above would ONLY work if there was already a pre-existing value. So be sure to use conditions to trap for both situations (pre-existing value & no pre-existing value).
Thank you both for your help. That did it!
For posterity and other non-coders out there, i had to add Field B, one comma, and Field B, with NO SPACES between the comma and the fields. and i created two versions of the same action, one with the condition that Field B is NOT empty and one with the condition that Field B IS empty.
PS: it would be great if Airtable prompted some of this coding help, particularly for those of us who use Airtable specifically because we aren’t coders. it could just be part of the help text for this kind of field when building automations.
Just check if there is a value in the original linked record field first. If there isn’t a value already, the comma might cause problems. You can use a condition in the automation to check for the existence of prior linked records.
Hello @kuovonne ! Is this solution still available? I understand exactly what you mean but I can not find the field I am updating available in the options to put it in..
It is only the two steps right? The trigger and the update field one - there isn't a third one between them or anything?
Hello @kuovonne ! Is this solution still available? I understand exactly what you mean but I can not find the field I am updating available in the options to put it in..
It is only the two steps right? The trigger and the update field one - there isn't a third one between them or anything?
The techniques in this thread still work the same.
But you have to know the fields that are involved. If you cannot find them, you may have the wrong table.
The techniques in this thread still work the same.
But you have to know the fields that are involved. If you cannot find them, you may have the wrong table.
I will find it eventually .. Thank you for confirming
If I may ask another one: can we perform math operations in the Create Record fields in an automation ?
For example add two fields with numbers in one of the cells. I can see both numbers I need to use in this case 🙂
I will find it eventually .. Thank you for confirming
If I may ask another one: can we perform math operations in the Create Record fields in an automation ?
For example add two fields with numbers in one of the cells. I can see both numbers I need to use in this case 🙂
Airtable automations do not have native support for math operations. You can use a script to perform math, or you might be able to use a formula field to perform the math.
