I have two tables: Clients and Employees. Employees is linked to Clients and a column “client_id” displays the related airtable client id.
I would like to use the filter by formula in the Airtable plugin to find all records in the Employees table that have the related airtable id.
I’ve already used the search function of this doc for a more basic approach: a simple column in a table and it works great.
Here it doesn’t work, probably because the column I’m doing my search is an array.
The forumula I tried is this one 'SEARCH("'+weweb_variable_for_entreprise_id+'",entreprise_id)' where entreprise_id is the lookup field of my clients table.