Skip to main content

Zap into Record Link Field

  • February 8, 2019
  • 4 replies
  • 54 views

BobBannanas
Forum|alt.badge.img+13

Is it possible for Airtable to receive a data value into a record link field, assuming the value being zapped into the field exactly matches primary field value of linked record.

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+19
  • Inspiring
  • February 8, 2019

hi Bobby, in this case the most accurate approach is to use the record id of the linked field. You can create a new column called ‘Record ID’ and use the RECORD_ID() formula to expose it.


Forum|alt.badge.img+3
  • Known Participant
  • February 8, 2019

Yep!!

If the data matches the primary field it will link an existing record. If it doesn’t match it will create a new record.

(ps. If you have multiple records with the same primary fields,I believe it will match the first created.)

(pss. If your primary field is a formula and it’s not in the table it will not create a new record.)


BobBannanas
Forum|alt.badge.img+13
  • Author
  • Known Participant
  • February 8, 2019

Yep!!

If the data matches the primary field it will link an existing record. If it doesn’t match it will create a new record.

(ps. If you have multiple records with the same primary fields,I believe it will match the first created.)

(pss. If your primary field is a formula and it’s not in the table it will not create a new record.)


Unfortunately, when a the value is zapp’ed into the field, it is blank. I guess I gotta tinker with it.


Forum|alt.badge.img+3
  • Known Participant
  • March 15, 2019

Unfortunately, when a the value is zapp’ed into the field, it is blank. I guess I gotta tinker with it.


Hi @BobBannanas let me know if you figured this out.

(Been away from the forums for a bit)