Filtering Programs by Portfolio on Custom Form

[J_Mas]

I have a custom form used for project intake. Among other things, the person filling out the form must select the Portfolio and the Program.

After they have selected the Portfolio, I would like the Program list to only allow them to see/choose the Programs that are aligned with that respective Portfolio. Currently they see all Programs in the dropdown, no matter which Portfolio it is aligned to.

I believe I would need to set this on the Filter of the Program field, however I'm not sure what the Text Mode code should look like. I know this code doesn't work, but I'm imagining it's something along these lines:

isActive=true
isActive_Mod=eq
portfolioID=$$portfolioID
portfolioID_Mod=in

Any help is appreciated.

[Madalyn_Destafney]

Hi there, the native portfolio/program fields are in the Overview section of a project and unfortunately can't live in a custom form (there are ideas for this to upvote out there).

When a user selects the portfolio (we call them narratives), the programs that then show are already only those under the selected portfolio, not ALL programs. If you are seeing otherwise, that is a bug that needs to be reported to WF! Or did I misunderstand your question?

[J_Mas]

Thanks @Madalyn_Destafney , I may not have described our situation accurately. Within Setup - Portfolios we have 6 portfolios. Within Setup - Programs we have 6 programs, each aligned to one of the 6 portfolios. Obviously this one-to-one relationship isn't ideal and we'll be adding new portfolios and programs shortly. However, currently our setup is basically like this:

• Portfolio A
  • Program A
• Portfolio B
  • Program B
• Portfolio C
  • Program C
• etc.

On our Custom (Intake) Form, we have a Typeahead field called "Dept Portfolio" (I'm saying "Dept" instead of our actual department name). This field has Portfolio selected in its Referenced Object Type. This allows us to see and select the appropriate Portfolio on the Intake form. We have a similar Typeahead field for Dept Program, the only difference being that Dept Program references the Program Object Type and has a filter applied. The filter currently filters out 2 of our Portfolios. As a result, all programs under the remaining 4 Portfolios are shown in the Program dropdown.

To summarize, we currently can select both Portfolio and Program on our intake form. We even have the Program field somewhat filtered by Portfolio. What we'd like to do is adjust the filter to only show the Programs for the selected Portfolio.

I've attached a few screenshots (with some visual edits for security purposes) to hopefully better show our current setup.

Portfolio field on Custom Intake FormFilter applied to Program field on Custom Intake Form

[Jason_JB]

This system limitation is frustrating, and each time I think I find an elegant workaround it doesn't pan out.  2 approaches we're currently using are:

1. prefix the value with the filtering value - then users type the first to narrow the list down.  We use this for some of our integration with Salesforce.  We need a list to filter down to only options that are valid for the company.  So when we bring in the values (from Salesforce) for the second list we prefix them with the company name.  Our users are trained to type "company name" "value searching for".

In your example this might look like "Portfolio B | Program B".

2. we use Fusion to replicate data from one object to another to help with similar challenges.  This would look like creating a custom field that merges the values together and then pointing the typeahead to that custom field.  This is similar to Doug's second suggestion.

[Doug_Den_Hoed__AtAppStore]

Hi @J_Mas,

What you are asking for (where one selected custom parameter option then restricts the options of a related parameter) is often called Cascading Parameters, but is not available natively within Workfront.

For those for whom it’s warranted, I invite you to consider our UberCalc solution (eg one of our clients in Aerospace needed to provide a three step Part Number selector so leveraged UberCalc in this way via a special request form centered on those particular cascading parameters).

Alternatively (but redundantly), you could also either combine your data into a single dropdown of (valid and current) Portfolio AND Program combinations in alphabetical order from which the Requestor can then scroll (perhaps a long way) and simply pick, and (later) the Request Recipient can then use to guide the ultimate Portfolio and Program under which to route and/or convert the Request.

Regards,

Doug