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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top