I need a search dropdown form that will generate a URL with parameter

[DavidwDavis]

Found the answer to this question. 

 

I am creating a report where the search (dropdown menu) opens the results in a different web page (my search options are embedded in one web page and the results are embedded in another page). Basically, I have a web page with options on how to search (dropdown menu or an image with selectable areas). The links on the image with selectable areas (counties on a map) all have URLs with the parameter added. Those links go to the web page that has the results form and work fine.

My problem is using Caspio to create a dropdown form element on this same search page, next to the image with the links. When I click the "Search" button after selecting an item from the dropdown menu, I need it to go to another web page, using a URL with the parameter, to view the results. Functionally, I can do this with a "Submission" form, and it works, but it adds a record to the table each time, which I don't want. When I try to do this with a "Report" form I always get the results on the search page (embedded) rather than a link with the parameter that goes to another web page that has the results.

Thanks for any help/guidance.

Edited April 27, 2021 by DavidwDavis
Found the answer.

[NiceDuck]

.... If you simply want the redirection function of the submission form without making it submit any records, I would suggest that remove all actual fields on the datapage setup and use virtual fields instead. If there are no actual field on the DataPage, it is not going to create a record. You can check this article for reference: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/

[astroboy]

Hello, it seems that the workflow for this HowTo article is similar to what you are trying to achieve: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/

I hope this helps. Cheers!

[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

[KG360]

Many thanks @Meekeeelooks like a solid solution - will try it out !