how can i set the value of a dialog field conditionally on the value of another field

[richard2007]

i have a field which is a dropdown, i need to set the value of another field based upon the value selected in the dropdown field.

how can i do this - i know how to set the value of the field, just dont know how to set it conditionally.

thanks

[Lance Gurd]

Re: how can i set the value of a dialog field conditionally on the value of another f

Hi Richard,

Consider using a lookup instead of a dropdown, use a table dbf or sql to hold the data for the lookup and what is needed to fill in the other control

[DaveF]

Re: how can i set the value of a dialog field conditionally on the value of another f

Have you looked at the "Conditional style and events" property"? I use this on fields I want to change based on the selection in a dropdown list. You can optionally specify a Javascript function if you have more complex manipulations.

[agillbb]

Re: how can i set the value of a dialog field conditionally on the value of another f

In the dropdown field's onchange js event, you can use your {dialog.object}.setValue('xxx', 'yyy); syntax to set a field based on getValues and if {} statements.

[richard2007]

Re: how can i set the value of a dialog field conditionally on the value of another f

In the dropdown field's onchange js event, you can use your {dialog.object}.setValue('xxx', 'yyy); syntax to set a field based on getValues and if {} statements.

i am ok setting values, its the syntax for the conditional {} statements i would appreciate some help.

Have you looked at the "Conditional style and events" property"? I use this on fields I want to change based on the selection in a dropdown list. You can optionally specify a Javascript function if you have more complex manipulations.

i could only see how to se the styling conditionally

[DaveF]

Re: how can i set the value of a dialog field conditionally on the value of another f

Assuming you had a limited number of known selections in your dropdown, you would have to create a separate condition for every dropdown value and enter the corresponding value in the conditional text field. If you have a lot of possible values in your dropdown, you will probably want to use Javascript.

You can optionally specify a Javascript function if you have more complex manipulations.

You would need to enter a function name at the bottom of the "Conditional style and events" dialog and then create the function in the "Javascript functions" code section. Since you need to do this in Javascript, you could optionally put the code in the dropdown's onchange event as Andy suggested above. If you did it this way, you would not need to use the "Conditional style and events" property.

Let me know if you need any help with the code.

[richard2007]

Re: how can i set the value of a dialog field conditionally on the value of another f

i have 3 options, is it possible to get a code example of the sytax, i havent done this is javascript before and cant find an example on the msg board.

thanks

richard

[DaveF]

Re: how can i set the value of a dialog field conditionally on the value of another f

With only 3 options, you do not need to do this in Javascript. You can create 3 conditions, one for each option/value pair. Let’s say the dropdown control has the values “1”, “2”, and “3” and you want to change a textbox control to “alpha”, “beta”, or “gamma” depending on the option selected in the dropdown.

In the "Conditional style and events" property for the textbox control, you would add a condition and enter the following for the Logical Expression: dropdownbox = “1”

You would substitute your dropdown control variable name for "dropdownbox". Then enter “alpha” for the Conditional Text. Click Ok to save the condition and repeat the process again by adding two more conditions for options “2” and “3”. If the logic is more complex than this example, you should consider adding the logic to the dropdown control’s onclick event using Javascript. Let me know if you need to go the Javascript route.

[DaveF]

Re: how can i set the value of a dialog field conditionally on the value of another f

Sorry, I meant the dropdown's onchange event, not onclick.

[agillbb]

Re: how can i set the value of a dialog field conditionally on the value of another f

David's recommendation is your best bet - especially if you are not yet comfortable with js, and only have 3 options.