You are viewing limited content. For full access, please sign in.

Question

Question

Pass selected drop down field values made visible via field rules in Forms

asked on May 17, 2017

Hi there,

 

We have 4 field rules that show 1 of 4 drop down fields based on the value selected on another drop down field. What we would like to do is, when 1 of the 4 drop down fields is shown, and a value is selected, pass or copy that selected value to a (hidden) single line field...

 

 

Here, when a car maker is selected, it will show the appropriate model drop down field. What we need is, after a model is selected, copy that value to the single line field.

 

Is this possible using formula? Or a script is really needed? Any example (or script example) would be greatly appreciated.

 

Thank you and regards. 

0 0

Answer

SELECTED ANSWER
replied on May 17, 2017

It's possible with formula like this:

=IF(CarMaker="A",Drop_down1,(IF(CarMaker="B",Drop_down2,"")))

1 0
replied on May 17, 2017

Hi Rui,

 

Thank you for this! Works perfectly.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.