javascript - How do you filter an airtable record that contains a given string, but may also contain others? - Stack Overflow

admin管理员组

文章数量:1345322

Using the airtable api's filterByFormula method I can query and select records that contain one specific item (string). However, this query only returns the records that have ONLY that specific string.

Searching the airtable api formula documentation here: yields no answers.

What I have:

base('Table').select({
    view: 'Main View',
    filterByFormula: `Column = "${myFilter}"`
}).firstPage(function(err, records) {
    if (err) { console.error(err); reject( err ); }

    records.forEach(function(record) {
        console.log(record.get('Another Column'));

    });

Again, this returns records that have ONLY myFilter, and not records that contain any additional values in the given Column.

edit: airtable refers to these columns as 'multiselect' field types.

Using the airtable api's filterByFormula method I can query and select records that contain one specific item (string). However, this query only returns the records that have ONLY that specific string.

Searching the airtable api formula documentation here: https://support.airtable./hc/en-us/articles/203255215-Formula-Field-Reference yields no answers.

What I have:

base('Table').select({
    view: 'Main View',
    filterByFormula: `Column = "${myFilter}"`
}).firstPage(function(err, records) {
    if (err) { console.error(err); reject( err ); }

    records.forEach(function(record) {
        console.log(record.get('Another Column'));

    });

Again, this returns records that have ONLY myFilter, and not records that contain any additional values in the given Column.

edit: airtable refers to these columns as 'multiselect' field types.

• javascript
• node.js
• airtable

Share Improve this question Follow edited Feb 24, 2017 at 1:17 Kenny Powers asked Feb 24, 2017 at 1:10 Kenny PowersKenny Powers 1,27422 gold badges1515 silver badges2727 bronze badges 2

• 1 Could you not use the SEARCH or FIND functions with a >= 0? like `SEARCH("${myFilter}", Column) >= 0`? – haxxxton Commented Feb 24, 2017 at 1:27
• 1 Throw that in an answer so I can accept it. That worked, thank you! – Kenny Powers Commented Feb 24, 2017 at 2:14

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 11

It appears that airtable has support for the js equivalent of indexOf in the form of SEARCH. From the docs:

SEARCH(find_string, within_string, position)
Returns the index of the first occurrence of find_string in within_string, starting at position. Position is 0 by default.

As such, we can use the following as our search filter value

filterByFormula: `SEARCH("${myFilter}", Column) > 0`

This will search our Column for the presence of myFilter and return any result were myFilter is located at some position within the Column.

NB:It may be worth caveating, that your myFilter property is probably best to have a minimum character count of at least 2 for performance. The docs also do not specify an option for case insensitivity, so you may wish to wrap both Column and "${myFilter}" in a LOWER() function, if you want to return results regardless of upper or lower case characters. For example

filterByFormula: `SEARCH(LOWER("${myFilter}"), LOWER(Column)) > 0`

本文标签：