Jump to content
  • 0

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



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 by DavidwDavis
Found the answer.
Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

.... 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/

Link to comment
Share on other sites

  • 0

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:

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

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/forms/submission-forms/#:~:text=to make conditional.-,Destination and Emails,-Here you can

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...