How can I get a selection from a Drop Down to populate other field

  • Thread starter Thread starter kmt1984
  • Start date Start date
K

kmt1984

I have a drop down box with options like Minnesota, Oregon, Rhode Island,
South Dakota. What I need is once a state is selected I want fields such as
Phone Number and Address to automatically populate with the correct
information. I am trying to avoid as many errors as possible by users. Any
help would be greatly appreciated!
 
Hi kmt1984,

For this to work, you'll need to protect the document for forms. Note too that a Dropdown formfield can only have 25 items.

When designing the document make sure the drop-down formfield has its 'calculate on exit' option checked.
Then, for each option, create a series of IF tests like:
{IF{Dropdown1}= "Minnesota" "555-1234-678"}
{IF{Dropdown1}= "Oregon" "555-3579-246"}
etc
where Dropdown1 is the bookmark name of the Dropdown formfield.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.
 
Back
Top