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