Skip to main content

Hello,


I’m developing an Airtable App and I want to access to linked records of a given record.

When looking into the API doc the only way documented is using useRecords like following:


    const linkedTable = base.getTableByName("table1");

    const linkedRecords = useRecords(

    record.selectLinkedRecordsFromCell("table1", {

       // Keep the linked records sorted by their primary field.

       sorts: :{ field: linkedTable.primaryField, direction: "asc" }],

       })

    );

the issue is that I’m trying to do some logic in a non React coponent in a “Service” class, so I can’t use useRecords…


In the API docs they are talking about loading data, I tried loading data manually like so:


const table1QueryResult = await table1.selectRecords();

await table1QueryResult.loadDataAsync();

recordToMatch.selectLinkedRecordsFromCell("table1")

but I always get an error:

Error: LinkedRecordsQueryResult data is not loaded at LinkedRecordsQueryResult.get


Thank you,

Hey @Othman_Daid,


I think you’re seeing this error because you haven’t loaded the query result from your selectLinkedRecordsFromCell call.


You can use selectRecordsAsync and selectLinkedRecordsFromCellAsync to query your data and automatically load it:


Imagine you have a projects table, with a linked record field containing records from a tasks table. You could access the linked records like this:


// query projects and find a project record:

const projectsQuery = await projectsTable.selectRecordsAsync();

const projectRecord = projectsQuery.recordso0];



// query all the tasks within that project record:

const linkedTasksQuery = await projectRecord.selectLinkedRecordsFromCellAsync("Tasks");



// do something with that data:

console.log(`The ${projectRecord.name} project has these tasks:`, linkedTasksQuery.records);



// when you're done, remember to unload your data:

linkedTasksQuery.unloadData();

projectsQuery.unloadData();

Let me know if you have any followup questions!

Reply


Terms & Conditions