Skip to main content
Question

Automation: “Linked record” field showing both array + string record ID in update step

  • November 5, 2025
  • 4 replies
  • 38 views

Forum|alt.badge.img+2

Hi everyone —

I’ve built an automation that:
1️⃣ Triggers when a Project Overview record enters a view
2️⃣ Creates a related record in Prelims Summary (Client Breakdown)
3️⃣ Updates the original Project Overview record to link back to that new record

Everything works — the link is created — but in the run log, the Linked Prelims (NEW) field shows two entries:

 

["rechvSfKKM3dFqypl"] ✅ (green — works) "rechvSfKKM3dFqypl" ❌ (red — literal string)

I’m currently setting the linked record field value in the Update Record step as:

 

["Airtable record ID"]

(using the dynamic variable from the Create Record step with the “+” button).

Is this expected, or should only the array appear?
Could something in the input mapping or type conversion be causing the duplicate string entry?

Any insight from others who’ve built dynamic link automations like this would be great — thanks!

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hm could you provide screenshots of of the run log, automation set up and relevant tables please?  

I tried to recreate your setup but couldn’t see anything weird with the automation history or the run logs

 


 


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 2 replies
  • November 6, 2025

Thanks for the quick reply!

Here are the screenshots you asked for:
1️⃣ Automation setup showing the “Create record” and “Update record” steps
2️⃣ Run log showing the linked record value — you’ll see it lists both the array format (["recXXXXXXXXXX"]) and the plain record ID
3️⃣ The “Linked Prelims (NEW)” field setup — it’s a linked-record field connected to the “Prelims Summary (Client Breakdown)” table

The automation runs successfully — it creates and links the correct Prelims record — but the run log always shows both values, and the field itself sometimes duplicates the link.

I just want to confirm whether this is:

  • a harmless display issue in the run log, or

  • something in my JSON array format that should be changed (e.g. escaping or wrapping).

Appreciate any insight!

 


TheTimeSavingCo
Forum|alt.badge.img+31

Ah, that ‘Update Record’ shouldn’t have the ‘[“”]’ bits and should look like this:

I’m surprised your setup works actually!


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 2 replies
  • November 6, 2025

Thanks Adam

 

Finally got it working, after days of trialling 😂