This is such a huge miss.
A simple filter for linked records like is all that is needed…
“where xxxx field equals yyyy field”
With the xxxx field being in the linked table and yyyy field being in the current table.
Airtable have scripts, apps and aut...