Using both Airtable Update and Upsert modules overwrites previous data

[StevieB]

I’m trying to build a content calendar.

The tables concerned in this scenario are “Content Ideas” and “Post Versions”.

Here’s how it works:

1. I click the “Go” button in the Content Ideas table in Airtable.

2. This triggers the webhook, then I get that record from Airtable and update some fields.

3. One of the fields in the Content Ideas table is called “Format”. It is a multi-select field. So I’m using an iterator.

4. A new Google Doc is created for each Format selected. After this, a new record in the Post Versions table is created.

5. From here, I’m trying to update a field called “Post Versions” in the Content Ideas table. This field is linked to the Post Versions table. It allows linking to multiple records.

Every module in the scenario is running smoothly, but I’m having problems with the Post Versions field.

In my most recent run, 2 operations were used in the Airtable Update module (final module in scenario), but only the final operation is being displayed in the Post Versions field. I thought the Upsert module would make a difference but the same thing is happening.

I can provide additional images if necessary.

Does anyone know where I’m going wrong?

Many thanks!

[Prem_Patel]

Heyy @StevieB

You can add Look Up fields in your existing table based on your Linked Record Field which you are multiselecting from another table. to load text values for any Linked Records field follow this kinda mapping in airtable

I hope it helps.

Best,
@Prem_Patel

[StevieB]

Many thanks for your assistance, @Prem_Patel. I’ve found the problem. I wasn’t identifying the record to link to properly in the Create Record module.

Everything is working as expected now…

It’s amazing what difference a night’s sleep and just the right amount of coffee can make.

Thanks again, mate!

[dilipborad]

Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.