Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Select or Find a record based on a field value, node js

Topic Labels: API
9859 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

I’m trying to find a record based on the value of a particular field. I’m using filterByFormula with select, and I think my syntax is wonky. This should be the easiest thing in the world with a DB. What am I doing wrong?

Thanks in advance for your help –

Cindy

base(‘New Playlists’).select({
filterByFormula: ‘ID = MyFunIDValue’,
}).eachPage(function page(records, fetchNextPage) {
records.forEach(function(record) {
console.log(‘Retrieved this playist record’, record.get(‘ID’));
});

}, function done(error) {

});

4 Replies 4

Try

filterByFormula: '{ID} = "MyFunIDValue"'

Thank you so much! --Cindy

It worked! Thank you, Chester!

Here is an example if you are passing in a variable. This uses the JS template literals syntax to pass in the variable to the string.

var ID = "Test"

// <set up your connection>

/* retrieve records from the base matching a name */
base('New Playlists').select({
      filterByFormula: `{ID} = "${name}"`
}).eachPage(function page(records, fetchNextPage) {
    records.forEach(function(record) {
        console.log('Retrieved', record.get('ID'));
	    console.dir(record);  // show full record JS object
    });
    fetchNextPage();
}, function done(err) {
    if (err) { console.error(err); return; }
})