Expand my Community achievements bar.

SOLVED

Adobe Workfront - Customer Form External Lookup Issue

Avatar

Level 4

I have created a custom form with an external lookup to a fusion api.  This works fine with hard coded Channel parameter, but I need to pass a radio button choice as a parameter and am unable to get this to work (via preview).

 

The radio button has a label and name of "Channel" and has three choices "SMS", Email" and "Push"  

 

The external look up works fine with the url is as follows, channel value is received by the fusion api as SMS (note fusion id and client token replaced with dummy values)

https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel=SM...

 

The external look up fails when SMS is selected via the radio button and the url is as follows, channel value is received by the fusion api as blanks 

https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel={C...}

 

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Ken,

 

As your "Channel" parameter is a custom field, you should prefix it with DE: in your URL, so it should look like this:
https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel={D...

 

Regards

Lars

View solution in original post

4 Replies

Avatar

Correct answer by
Level 10

Hi Ken,

 

As your "Channel" parameter is a custom field, you should prefix it with DE: in your URL, so it should look like this:
https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel={D...

 

Regards

Lars

Avatar

Level 4

@lgaertner Thanks for the reply.  I've tried changing the url from https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel={C... to https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel={D... but it's still the same result.  When I look at the fusion api the channel value is empty.  I did wonder if the radio button was the issue but even using a standard text field and entering a value gives the same result.  Is there something peculiar with how the preview works?  

Avatar

Level 10

Hi Ken,

 

I would try to "debug" this in really small steps:

- Chose an example object (project, task, ...) the custom form containing the custom field is attached to, where a value is set. 
- add a temporary custom field of the type "calculated field" and just enter

 

 

{DE:Channel}

 

 

to see the corresponding value.

When you are in the Calculation Editor, you can paste the object id into the field under Preview on an existing object.

 

You could also add another custom calculated field containing your whole URL like this:

 

 

CONCAT("https://hook.app.workfrontfusion.com/xxxxxxxxxxxxxxxxxxxxxxxxxxxssssss?clientToken=999999&channel=",{DE:Channel})

 

 

 

 

Open your example object and switch the radio button to see,

- if the url changes

and

- if the url makes sense (test it by copy & paste into address field of a new browser tab)

 

You could also send some screenshots of your setup. Perhaps this will help us to assist you.

 

 

Regards

Lars

 

Avatar

Level 4

Hey Lars, after a bit of trial and error I was able to setup the suggested debug fields and added the custom form to a task.  The debug fields picked up the Channel.  It looks like the preview doesn't handle the {DE:Channel} for some reason and it only works when the form is attached to a task.  Thanks for your help.