Skip to main content

How to retrieve the second record in a table

  • February 23, 2017
  • 1 reply
  • 3 views

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

This topic has been closed for replies.

1 reply

  • Author
  • New Participant
  • February 24, 2017

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!