Easily Reference Fields More than One Relationship Away

I'd like to count the number of Requirements that roll-up to an Initiative without creating a custom worksheet formula on the Features, then referencing that field on the Initiative worksheet. I was informed by Aha! support that, "The worksheets can reach out one hop to a related record, so you must have a value on the intermediary feature in your case. "

This solution is problematic because I have to manual "generate" the worksheet for each Feature so it's not sustainable.

Here's the worksheet formula that works: (count(self.features[].custom.count_requirements{"Count Requirements"})>=1)

What I'd like to do instead of the above:

(count(self.features[].requirements[])>=1)

The ability to easily reference fields more than one relationship away is beneficial for all object types.

  • Phil Warden
  • May 19 2020
  • Future consideration
  • Attach files
  • Robert Rodriguez commented
    26 May 12:59pm

    This makes sense, I would love to see this too. Will clean up the system dramatically as you wouldn't need to make a worksheet in multiple places.