I wanted a button (labelled “View child records”) in each record of a parent table to set filter conditions for a child table. I created a button with the URL of the child table, and the button appended “?filter_{field}=” & ENCODE_URL_PARAMETER({field-value}). The button worked great, and even moved the focus to the appropriate table tab, but alas the page redrew without the URL filter specs and just displayed all the records of the child table. What ultimately “worked”, if you want to call it that, was to append the URL filter specs to a SHARE VIEW URL. The displayed page then showed the filtered records, but alas they couldn’t be edited–because it was just a read-only share! It appears that if you want to filter a child table by some field value from a parent table record (all client X’s orders), Airtable forces the user to manually search through potentially thousands of client records, copy the appropriate client ID field content, switch to the Orders table and manually configure its filter spec. All the cute Airtable demos have only a few records, so this problem doesn’t become evident. Hundreds of clients and thousands of orders later, users are pulling out their hair. Solutions, anybody?
