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?