Jan 07, 2020 12:19 PM
Hello
I’m trying to automatically create a new record in “Table 2” whenever another record is created in “Table 1”.
Both “Table 1” and “Table 2” are in the same base.
I’m using Zapier for this:
-Trigger: New Record in Airtable
-Result: Create Record in Airtable
I’ve tried various options for this, but always get the same error message - see the below text.
My suspicion is that this is due to some formatting point - where Zapier is trying to pass Airtable some field value which Airtable believes to be inconsistent with the table’s rules.
I can’t see any obvious error in my set up however…one thing to note is the “Task ID” field which I’m feeding is a “Linked Field”…not sure if this could be an issue?
The output of this zap is currently nothing ie it’s not having any impact or triggering anything in my base
Thanks in advance
We had trouble sending your test through.
The app returned “Unknown field name: “fld9uHctoXMIDGpAq””. This can occur if the information entered into a field is not in the correct format. Double-check that you are using the correct format for entering values into a field.
We made a request to api.airtable.com and received (422) Unprocessable Entity.
Jan 08, 2020 12:38 AM
Hi @Darius_Safavi - the Zap is looking for the field name “fld…” which is the internal Airtable field ID, I think, rather than the field name. As you say, I think this is probably due to the Task ID being a linked field.
Can you provide some more detail on your table set up - fields, type, links etc and what data you are passing from table 1 to table 2?
JB
Jan 08, 2020 03:32 AM
Hi,
Attaching some details of the 3 tables involved in this set up (the 3rd table not mentioned before is actually where “Task-ID” is being pulled from into “Table 2”.
In short, what I am wanting:
Many thanks for the help
Jan 09, 2020 01:29 PM
Hi Jonathan
Was just wondering if you’d had a chance to review my query at all?
Many thanks
Jan 10, 2020 05:07 AM
Hi @Darius_Safavi - I got this to work, hopefully with the same/similar setup as you. I’ve got a Clients table:
and a Tasks Library table:
and, finally, the Assigned Tasks table:
In the Assigned Tasks table, I want Zapier to create a record and pass the task ID and the Client ID through to the record. I can then look up Task Name (from Tasks Library) and Client Name (from Clients).
In Zapier I have this:
So, the task ID is a constant value (and a valid Task ID in Tasks Library). The Client ID is the ID from the new Client record. The ID and Autonumber fields should be left blank as these are set by Airtable in Assigned Tasks. The Task Name and Client Name Lookup are both lookup fields so these should also be left empty.
When I create a new client and Zapier runs, I get this:
Contrary to what we talked about earlier, I wonder if the error you were getting is down to an old/missing field?
Unknown field name: “fld9uHctoXMIDGpAq”
Try refreshing the fields in Zapier to get the latest table definitions from the base.
Hope this helps.
JB