Post your feature requests and suggestions on our forum Groups
Cont_bg
Sign in



No_ava
leannej5

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 comes from the fields in my database.

(my current project at MTH is a sample list of bars/ restaurants in my city. Let’s say one drop down list has ‘Cuisine’ type, other has ‘location’, and other may have ‘$ per meal’, etc etc)

Dependent on the selection of the 1st drop down box i.e.cuisine, only the locations which have a bar or restaurant with that particular type of cuisine will be available to be picked 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 us that it only shows 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 could select precisely what he is looking for.

20.01.2010
Supported this topic 0
No_ava
Igor Petrushenko

Hi, Leanne

Thanks for posting your questions here!

Sure, you can have a database linked to your website.
You can find the way to do it in the Widget Builder.
Please, see the Database Widget section.
The same is with forms, see the Form Widget.

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

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

Thank you!

20.01.2010
No_ava
leannej5

Okay,

I might need some assistance with the data integration.

But I’ll explain further as to the type of thing I am looking for 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 cars available for sale. So I select “Toyota” as the car ‘make’.

The next drop down box is “Model”. If I select “Any Make” in the previous “Make” drop down box, the model of every car available for sale will be displayed. However, since I select “Toyota” as the ‘Make’, only “Toyota” branded car models are available for selection 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 need to select multiple options, for example, if I want to purchase a Toyota Celica or a Toyota Supra, then perhaps having the functionality to Ctrl-Select multiple car makes/ models would be ideal!

:-)

20.01.2010
No_ava
Igor Petrushenko

Thank you for this example!

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

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

Thank you and let’s talk with you soon :)

20.01.2010
No_ava
Igor Petrushenko

Hi,

Hope you are well.

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

It’s still Beta, so, please, be patient if you 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 a new field US States, choose other country and States will disappear.

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

Hope it helps you!

03.05.2010
 

© 2006-2011 MyTaskHelper - All rights reserved.