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?
Welcome to the community, @Cristian_Nistor!
It sounds like you want to filter your publications by contacts, but you want to use their ID instead of their name as the filtering criteria.
What you’ll want to do is 3 things:
Create a “RecordID” field in your Contacts table by creating a formula field with the formula:
In your Publications table, create a lookup field that looks up this new “RecordID” field from your Contacts table.
Once you have this new lookup field in your Publications table, then you can filter on this lookup field by typing the RecordID into the filter.
Hope this helps! If this solves your problem, could you please mark this comment as the solution to your question? This will help other people who have a similar question in the future. If not, please let me know what additional help you need!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.