All things TrackVia!
Read, write, comment.
Product Question
Is there a way to create a Conditional Drop Down List? I...
Product Question posted 11/16/09 by Lee Waronker
550 Views, 5 Comments
Question:
Is there a way to create a Conditional Drop Down List? I would like to create a 2nd drop down list that is based on the first drop down list. For example, the first list would be types of property, say LAND, OFFICE, INDUSTRIAL. Once I choose LAND the next drop down list would be residential, commerical, multi-family. But, if I choose OFFICE, the choices are medical, multi-story, owner-user. I do this in Excel with the =indirect comand
Comments
We have this logged as a suggested enhancement but can't be sure when this would become available. If you have a set database structure and the values would not change we may be able to build this into your account or onto a website form but this is not yet ready to allow for you to setup and control the choices.
Good suggestion. I would be interested as well. That type of dynamic list and data validation would be a great add. I know a lot of the online web form companies like Wufoo or SurveyGizmo handle this type of logic. Maybe there's a way to use a more fully featured entry form as a front end to a TrackVia backend?
Along the same line...it would be great to have some standard drop down options available when creating a drop down field i.e. State, etc. I love the way Wufoo does this.
We don't offer prebuilt dropdown lists but we do have a forum article which provides a comma separated list of all countries as well as both the full name and postal abbreviation for each state.
As far as conditional fields, we've dabbled a bit in using website forms as a more intuitive user interface to populating data in a particular database. You can use standard tools such as Javascript to perform the conditional field functions. However, the drawback is that dropdown options in a published website form aren't dynamically linked to the database. If you published a webform and then added some drop-down options to a particular field in the database, you would have to manually add those fields to the code of the webform. Not ideal, for sure.
Any enhancements to improve the front-end input interface would be great!