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


#1

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) {

});


#2

Try

filterByFormula: '{ID} = "MyFunIDValue"'


#3

Thank you so much! --Cindy


#4

It worked! Thank you, Chester!