Use the "search" function in the "filter by formula" of Airtable plugin with a lookup record

Alright!

It took me a while. Here’s the whole process: Maxence - filterByFormula with list in Airtable — Tella

Want to skip ahead?

  • use the ARRAYJOIN formula in Airtable to turn your array into a string
  • this will allow you to use Airtable’s FIND or SEARCH formulas (which can only search through strings) when setting up your collection in WeWeb

Thanks for the inspiration @MaxenceP! Even though it’s an Airtable limitation, it’s a great topic for a future WeWeb tutorial.