Skip to main content

Creating a new record in externally sync'd table

  • May 28, 2024
  • 6 replies
  • 264 views

Sean_Murphy1
Forum|alt.badge.img+17

So as we know, we can now enable the creation of records in tables that have been synced from other bases. It's great. Massive improvement. But can someone confirm for me whether we should be able to do the same using the Create Record action in Automations? Should spend my time doing a workaround or bug hunting? Because it isn't working for me.

thanks,

6 replies

Forum|alt.badge.img+3
  • New Participant
  • 1 reply
  • June 2, 2024

I'm running into the same problem. I can create a new record in synced table manually, but the Create Record automation action insists it can't use that synced table because it is "synced from an external source."

can create new records in my synced table, but the automation is convinced it cannot.


omf
Forum|alt.badge.img+5
  • Participating Frequently
  • 7 replies
  • December 2, 2024

Having the same issue here, would love to know if there's something simple I'm missing or need to create a workaround.


Forum|alt.badge.img+1
  • New Participant
  • 2 replies
  • February 14, 2025

Same issue here. I reckon it's a limitation - kinda ruins the usefulness of synced for me. So much for upgrading to business....


omf
Forum|alt.badge.img+5
  • Participating Frequently
  • 7 replies
  • February 18, 2025

I ended using Make to create the new record - annoying to have to go outside AT for something simple, but it did the trick 😊


Forum|alt.badge.img+12
  • Known Participant
  • 57 replies
  • February 18, 2025

Running into a similar thing where I'm getting an error when I try to use a synced table in a separate interface. I cannot toggle on "Add records through a form" or "Link/unlink records" because I get an error that users can't link/unlink existing records because this table is synced. I've got the syncs set up to allow for edits, but I guess it's a limitation, which is too bad. 


Matesanz Labster
Forum|alt.badge.img+1

I’ll try to throw some light into this.
In airtable docs “Create record Automation” in the FAQs section, it says

Can I use this automation to create records in other bases?

In general, no. To create records in another base you'll need to use a scripting action that includes a custom Web API call to create those records elsewhere. The one exception to this rule is for Enterprise customers who are using Airtable's two-way sync feature. In this case, creators can build an automation that creates the records in that synced table. These created records will sync to any other bases connected via that two-way sync.

But if you go to Airtable's two-way sync feature it says is available starting at Bussiness

Plan availability

Business and Enterprise Scale plans only

 

So I guess Creating records in other bases through automation is ONLY AVAILABLE for Enterprise customers.

Sad…. ☹️