Help

Filter record based on record id and linked field

1646 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Artur_Mkrtchya1
6 - Interface Innovator
6 - Interface Innovator

Hey folks,

I have a table called Tasks and it has linked record called Owning Team 

I want to filter it based on Team RecordID something like FIND("recZyPUXXXXX"{Owning Team} & '')

this does not work for RecordID although when getting the records via API Owning Team values are RecordIDs.

2 Replies 2

Hm, I think if you're trying to do this you'll need to
1. Create a new formula field `Teams` with the formula `RECORD_ID()`
2. Create a lookup field in `Tasks` to display the value from the step 1
3. Use your filtering logic on on the value from step 2

artu-hnrq
5 - Automation Enthusiast
5 - Automation Enthusiast
2. Create a lookup field in `Tasks` to display the value from the step 1

I was scary of finding this answer here! 😥
But I got it! It's the best workaround.