Skip to main content

Find Record + Update Record => Received invalid inputs

  • August 23, 2022
  • 1 reply
  • 4 views
V
  • Vivek
  • New Participant
  • 3 replies

I have two tables named “Organizations” and “Org Founder Mapping”.

Organizations table contains fields “Org UUID”, “Name” …
In this “Org UUID” has values using RECORD_ID().

In table “Org Founder Mapping” have fields “Founder UUID”, “Org UUID”, “Org Name”…
In this “Founder UUID” has values using RECORD_ID().
“Org UUID” is linked to “Organizations” table.

I want that when I enter "Org Name’ in “Org Founder Mapping” table, it automatically search “Org Name” (“Org Founder Mapping” table) into “Name” field (“Organizations” table) and copy the “Org UUID” (found in “Organizations” table) and paste it into “Org UUID” field in “Org Founder Mapping” table.

I tried to automate this but I am getting “Received invalid inputs” error

1 reply

Alexey_Gusev
Forum|alt.badge.img+23

Hi,

You get error because Find Records always return array (of IDs of other values, by your choise), even if it’s single or zero records.
Your base design does not let you use full advantage of linking records. At least one primary field should be something searchable, in your case it’s maybe Organization Name.
Using record ID, especially for primary field is not a good practice in AT.

But even in your case, you can make it work. You should get result of ‘Find records’, choose make list of: Airtable IDs and put it into link field. Link field value is always array,
Org UUID in Org Mapping table should be a lookup field, which will be filled on it’s own, according to links you set.

Reply


Most helpful members this week

Terms & Conditions