How to retrieve the second record in a table


#1

Hi,

Airtable noob (loving it!) and barely literate coder (sorry!) so apologies if this is a dumb question. I have some simple code lifted from the API docs to retrieve the first row in a table

var Airtable = require(‘airtable’);
var base = new Airtable({apiKey: ‘XXXX’}).base(‘XXXX’);
base(‘MainTable’).find(‘recC6vx8ngBIoSx9Y’, function(err, record) {
if (err) { console.error(err); return; }

this lets me use the value of a cell in a column called TextContent using (record.fields.TextContent).

So far so good.

How can I retrieve the value of a different row, e.g. the second row? Is there a different parameter for base('MainTable.find(‘VALUE GOES HERE’
?

Does ** recC6vx8ngBIoSx9Y** refer to the first row, and will a different value call the second row?

Thanks in advance for any help


#2

I’ll answer my own question…

Adding a Forumla field with RECORD_ID() to the table reveals the row IDs so they can be added as the value.

Thank-you to Airtable support for clearing this one up!