Search table with field other than record ID -api

[Andreas_Iacovid]

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

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?

[Bill_French]

Andreas_Iacovides:

I want to serch records by email and not record id.

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