Help

How to retrieve the second record in a table

1459 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rui_Teimao
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
Rui_Teimao
4 - Data Explorer
4 - Data Explorer

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!