Jan 22, 2021 06:55 AM
Hi all,
I have automation setup to put notes in long text field when certain conditions met (and was proud of myself :winking_face: )…BUT when it triggers it removes and REPLACES any text that may already be there…just wanting to add additional text in that field…can that be done?
Solved! Go to Solution.
Jan 22, 2021 07:50 AM
yep. You append any field type’s value by inserting the value from the trigger record (or any other previous step), adding a space (or comma if its an “array” field), then typing in the value to be appended at the end.
Jan 22, 2021 07:50 AM
yep. You append any field type’s value by inserting the value from the trigger record (or any other previous step), adding a space (or comma if its an “array” field), then typing in the value to be appended at the end.
Jan 22, 2021 09:17 AM
Heck simple enough, why didn’t I think of that… thank you for the help!
Mar 28, 2023 07:40 PM
Im having trouble using this application in an Airtable automation loop. Im looking to add a linked relationship to an empty link field then to append that same field with a second, third, etc record connection
Sep 27, 2023 11:03 PM
Hi there - New to Airtable and this was my exact question. I am looking to add new tasks to record when a certain status is chosen. But sometimes end user already has tasks entered. Can you show me formula syntax to append and not replace? Do I literally type "Value to be appended at the end" ...that's the last line of formula code?
Also, "by inserting the value from the trigger record" can you explain where I get this value & what trigger record? If I understand, in my case, the trigger record would be when the status is updated to Onboarding, add these 4 tasks but append them if text is there, not replace. Can you help me w/ formula please?