Jan 11, 2023 03:17 PM - edited Jan 11, 2023 03:19 PM
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.
Jan 12, 2023 12:05 AM
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
May 19, 2023 01:30 PM - edited May 19, 2023 01:31 PM
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.