Updating airtable multi fields during integromat make module

Topic Labels: Integrations
177 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Integration with + airtable

I want to automate posting on different social media channels based on information in an Airtable database. After each successful post, I want to update a status column in Airtable to reflect which social media platform the post is live on.

The issue I'm facing is that the status column keeps getting overwritten, so only the latest post's status is shown, instead of all the platforms the post is live on.

I've tried using this command:

{{merge(6.Live Status; add(emptyarray; "Live - FB"))}}

The command works when there's pre-existing data in the Airtable cell BEFORE the router. However, it fails to recognize the updated status created after the router for each post. It seems to only read the Airtable data from before the router was introduced.

Can anyone help? see attached screenshot for the scenario. Thanks

1 Reply 1

This works fine for me:

Screenshot 2024-02-12 at 3.49.02 PM.png
It successfully adds the "World" to the multiple select field, so that it goes from this:

Screenshot 2024-02-12 at 3.50.22 PM.png
To this:
Screenshot 2024-02-12 at 3.50.26 PM.png
So maybe you could try just using:

add(6. Live Status; "Live - FB")