How Fusion dynamic update dropdown options in workfront custom form?

[wxyu]

Hi, I created a custom form with a dropdown component, for the dropdown options I need to get from other sources (not hardcode), for example from a database.

I can use Fusion to connect a database table and get the options data, but how should I update the dropdown component with Fusion.

Thanks.

[Stacey_Robertson]

I don't believe you can have a drop down update dynamically or you will lose any data that used items in the drop down that no longer exist.

[wxyu]

Thanks @Stacey_Robertson, If there was a workfront API which provide update custom field object, that would be perfect.

[Jason_JB · Accepted solution]

Hi - we've done something along these lines.  We need to replicate the Opportunity record from Salesforce into Workfront to enable our teams to link projects to Salesforce Opportunities.

We are:

• leveraging Fusion to ingest messages from Salesforce related to the Opportunity records and corresponding data changes
• Fusion creates the mirror record as a project within Workfront. These projects use custom fields to store the needed attributes.  These projects all live in a portfolio only used for them.
• We then leverage Workfront's type ahead field functionality to build the linkage.  The type ahead field functions similar to the dynamic dropdown/pick list I hear being described in the question.

As new opportunities are sent to Workfront, projects are created. The creation of these projects adds them as choices in the typeahead using Workfront's standard typeahead custom field functionality.

[wxyu]

Thanks @Jason_JB your solution is very helpful, you mean you set project as the Referenced Object Type, right?

we have lots of projects, so that means user may search some irrelevant contents, did you add any filters?

[Jason_JB]

Yes, that's correct - the "Referenced Object Type" is "project".

Yes, we have filters that limit the options.  For the specific example I mentioned we're filtering based on portfolioID and project.status.

[wxyu]

Hi, @Jason_JB 

Thanks for so quick response, This is very very helpful to me, very appreciate!

[ChrisStephens]

If you would prefer to update a dropdown list instead of doing it this way, that is also possible. You have to update the parameter options for that parameter (aka property).