Ask Your Question

Can I add a drop down box field in my document? [closed]

asked 2012-10-05 11:29:24 +0200

Benjamin gravatar image

I would like to create a single receipt of payment document for each of the services my company offers.

I would like the receipt document to contain a drop-down box listing all our services to be chosen from whenever the document has to be issued for our customers.

Is it possible to add such a drop down box in my document (and print without showing the drop down box)? If so how?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:19:28.913288

3 Answers

Sort by » oldest newest most voted

answered 2012-10-05 12:52:38 +0200

JohnSUN gravatar image

Another way - use field InputList

HowTo use InputList

edit flag offensive delete link more


Perfect answer, thank you.

Benjamin gravatar imageBenjamin ( 2012-10-05 14:19:28 +0200 )edit

answered 2012-10-05 14:53:36 +0200

ase618 gravatar image

If I understand your request correctly, create a list of your "services" you want in the dropdown. Put one entry per cell and only use one column. It can be on the same sheet in a different area or in another sheet. Next go to Data/Validity. Under the Criteria tab, in the Allow dropdown choose Cell Range. In the Source box that appears select the range of your list you created. Make sure you only select the column the list is in. You can select extra empty cells at the bottom to leave room for expansion. Now go back to the cell or range of cells you formatted with the data validity and fill the rest of cells you want a dropdown in. Click the cell and a dropdown box will appear with the contents of your list. If you want to do more with the results you can add formula's that will pull in pricing, model numbers, etc. The dropdown arrow/box will not print. I use this all the time and it works very well. Let me know if you need anymore help. Sorry for the long-winded reply.

edit flag offensive delete link more

answered 2012-10-05 12:07:09 +0200

mjjzf gravatar image

updated 2012-10-05 12:07:59 +0200

You can do this with Form Controls: View > Toolbars > Form Controls - but I am not sure it can be done so ihe dropdown is not visible.

edit flag offensive delete link more


I can drag and drop the listbox into the text, but how can I actually use it? When I click on it, all I get is a move cursor, I don't actually get the opportunity to use the listbox.

Benjamin gravatar imageBenjamin ( 2012-10-05 12:47:16 +0200 )edit

Question Tools

1 follower


Asked: 2012-10-05 11:29:24 +0200

Seen: 12,312 times

Last updated: Oct 05 '12