Dynamic Redirect

[wdandrews]

I'm trying to set up a dynamic redirect after a user enters a code. I have a table set up that has a code and a url for the code. When a user enters a code in the first form field it completes a cascading text box with the url and after clicking submit it takes you to the correct page. All good. However, I found that an entry is entered into the url table. So I set the fields as virtual fields and now it enters a blank value into the table. How can I prevent a entry into the table? Also, I would like the url field to be hidden and not displayed. So the only form field displayed to the user is the code field. In the Dynamic Redirect How To is says you can set up a field as hidden, but when setting the field to hidden nothing happens. I appreciate any help offered.

[Vitalikssssss]

Hi wdandrews,

 

You may consider using drop-down Virtual field instead of two text fields one of which is cascading.
Here is the link to an article which describes the concept:

https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/

 

Regards,

vitalikssssss

[wdandrews]

Thank You Vitalikssssss, but can the drop-down be hidden and still send the user to the correct url? I need the user to only see the url that is specific to that user and not any of the others.

[Vitalikssssss]

Hi wdandrews,

You can use Record-Level-Security to restrict options list in the drop-down if your Datapage is authenticated.

https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/filter-lookup-dropdown-or-listbox-based-on-user-or-role/

Hope this help.

[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