Skip to main content
Solved

Automation using Linked records (Lookups) not working - The record does not exist

  • March 23, 2023
  • 1 reply
  • 47 views
C
Forum|alt.badge.img+6

Hi there, 

I have a table called "activities" that links to a "users" table and a "products" table.
Each time a user upvotes a product, a new entry is created. (Picture 1)

I am trying to set up an automation that updates one field in the linked product, with the user who upvoted that product. (Picture 2)

It seems like the linked fields appear to be empty for Airtable. Only when I untoggle the fields the actual user or product appears. (Photo 3)

I keep getting an error message, for an automation that should really be simple. (Picture 4)

How can I fix this? Does Airtable not support Linked Fields? How can I get the linked field info to show up in the field values?

I spent 5 hours trying to fix this. Any help or pointer is greatly appreciated. Many thanks!


Best answer by climesumer

I just got it to work! Finally!
In the actions section:
> Record ID > The down error of the token > Display > Choose Property > Select ID (instead of name)

No idea what it is actually doing, but this fixed it. 

1 reply

C
Forum|alt.badge.img+6
  • climesumer
  • Author
  • Inspiring
  • Answer
  • March 23, 2023

I just got it to work! Finally!
In the actions section:
> Record ID > The down error of the token > Display > Choose Property > Select ID (instead of name)

No idea what it is actually doing, but this fixed it. 

1 Attachments
TheTimeSavingCo
Terms & ConditionsAccessibility statement