We need a way to filter lookup and rollup fields, something similar to Airtable. I have a collection that links organizations to projects, and 1 of the organizations is designated as primary. I am trying to pull the address State from the primary organization and if we had the ability to filter on the primary field (ie where primary is True) in the lookup then it would be easy.
Hey @MWorth great suggestion, and it’s something we’re definitely thinking about supporting in the future! However in the specific situation like this we would always recommend having a “primary organization” field that actually holds the link directly to the primary organization, which is 1-1, because your lookup would still be a multi-linked lookup in your example, which wouldn’t be as practical.
Automating the linking is pretty easy to do with some workflows too