Integration with make.com + 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