Help

Airtable to Xero - Zapier Integration - Trouble with fields that link to multiple records

Topic Labels: Integrations
829 1
cancel
Showing results for 
Search instead for 
Did you mean: 
EduCareDo
4 - Data Explorer
4 - Data Explorer

Hello,
I’m having trouble with some Airtable fields. Many come through fine but as you’ll see in the attachment some come through as nonsense alphanumeric sequences. They seem to be the fields that “allow linking to multiple records” and so in this example (attached screenshot) it says:

Course Enrollment: reco2nD46QXVJi6pF

instead of:

Inner Development for World Development

Any help or suggestions very much appreciated.

Screen Shot 2020-11-20 at 6.50.51 AM

1 Reply 1

That is correct.

Linked record fields actually store an array of record ID‘s representing the linked records.

In any table, you can see a record’s record ID by creating this formula:

RECORD_ID()