All things TrackVia!
Read, write, comment.
Product Question
- Web Forms - Dynamically populating...Product Question posted Sep 24 by tnelson
156 Views, 
2 CommentsQuestion:Web Forms - Dynamically populating drop-down options into a webformAnswer:I'm working on creating a two part webform that feeds into two different database tables. Users would fill out information for a new program in the first page of the form. This info would go to one database table.
I once the user clicks "Submit", it redirects to the next page of the form. On this page, I would like the user to select the new program they just submitted from a drop-down (the target field in TrackVia is a parent lookup), then fill in some other information about that program and click "Submit" to send to another database table.
Essentially, my question is, "Using webforms, can you set up certain dropdown lists that are tied into "Parent Lookup" fields to be dynamically updated as new programs are added?
Thanks!
Comments
Currently there is not a way to have the website form dynamically pull available options for a drop down list based off records in the database in real time like what happens in TrackVia. With most of our customers information is being added into the database while logged into TrackVia and although we have plans to make the databases more functional through a website this isn't something that we are currently working towards. You might see this change towards the middle of 2010 but for the foreseeable future we will be working on making enhancements to functionality available to logged in users and not website visitors. If the individuals adding a program were to log into the account they would be able to create a record that links to the original "program" record in another database.
Thanks for your response. One of the things that I like best about the website forms is that you can make a much simpler user interface to input data (Adding additional descriptors next to the form fields, presenting the fields in a more logical way such as groups, etc.). Also, you can utilize some great web coding tools to create conditional fields. If some of these features were implemented into the functionality for logged-in users within TrackVia, that would be great. (For, example, I often utilize a website form for adding data to a particular database rather than logging in, simply because of these features.)