Apr 17, 2022 11:42 AM
Hi there, this is my first forum help request…
I have an Integromat scerio in which I updae a value inside a multi select field, but the value I update replaces the current value.
Is there a way to add to the current value and not replace it?
Thank you so much for your help
Apr 17, 2022 12:21 PM
I don’t have Make/Integromat up right now, but you should be able to accomplish this by adding the existing value(s) of the record field into the update record action.
To provide an automation example from the Airtable side…
In this update record action, the inserted value at point one is inserted from the existing record.
The comma at point two facilitates a separate value.
Point three is the value I’m looking to append.
In this case, point one has the two existing records that were already linked.
So to append the new record(s) to the field, I just add the comma and the value I want to add.
This setup will prevent all the other values from being erased.
This applies to both linked record fields, text fields, etc.
Apr 17, 2022 12:41 PM
Thank you Ben, but I need this to work from Integromat and not with Airtable automation.
When I use “update record” in the Integromat/Airtable module the value is replaced and not added.
Any thought and help will be appreciated…
Apr 17, 2022 12:53 PM
I use Integromat, to add multi select options.
A few questions:
Are you using the Multi select option, or the single select option field?
Are you wanting to add a selected value/option to other values/options in one field or just one value/option per field?
Apr 17, 2022 11:43 PM
Hello Mary and thank you for your help.
Apr 18, 2022 04:57 AM
There might be a few different ways of doing this:
I add all the multi options, at the time of creating a new record.
The other option is to use a function inside of the multi field, in Integromat.
Here’s a link to a posting, with a potential solution. There are different functions that you can use. You will have to experiment with what will work for your use case.
Hope this helps!