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 resour...
The only hacky solution I was able to find is using a “naming convention” on resources and then use a REGEX to match against the name.
Here is how it works:
Make the resource identifier a naming convention “[description] - [powered]” in the resource ...
Oh yes, I’ve had that solution already. This rollup works looking on one field, but not two.
Look here: This is the solution you propose. The rollup is looking into the Primary Resource and rolls up when there is a link with prop powered electric.
...
Here you can see my resources. The crucial field is “Powered”. I’m looking for electric powered cars.
here you can see my projects where I assign a primary and a backup resource.
As long as I match against parts of the resource name (here “VW”) it...
I tried a bit and found that it works when the resource name has a “bbb” in it. But as it’s an attribute to the linked record I’m not sure how I can tell the Regex that it should look into the details of a record to match against.
Example: The linked...
Jan_Kiekeben:
I even used ARRAYUNIQUE(values) on the aggregation of the rollup to have resources only once in there.
Thinking about the aggregation made me realize that you can link a resource only once in a link field, so there is no need for...
