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

[Donna_Boj]

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.

[Sven-iX · Accepted solution]

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]

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]

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]

Hello Donna,

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

Do you get any error message?

Regards

Lars

[Donna_Boj]

Hello Lars,

Thank you for helping.
It just states 'No results'.

The fields I am taking the data from are Text Fields and only some will be populated. Will this make a difference at all? Do I need to add an ignore if blank?

Many thanks,

[lgaertner]

Hello Donna,

As far as you are doing a GET-request, did you already try to open a new browser tab with your API-URL to see, if you get any results?

This tab has to be opened in the same browser session, you are already accessing the Workfront UI.

If your company is already onboarded to the Adobe Admin Console / IMS, the URL would look something like this:

https://<yourinstance>.my.workfront.adobe.com/attask/api/v19.0/...

Regards

Lars

[Donna_Boj]

Hi Lars,

I have just checked and I can see there is Data:

{"ID":"678918bd000145b99dd173ea73159d79","name":"ccoLeadTypeCode1","objCode":"PARAM","parameterOptions":[]}},{"objCode":"CTGYPA","parameter":{"ID":"6793573b0005f6f56667a2057d3eea72","name":"ccoLeadCategoryCode1","objCode":"PARAM","parameterOptions":[]}},{"objCode":"CTGYPA","parameter":

But I wonder if I need to add a Project ID wild card? This data will be filled in at Project level, is this URL looking at the Custom form only and not the filled in version on a Project? 

Thanks again for helping!

[lgaertner]

Hi Donna,

perhaps it was a misunderstanding from my side...

My solution is covering the following:

You do have a custom form (API endpoint CTGY), which contains multiple fields with options (select, radio, checkbox).

Now you want to add another dropdown field, which lists the options of the or some other of those fields with options.

If that is what you want to achieve, it would not work with your provided output, as the parameterOptions array is empty and parameter.name==... in your JSON path does not find anything.

Regards

Lars

[Donna_Boj]

Thanks Lars,

I am now going down the Fusion path to try and achieve what I want.

Thanks,

[Sven-iX]

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.