Skip to main content

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?

 

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


Terms of UseCookie settings
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here

Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com