Keyword to use
Internal drop-down list
In order to create an internal drop-down list, which is within your form, you may use one of the following keywords:
Description | Keyword to Use |
List with one choice | combo |
List w/ one choice and a custom input | combocustom |
List with multiple choices | multi |
List w/ multiple choices and a custom input | multicustom |
With this control, you will be able to:
Choose one or multiple choices;
Add a custom choice, entered by the user;
Modify the list easily within the Excel;
Requires an update of the form to view the changes in the list.
In order to use this control, make sure that you are within Column A of your Excel form and that there is a pound symbol (#) followed by the exact title of your drop-down list.
Then, everything that will be under it, until an empty cell, will be part of your list.
Example:
External drop-down list
In order to create an external drop-down list, which is in an Excel of its own, you need to use the keyword list.
Description | Keyword to Use |
External list | list |
With this control, you will be able to:
Have access to a retroactive list, which means all changes done to the external list will be applied without an update/new version to the form;
Allows you to use the other columns within the list to fill out fields automatically when you choose an item from the list;
Adds a search bar to properly filter long lists;
Modify the list easily within the Excel;
Can only pick one item at the time;
Can not do a custom/"other" choice.
In order to use this control, make sure that the title of the field on your form is identical to the title of the column within the external list file.
Then, everything that will be under it, until an empty cell, will be part of your list.
To do the link between your form and the external list, make sure to use the validation rule for it.
Type of controls available with this keyword
Field
Use the ABC method to create a field control.
Column
Use the 123 method to create a column control.