updating a linked field with a value through automation

[GSzorad]

Hi, 

I have researched the forum but cant find the problem to my solution. 

Every time a record is updated in UseCases, I calculate a field call Environment_textual (example value would be "Negligible risk").

I have another table called Environment_pics where I store pictures for each rating (e.g. there is a pic for "Negligible risk"). 

I want to create an automation which takes Environment_textual and copies it over to the linked field, so I can the picture in the UseCases list.

I get an error for the last step.

Should I copy the result in the linked field in UseCases or in the linked field of Environment_pics? For use cases it runs succesfully but the value is not inserted, for Environment_pics I get an error "The record does not exist"

Please help. A gif would be me most welcome, or any description, link. Spent hours on this and is blocking me big time.

Somewhat similar problem but didnt help me figure it out:

https://community.airtable.com/t5/automations/automating-update-a-link-field/m-p/159068?lightbox-mes...

THANK YOU

[Matt_Jastremski]

Just taking a quick look at what you posted and the link you referenced and may have spotted the difference. Pay attention to that GIF (yes it goes fast), they use the record ID from a previous step (not a formula field) to link records. 
I haven't sat down and replicated this myself, but it seems like you're getting the "record does not exist" error because it's expecting a record ID, not a record name to make the link.
I think you may need a "find record" step to look up "Negligible risk" in the second table, get its record ID, and then use that.

[TheTimeSavingCo · Accepted solution]

Ah, you're going to need your automation setup to look like this:

And here's how you'd select it:

And I've set it up here for you to check out!

  

[GSzorad]

Hi Matt, thanks for the quick response. I noticed that in the gif as well, but that option doesnt come up for me unfortunately.
This is what I can see:

Whereas the screenshot from the fast gif from my original post shows:

[GSzorad]

thank you, this is a life saver!