Can a Workfront Field display dropdown options from other separate pre-filled fields | Community
Skip to main content
Donna_Boj
Donna_Boj
Level 3
March 3, 2025
Solved

Can a Workfront Field display dropdown options from other separate pre-filled fields

  • March 3, 2025
  • 3 replies
  • 1319 views

Hello All,
I am hoping someone can assist.

Is there a way in a calculated field to display in a dropdown format field entries from other fields?
E.g.
We have lots of fields:
Lead Type Code 1
Lead Type Code 2
Lead Type Code 3
etc... these get manually completed.

Then I have another field entitled "Lead Type Code" that I want to display all the entries from the other text fields as a dropdown list.

Any ideas welcome! Thank you.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

Hi @donna_boj 

No a calculated field is by definition read-only and presents a string (text).
You can only concatenate the values of those lead type codes using a calculated field.

3 replies

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 3, 2025

Hi @donna_boj 

No a calculated field is by definition read-only and presents a string (text).
You can only concatenate the values of those lead type codes using a calculated field.

lgaertner
lgaertner
Level 9
March 4, 2025

Hello Donna,

 

If I have understood you correctly, you could do the following:

 

Create an External Lookup field in your form using the following Base API URL:

https://<your-instance>.workfront.adobe.com/attask/api/v19.0/CTGY/search?fields=categoryParameters%3Aparameter%3AparameterOptions%3A%2A&ID=<custom-form-ID>

 

HTTP Method: Get

 

JSON Path: $.data[*].categoryParameters[*].parameter.parameterOptions[*].label

 

 

This will give you all select elements of any field included in your form.

Depending on existing other field types like Radio buttons using parameterOptions, you probably need to work with a filter in the API call. I was not able to find a quick solution for that.

 

The field types can be found under parameter:displayType.

 

MULT (Multi-Select Drop Down)
SLCT (Drop Down)
CALC (Calculated)
RDIO (Radio Buttons)
CHCK (Checkboxes)

...

 

 

Regards

Lars

Donna_Boj
Donna_BojAuthor
Level 3
March 6, 2025

Hi Lars, 

Thank you for this, I am currently trying this approach.
I am struggling to get the data to display in the drop down.
I was wondering if you could check my syntax?
As we have multiple fields to collate the information from I am wondering if my syntax isn't quite right.

Base API URL ​
$$HOST/attask/api/v19.0/CTGY/search?fields=categoryParameters%3Aparameter%3AparameterOptions%3A%2A&ID=671b80dd00056ea2a384d09e91e99c15

JSON Path ​
$.data[*].categoryParameters[?(@.parameter.name=='ccoLeadTypeCode1' || @.parameter.name=='ccoLeadTypeCode2' || @.parameter.name=='ccoLeadTypeCode3' || @.parameter.name=='ccoLeadTypeCode4' || @.parameter.name=='ccoLeadTypeCode5' || @.parameter.name=='ccoLeadTypeCode6' || @.parameter.name=='ccoLeadTypeCode7' || @.parameter.name=='ccoLeadTypeCode8' || @.parameter.name=='ccoLeadTypeCode9' || @.parameter.name=='ccoLeadTypeCode10')].parameter.parameterOptions[*].label

Thanks for your help!

lgaertner
lgaertner
Level 9
March 7, 2025

Hello Donna,

 

I copied your JSON Path replaced some field names and it is working.

Do you get any error message?

 

Regards

Lars

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
March 11, 2025

Hey @donna_boj 
I have a question: Can you help me understand the rationale behind this: 
You have fields like "Lead Type Code 1" - what type are they? Dropdown, text? 

And you want a dropdown of all the values in those lead type fields - why? 

 

Maybe there's a non-Fusion way to get you what you need but I'm not yet getting the rationale 🙂 If you prefer you can DM me. 

Terms & ConditionsAccessibility statement

Loading footer...