Drop Down Redirect

[mbburell]

I have created a casscading dropdown State --> City that works as expected. However, I would like the user to be redirected to the URL contained in the field "link" when they select the city they want and click submit.

Currently it is setup to go to a details page where the user then needs to click the link from there to get redirected to the URL. It would be much simpler if the redirection happens upon the initial selection.

The search and report datapage is called "state_search_xxxx" the field that contains the link is "link"

Datapage link is here: http://b2.caspio.com/dp.asp?AppKey=6c43 ... g1f6d1i7f1

Can someone please help.

Thanks

Matt

[bahar_vm]

Hello Matt,

The URL of the page is not complete, can you please paste the URL again, it seems some part of it is lost.

Thanks,

Bahar M.

[mbburell]

Hopefully this is what youll need?

url

http://b2.caspio.com/dp.asp?AppKey=6c43 ... g1f6d1i7f1

link

State Search_xxxx

embedded

Click here to load this Caspio Bridge DataPage.

[Kurumi]

Hi - Just an update, you may now use Virtual Field and Calculated Value on this workflow.

You may use a Virtual Field as a holder or identifier of the value from the dropdown and then set the Form Element as Calculated Value. In the Formula, you may use a CASE WHEN statement like:

CASE WHEN [@FIELDNAME] = 'value'
THEN 'https://www.google.com/'
WHEN [@FIELDNAME] = 'value 1'
THEN 'https://caspio.com/'
ELSE
https://www.youtube.com/
END

After setting up the formula, on the Destination and Messaging configuration screen, set the Destination after the record submits to 'Go to a New Page'. Lastly, in the Page URL, call the Virtual Field from the field picker.

For reference, you may check these links:

https://howto.caspio.com/datapages/datapage-components/virtual-fields/
https://howto.caspio.com/datapages/datapage-components/calculated-values/
https://howto.caspio.com/function-reference/
https://howto.caspio.com/datapages/forms/submission-forms/#:~:text=to make conditional.-,Destination and Emails,-Here you can