Need to ReDirect to Page Based on Dropdown Selection

[jayandang]

I have an "update" webform with a dropdown field. The dropdown field (VendorSelection) contains two selections/values (Value 1 and Value 2).

If a user selects Value 1 from my dropdown list, they will be redirected to the page in the Destination and Triggers section of the datapage wizard.

If a user selects Value 2 from my dropdown list, I need them to be redirected to a different datapage and to pass parameters into the webform associated with this datapage. I tried using the following javascript:

function getDeps() {

if

(document.getElementById(\"EditRecordVendorSelection\").value == "Value 2")

{

window.location=\"http://www.myurl.com\";}

}

document.getElementById(\"caspioform\").onsubmit=getDeps;

Unfortunately, the redirect is not happening when Value 2 is selected in my dropdown field. Can someone please, please tell me what I am doing wrong. I'm a javascript newbie. Thanks in advance!

[syed.jameel]

Hi,

Try entering the below script in the footer of your data page and once the user selects the Value 2 from the dropdown, it would redirect them to http://www.myurl.com.

Try This.

function getDeps()

{

var deps = document.getElementById("InsertRecordVendorSelection").value;

if (deps == "Value 2")

{

window.location="http://www.myurl.com";

}

}

document.getElementById('caspioform').onsubmit = getDeps;

I hope this solves your problem, if not please provide the URL where we can see the form and the elements , in order to better understand what your trying to do.

Here is a good Java Script resource in http://www.w3schools.com..

Best,

Syed

[jayandang]

Thanks for your quick response!

I tried this code and the page redirect still isn't working. The form that contains my dropdown field which contains Value 2 is an update form. So I tried:

var deps = document.getElementById("EditRecordVendorSelection").value;

as well as

var deps = document.getElementById("InsertRecordVendorSelection").value;

But neither is working correctly

You can access my Update form by doing the following:

1). Click the following link:

http://bridge.caspio.net/dp.asp?AppKey=48fe0000h2g8h2c2g9c7f7h3e9f9

2). Enter "test 1001" into the search box and press the search button

3). My details page with the dropdown field "Vendor Selection" will appear. (Note: This field is the only required field on my update form.)

When "My Favorites" is selected it should redirect users to my URL, but it displays the "Data Submitted Successfully" page from the Destinations and Triggers section of the datapage wizard.

Do you have any additional suggestions?

[jayandang]

I figured it out (partially).

If the script ends with getDeps(), it redirects me to my designated URL.

However, I have another issue. After "Value 2" is entered into my dropdown and my page is redirected to my URL, whenever I subsequently access my update form for this record it keeps automatically redirecting to my URL because "Value 2" is selected in my dropdown field.

However, I still need to be able to edit other fields on my Update form after "Value 2" is entered into my dropdown. So, I only want the page to be redirected when I click the "Update/Submit" button on my form when "Value 2" is entered into my dropdown.

Do you know how I can do this?

Thanks again!

[cheonsa]

Hi @jayandang,

 

You may want to check this forum post.

 

Hope this helps.

 

-kristina

[NailDyanC]

Hi,

Just to add to the previous comment above, you may check this Caspio howto article that might help you: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/?_ga=2.260955845.979740676.1550643373-1104922230.1550643373

[princezuko]

Hello,

You may also utilize parameters to achieve this workflow and tweak the code in this article a little to make it work:

https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/

[astroboy]

If it helps, you may also reduce the number of visible options in dropdown fields by enabling the Record Level Security feature on the form element configuration. Here's a HowTo article for more information:

https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/record-level-security/

[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