Hi All!
I am brand new to AdaptiveWork / Clarizen and trying to grasp how something like this would be built, and/or how easy it would be.
Use Case: We have about 20 fields with associated score values, and we wish to use the score values in a formula to calculate another field.
Approach: Rather than hardcoding the score values within a formula, I created a Custom Object with the possible field values and the associated scores. This seems easier to maintain than a ton of code. Also, I’m trying to learn how the product works so it’s also just for my curiousity.
Question: How hard is it to create Business Rule that looks at a field value, and then does a lookup to a record in a Custom Object and retrieve the Score value?
I was able to get as far as retrieving a value from the Custom Object by using the GetObjectByID function, but only when I hardcoded in the ID.
I am looking to do a join on the Name field rather than ID between my request field and the possible entries of the Custom Object.
Am I being too ambitious here?
Are there other ways someone would solve this, aside from tons of code with the score values embedded in the formula code?
