You can use a web service to populate to a Drop Down, Select
One, and Select Many form item.
The following instructions describe how to populate a Drop
Down, however the same instructions apply for populating the Select
One and Select Many form items.
-
Select Drop Down from the Palette
and drop it onto your form.
-
Click the Edit Properties icon.
The Edit Properties
window opens.
-
Click the Events tab.
-
From the Client Side: list, select
an action to associate with the service.
A window for the
web service opens. From this window, you can:
- Select a predefined action, such as Run a Formula, Call
a Service, or both.
- Insert your own custom code in the Custom Actions area.
-
Select Call a Service.
From
this menu, you can:
- Select an existing web service from the menu. If you select
an existing service from the menu, go to step 9.
- Create a web service call by clicking Add/Edit
Service Configuration. To configure a web service, go
to step 6.
-
Cick Add/Edit Service Configuration, to open the Service
Configuration window.
- Enter the URL of your service
- Select Or, select a service and select a URL from a list of available
services
-
Click the Inputs tab.
-
Select a source from the Select source: window.
-
Select a target from the Select target: window.
-
Click the connector icon located between the two windows
to link the source and the target.
The connected source and target are shown in the Assigned Inputs
section of the page.
-
Click the Outputs tab.
-
Select a source from the Select source: window.
-
Select a target from the Select target: window.
-
Click the connector icon located between the two windows
to link the source and the target.
The connected source and target are shown in the Assigned
Outputs section of the page.
-
Click OK to exit the Service
Configuration.
All form item data is stored in database columns.
For Drop Down, Select One, Select Many, and Survey items, the data
column must be large enough to accommodate the largest value a user
can select. The amount of space that is allocated to a database column
is based on the larger of either the Storage Size parameter (50 characters),
or the largest defined static value. As it is possible to pull information
from a web service or from JavaScriptâ„¢ into
the previously listed form items, Forms Experience Builder cannot
calculate the largest size needed. To set larger database columns,
modify the Saved Value character limit field
to ensure that it is large enough to hold the largest value expected.
-
Click the Advanced tab and change
the size of the Saved Value character limit field
to the required number of characters.