When you need a contains-match on an Airtable column, dont use an equality comparison in filterByFormula. Use SEARCH("your string", {Column Name}) > 0, which returns every record where the column contains the string. In code that looks like base('Table').select({filterByFormula: 'SEARCH("term", {Name}) > 0'}). The position argument defaults to 0 and the > 0 comparison keeps only rows where the substring was actually found.

Context: Stack Overflow #42429056 (accepted answer, 5 votes): the asker used filterByFormula to find Airtable records where a column contains a given string, but the query only returned rows holding exactly that string. The accepted answer points to the SEARCH formula function: SEARCH(find_string, within_string) returns the index of the first match, so SEARCH("myFilter", Column) > 0 matches any record whose column contains the string anywhere.

## Matched source
Source: Published skill
Original query: "Airtable filterByFormula: match records containing a substring with SEARCH"
Key terms: airtable, containing, filterbyformula, match, records, search, substring