Help

Re: Find Record + Update Record => Received invalid inputs

1100 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vivek
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Screenshot 2022-08-23 at 2.11.48 PM

Screenshot 2022-08-23 at 2.12.15 PM

Screenshot 2022-08-23 at 2.14.55 PM

1 Reply 1

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.