I have a column that is called
Contacts that lives in table
Publications. In this column, each cell has one or multiple linked records that can be found in another table called
Press & Media Contacts.
A cell inside
Contacts looks like this
What I would like to do is to filter and select the rows that have a certain contact in, using the record id.
The only way I could do this was to use
Name, not record id:
"filterByFormula" => "FIND('Keith Shearin',Contacts)"
What I would like to do is something like this:
"filterByFormula" => "FIND('reclhWRUlh9q47Zfd',Contacts)"
Keith Shearin record id.
FIND is obviously not the proper way to do it since it finds a string inside a string.
Do you guys have any tips on how can I achieve this?