Project and Portfolio Management Practitioners Forum
cancel

Populate Drop Down Lists

Highlighted
Lizabeth
Super Contributor.

Populate Drop Down Lists

Hello,

We have a requireemnt where I would want to show different values in the same drop down at different workflow status.

For e.g 5 values in Workflow Status A, 3 In another etc.

I tried using Rule with the field change as 'Request Status' but that does not help.

Thanks
3 REPLIES
Rich Y_1
Super Contributor.

Re: Populate Drop Down Lists

Hi Lizabeth,

The one way I did this in the past is setup a token in the user data for the drop down validation to show what request status you want to show that row on. Then create a SQL validation that will dispaly rows based on the status. Use that SQL validation in the request type token.

Hope this helps
rich
ChrisJH_1
Trusted Contributor.

Re: Populate Drop Down Lists

In 7.1 this is difficult and would require a combination of the use of user data and rules. I believe there is a knowledge base article for this with instructions. Essentially, by assigning user data to each value, you can drive when the value appears by tying the status value to the list value's code or user data. So you could still use a single list. Given the customization required, you'd be best advised to wait for 7.5 where the UI logic rules should allow this to happen more easily.

We have not tried implementing this yet, so I'd be interested to hear how you make out. Please let me know - cshugrue@jhancock.com. Thanks.
Lizabeth
Super Contributor.

Re: Populate Drop Down Lists

Thanks Rich and Chris.

I was facing issues when was using the [REQ.STATUS_NAME] token, somehow I still have that,the rule does not validate against the token.

Instead I created a user data with Request Status, I used 'sql validation' and used the token [REQ.REQUEST_ID] to find the current status for the request and then map it to the user data to get the values populated.

This does populate the value as desired.

Thanks for your help.