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.
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