Skip to main content

How to access the ID of a linked record

  • March 23, 2020
  • 6 replies
  • 102 views
Kim_Trager1
Forum|alt.badge.img+23

I’ve made this very simple little setup where I can select a name, and find the records that matches the selection. I can access the ID of a linked recored via lookups, but is there a way to directly access the ID of the linked records from my ‘Select Name’?

let viewStaff = tableContact.getView(tableContactView);
let choosePerson = await input.recordAsync('Pick a person', viewStaff);
let personID = choosePerson.id; //have to use Id's when using linked records
output.inspect(personID)

//loadReportRecords
let reportQuery = await tableReport.selectRecordsAsync();
output.inspect(reportQuery)



let reportRecordsForPerson = reportQuery.records.filter(record => {
    // Arrays in JavaScript have a method called some, which returns
    // true if at least one element in the array matches a condition
    return record.getCellValue(reportField).some(nameRecord =>
        nameRecord.id === personID
    );
});

output.inspect(reportRecordsForPerson)
reportRecordsForPerson.forEach(record => output.inspect(`${record.getCellValue("lookupName")}, ${record.getCellValue("recordID")}`))


reportRecordsForPerson.forEach(record => {
  output.inspect(record.getCellValue("Select Name").forEach(record => record.id))
})

6 replies

Stephen_Suen
Forum|alt.badge.img+19
  • Stephen_SuenEmployee
  • Employee
  • 83 replies
  • March 23, 2020

@Kim_Trager1 Yes, you can access the id from the linked record cell value, like so:

let linkedRecordCellValue = record.getCellValue('Linked record field');

// If the cell is empty, getCellValue returns null
let linkedRecordId;
if (!linkedRecordCellValue) {
    linkedRecordId = null;
}

// If you know there's only one linked record per cell, it's the id of the first item
linkedRecordId = linkedRecordCellValue[0].id;

// If there can be multiple linked records per cell, you can create an array of ids instead
let linkedRecordIds = linkedRecordCellValue.map(linkedRecord => linkedRecord.id);

It looks like you’re already doing this in the last part of your snippet — does that not output the IDs you’re looking for?

Kim_Trager1
Forum|alt.badge.img+23
  • Kim_Trager1
  • Author
  • Brainy
  • 168 replies
  • March 24, 2020

@Kim_Trager1 Yes, you can access the id from the linked record cell value, like so:

let linkedRecordCellValue = record.getCellValue('Linked record field');

// If the cell is empty, getCellValue returns null
let linkedRecordId;
if (!linkedRecordCellValue) {
    linkedRecordId = null;
}

// If you know there's only one linked record per cell, it's the id of the first item
linkedRecordId = linkedRecordCellValue[0].id;

// If there can be multiple linked records per cell, you can create an array of ids instead
let linkedRecordIds = linkedRecordCellValue.map(linkedRecord => linkedRecord.id);

It looks like you’re already doing this in the last part of your snippet — does that not output the IDs you’re looking for?


Thank you @Stephen_Suen, I think i wrote my question a little too fast.
What I’m having problems with is figuring out how to check the ID’s of the linked records in reportRecordsForPerson variable, which is an array of objects.

Instead of using having to relly on lookups to check the ID’s of the linked records, I want to have an array of all the id’s of my filtered linked records, so I can check that

let personID === nameRecord.id

I’m not sure if my question makes sense?
I can’t wait to get better at this!

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • 6009 replies
  • March 24, 2020

Thank you @Stephen_Suen, I think i wrote my question a little too fast.
What I’m having problems with is figuring out how to check the ID’s of the linked records in reportRecordsForPerson variable, which is an array of objects.

Instead of using having to relly on lookups to check the ID’s of the linked records, I want to have an array of all the id’s of my filtered linked records, so I can check that

let personID === nameRecord.id

I’m not sure if my question makes sense?
I can’t wait to get better at this!


Initially you wanted to check based on name (“Dan”) instead of record ID. If you still want to do that, you can.

In the array for the linked records, just get the .name instead of the .id.

let personName = "Dan";
let linkedRecordName = linkedRecordCellValue[0].name;

if (personName == linkedRecordName) {
  // it's a match
}
Kim_Trager1
Forum|alt.badge.img+23
  • Kim_Trager1
  • Author
  • Brainy
  • 168 replies
  • March 24, 2020

Initially you wanted to check based on name (“Dan”) instead of record ID. If you still want to do that, you can.

In the array for the linked records, just get the .name instead of the .id.

let personName = "Dan";
let linkedRecordName = linkedRecordCellValue[0].name;

if (personName == linkedRecordName) {
  // it's a match
}

Thanks @kuovonne I think what I’m wondering if I can reach into another table via the linked field - a bit like a look up?

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • 6009 replies
  • March 24, 2020

Thanks @kuovonne I think what I’m wondering if I can reach into another table via the linked field - a bit like a look up?


I don’t quite understand your question.

A linked record field stores only the name and id of the linked record.
To get info from other fields in the linked record, you have to do a .selectRecordsAsync() on the other table and find the record you wanted.

Kim_Trager1
Forum|alt.badge.img+23
  • Kim_Trager1
  • Author
  • Brainy
  • 168 replies
  • March 24, 2020

I don’t quite understand your question.

A linked record field stores only the name and id of the linked record.
To get info from other fields in the linked record, you have to do a .selectRecordsAsync() on the other table and find the record you wanted.


I see.
I think that answers my question, I somehow thought that I could access fields in the the other table via the link a bit like a lookup.
But makes sense that it only stores Name and ID


Terms & ConditionsAccessibility statement