Search table with field other than record ID -api

I want to serch records by email and not record id. My script is as follows :slight_smile:

var Airtable = require(‘airtable’);
var base = new Airtable({apiKey: ‘---------------------------------’}).base(’---------------------’);
var myvar = ‘recIf7E6VEXudD9m8’

base(‘Database 1 - Natural Persons’).find(myvar, function(err, record) {
if (err) { console.error(err); return; }
console.log(‘Retrieved’,record.get(‘Registration No.1’));

How shall i go about it?

1 Like

The API docs explain the capabilities of the filterByFormula feature - that should be all you need to filter records based on arbitrary fields.


This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.