Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Cannot use linked record field in automations

Topic Labels: Automations
2061 3
cancel
Showing results for 
Search instead for 
Did you mean: 
kaminoan
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table <TableA> whose records <TableARecord> have a field <LinkedRecordB> which is linked to records of a second table <TableB>.

I am try to use that field <LinkedRecordB> for automations and I don't see how.

  1. If I try to use it in a Condition Group, when defining the condition I can only use the record ID and Name.
  2. If, as a workaround, I try to find the corresponding record in <TableB> using a "Find records" action with "Find records based on" when trying to defined the condition I am not even able to select that field <LinkedRecordB> and get an error message when hovering stating: "No valid nested options"

The only solution I have found is using adding another field of type "Formula" in <TableA> an getting the Name of that linked record <LinkedRecordB> and then using it in the condition in option 2.

Am I missing something?

3 Replies 3

I don't think so I'm afraid, and I use your workaround of the formula field for the record name (or even a lookup field to grab the linked record's record ID sometimes) as well

Would be happy to learn how to solve this!

I'm working on this exact same issue, was a solution ever found?

Cole_Wedemeier
7 - App Architect
7 - App Architect

I'm also in this situation, but one step further. I tried this work around, where if I make a formula field to populate the lookup fields data, I get "invalid input errors" as if it cannot read the formula field and I swear this used to be an option that worked.