Always With You
Login       Sign Up       About      Contact

Back to all Posts

Field data results dependent on previous field data selection?
(Completed - 0 Total points)

I’m not sure if I just haven’t found where to do this or if there is no such functionality, but i want to be able to do the following:

• Have data in a database that is linked to my website

• Have a form on the website that has several dropdown boxes, the content in each box come from fields in my database.

(my project currtently on MTH is a sample list of bars/ restaurants in my city. Lets say one drop down list has ‘Cuisine’ type, another has ‘location’, and another may have ‘$ per meal’, etc etc)

Dependent on the selection of the 1st drop down box i.e.)cuisine, then only the locations which have a bar or restaurant with that particular type of cuisine will be available to pick in the ‘location’ drop down box.

I thought this would be a validation type, so that i first create one drop down box, then create a second box in the same form, and i use a validation rule that tells it to only show certain field data dependent on what was selected in the previous drop down list.

I hope this makes sense!

This way, the search will basically narrow itself down, so that the visitor has selected precisely what they’re looking for.


by leannej5 | 4 comments | 0 supporters (show) | 0 Total points (show)



Igor Petrushenko replied 8 months ago

Hi, Leanne

Thanks for posting your questions here!

Sure, you can have database linked to your website.
You can find the way to do it in Widget Builder.
Please, see Database Widget section.
Same with form, see Form Widget.

You can embed your form for data input and below, in the other section, have database integrated.
So, when any new entry will be added using form it will be seen below in database section.

Regarding your drop downs questions: it’s not possible right now. However we very interested in implementing it.
Now you can achieve this by creating several forms. If you can provide any screenshots, more examples it will be very helpful for us so we can build exactly what you need.

Thank you!

leannej5 replied 8 months ago

Okay,

I might need some assistance with the data integration.

But i’ll explain further as to the type of thing I am looking to do.

Go to the following site: www.carsales.com.au

There is a drop down list for “Make”, which has every make/ brand of car available for sale. So I will select “Toyota” as the car ‘make’.

The next drop down box is “Model”. If I had selected “Any Make” in the previous “Make” drop down box, the model of every car available for sale would have been displayed. However, since I selected “Toyota” as the ‘Make’, only “Toyota” branded car models are available to select in the ‘Model’ drop down list.

Then I click on the “State” where I am located in another drop down box, then the next drop down box after that is titled “Region”, and only regions from within my selected state appear in the list.

This way, the data is sorted dependent on the previously selected options.

There may also be circumstances when I would need to select multiple options, for example, if I wanted to purchase a Toyota Celica or a Toyota Supra, then perhaps having the functionality to Ctrl-Select multiple car makes/ models would be ideal!

:-)

Igor Petrushenko replied 8 months ago

Thank you for this example!

Sure, we understand and it definitely makes sense to implement this.

We will start working on it and get back to you asap!

Thank you and talk to you soon :)

Igor Petrushenko replied 4 months ago

Hi

Hope you are well.

We’ve finally created what you asked.
It called Rules and you can find it in Form Builder.

it’s still Beta, so, please, be patient if you will find any issues with it :)

But shortly you can now do things like this
http://mytaskhelper.com/widgets/akIrPRWAbavAbOchIVdPhD/bB356f5RLeQP3VFlAqeGJx

Choose United States and you will see new field US States, choose another country and states will dissapear.

Another field asks you if you are married, if you answer is Yes it will ask your wife name.

Hope it helps you!


Back to all Posts