Video Screencast Help

Update Text box with variable from drop down

Created: 01 Aug 2014 | 2 comments


I have a form where a user has a drop down menu that is generated from a sql query.  Based on whatever the user chooses, i would like to update another text box from the same query but different column and have it display in real time. For example, a user chooses Adobe Reader to download, but has a price, i woudl like the price field to update and display when the user chooses Adobe Reader.  I have 1 query that pulls all the information for the applicatoin, and i also have another query that will only pull the price of the app.

How do i have workflow auto update and display the app, relative to the selection in the drop down?

Operating Systems:

Comments 2 CommentsJump to latest comment's picture

I'd use an ajax label component. It has an embedded model to determine what text to display in the label, so that would be a good time to run the second component (to get price) based on the value of your drop down under the "ThisFormData" collection. I believe you will need to set the drop down itself to "Post Form on Value Change".

As an aside, if you are already pulling on the information for the data row, why do you need the second query? You could just pull that originally, and use the ajax label model to find the correct price to display. That should be a hair faster.

If a post solves your issue, please mark it as a solution. It makes these forums better for everyone.

André Florencio's picture


You must configure two components according to the list is dynamic. 

1 Insert the DropDown and set items (Dynamic or Static). Important is the name of the output varivavel in our case and select the Software update value after selection as image below. 


2 Insert and Configure the Ajax component. Functionally tab select the "..." button to set the "Label Text Model". In the next screen enter the integration to capture the price of the software as below. 



These two settings should meet the need. 


André Florencio