Dynamic Redirect After Form Submission Setup With Two Dropdowns?

[larsonchst]

I have a multi-step form (http://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/) and I am using the dynamic redirect (http://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/) to make step 2 depend on a dropdown in step 1.

 

What I'm hoping to do is make this possible using two dropdowns instead.

 

Example:

 

Dropdown 1

 

A

B

C

 

Dropdown 2

 

1

2

3

 

Then in some way (parameters somehow) they are redirected to the url that goes with A1, A2, A3, etc depending on the combination.

 

Hopefully that makes sense. Anybody have any ideas?

 

 

EDIT: I'm thinking they may be able to be done by a cascading dropdown? Dropdown 1 autopopulates dropdown 2 with either A B or C fields and then when they choose from the second that is the redirect?

[aam82]

Does dropdown1 and dropdown2 contain something like

1. domain1.com

2. domain2.com

 

1./search

2./newrecord

 

If so, you could redirect onsubmit to

[field1][field2]

[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