|
Overview
UDF Lists provide drop down lists for UDF fields. Lists are not restrictive in that a user can still enter a value that is not contained in the list. Lists for UDFs are managed here.
Key Concepts
| • | UDF Lists need to be created before any UDF that will be using a List. |
Field Descriptions
System Lists Management Window
| • | Lists Text Box - The Lists Text Box is used to create a list. Enter a list name in the Lists box, and click Add. That will create the Named List. You will still need to go to the "Static List" or "SQL List" on the right to populate the list. |
| • | Static List - The Static List allows you to enter the options that you would like to see in the drop-down. For example, If the UDF was named State, your Static List could be ME, NC, VA, etc. |
| • | SQL List - The SQL List allows you to enter a query that will return the selections in the UDF List. For example, If you wanted a list of States from the List Management list, you could use the following SQL Query: |
Select
DisplayText=StateName,
DisplayValue=StateCode
From
PostalStates
Note - You must alias the fields that you want to use with DisplayText (What you see in the drop-down) and DisplayValue as you see above.
| • | Preview - Allows you to see what the returned fields will look like in the query. |
|