Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Filter record based on record id and linked field

64 1
Showing results for 
Search instead for 
Did you mean: 
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.

1 Reply 1

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