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.
- If I try to use it in a Condition Group, when defining the condition I can only use the record ID and Name.
- 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?