I have a projects table where I link multiple records from a resources table. The linked records (resources) have different attributes (e.g. aaa, bbb, ccc, ddd) that come from a “single-select” field.
My challenge now is to find projects where resources of a special attribute (e.g. bbb) are linked.
Is there a function/formula field I could use to color records in my view?
I’m not the full Expert on automation or formulas, but I think of a formula that goes to the link of the record, looks for the attribute, and then makes it possible to color or maybe write a “true/false” to another field and I color/filter/group for that.
Currently the only solution I could find is to separate the resource-link field into a "link “bbb” resources here (links based on a filtered view) and all other resources on another field. Thus I see in a coulum quickly if a resource with the attribute “bbb” is linked. I don’t like this approach as I want to have all resources linked to a project in one field. It would be enough to color my projects in a view if a resource with attribute “bbb” is linked or not.