Skip to main content
Question

Custom Object for dynamic scoring

  • November 7, 2024
  • 1 reply
  • 21 views

Forum|alt.badge.img+1

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?

 

Aayush
Planview Falcons
Forum|alt.badge.img+3
  • Community Manager
  • May 20, 2025

Hello Daniel - 

Great question — and welcome to AdaptiveWork!
You're in good shape: across any of the modules, you can create custom fields as needed, with a quota limit of up to 500 custom fields in certain licenses. So, from a capacity standpoint, your approach is completely doable. You can use the same code, and it should be done. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings