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

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!
 
M

macropod

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

Top