Pre-Populate Forms via URL string -...

User 187934 Photo


Senior Advisor
20,193 posts

What do you want the values of the drop down to be based on or to come from?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2636807 Photo


Registered User
4 posts

Hi Eric

I am also trying to pre-populate a drop down field via a url:

I have a booking form where the first field is a dropdown list of bookable options

What I want to be able to do is have a booking link from each option description page that pre selects the chosen option

my test form is http://frogbusiness.net/ht/helicopterdays.php

there are 4 tour options, so I would like to have the option that is someone is reading about tour 1 (London City), they can select a book now link that takes them to this form but has already pre selected London City as their tour

Hope that makes sense?

Many thanks for your help
Kind regards
Paul
User 187934 Photo


Senior Advisor
20,193 posts

So you really don't need a dropdown to have them choose a value? You really only want the value from the link they came from?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2636807 Photo


Registered User
4 posts

Hi Eric

many thanks for your quick reply:

I was thinking that if the dropdown list was there, if the customer had selected the wrong buy now link (ie Portsmouth City but they actually meant to select Portsmouth Habour) then they could simply change the dropdown without having to go back to another page.

Also, the dropdown options are what drive the base price and the number of passengers simply multiplies it

Kind regards
Paul
User 362156 Photo


Registered User
46 posts

Hi Paul, did you find a solution? I'm working on the same issue here.
User 187934 Photo


Senior Advisor
20,193 posts

From what I can gather from everyone is that you'll want to have a dropdown populated from a mysql database. The mysql query will have the needed select clause that will grab the appropriate values. Mysql queries are super flexible because they can have OR inside to look for several different variables and make its selection based on that.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 362156 Photo


Registered User
46 posts

Hi Eric, thank you for the comment, I was just curious if this post had resulted in a solution as our situation seems very similar to what Paul described. Prefilled forms are not on my shortterm todo list, but would be a very nice improvement to our current booking forms. I guess we will then skip the dropdown field though.
User 187934 Photo


Senior Advisor
20,193 posts

I'm still waiting for anybodies response before putting up an example. Not totally sure on each ones needs.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 362156 Photo


Registered User
46 posts

Hi Eric, we currently use a booking form where the client selects a bike tour from a dropdown list. They arrive at the form through a "book now" button on a products page. They first select the tour, then the number of adults, children etc. Everything works fine, but I'm looking for options to make the process more user friendly as clients sometimes select the wrong tour.
I would like the field for the selected tour to be prefilled when the client clicks on the link om the product page. If we can get this field prefilled we do not need to use the dropdown list.
User 187934 Photo


Senior Advisor
20,193 posts

Did you try the solution above?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.