Unlimited User Defined Fields

Set an unlimited number of user defined fields (UUDFS) for the Names, Course, Instructor, and Register tables.

Define Unlimited UDFs

You must define your unlimited UDFs before you can use them. To do so:

1. Open the Preferences screen.
2. Select the appropriate Preferences tab.
3. Click the tab's UDFs button (e.g. Name UDFs,, Course UDFs, Instruct IDFs, or Register UDFs).
4. Click the Additional UDFs button on the User Defined Field Setup window.
5. This opens the Define Unlimited UDFs window.

6. To add a new unlimited UDF, click the Add button.
7. Enter a name for the UDF. Enter in all lowercase, with underscores instead of spaces. Any symbols other than underscore will be removed.

8. Define the field type:

   • . Character - can contain any combinations of characters or numbers
   • Numeric - can only contain numbers
   • Boolean - logical true or false (checkbox)
   • Date - date field (mm/dd/yyyy)
   • Memo - a virtually unlimited memo type field for storing large amounts of text

9. Choose the field style:

   • Regular - an open text box
   • Dropdown - a dropdown list (must define values in the dropdown code column)
   • Memo - large text box with scroll bar and expandable view/edit mode

10. Dropdown Code (used when field style is set to D - Dropdown)

    • name your dropdown code. The code must contain the word udf (for example: tshirtudf, udf_pants_color)
    • double click the dropdown code after naming it, this will open the add code screen
    • create your defined values for your dropdown list by entering their codes and descriptions

    

11. Set or change the order (optional).

12. Click the OK/Close button to save your fields and close the Define Unlimited UDFs screen.

Entering Data in Unlimited UDF

To enter data in the Unlimited UDF field:

1. Open] the appropriate Name, Course, or Registration record.
2. Select the Additional Info (UDFs) tab.
3. Click the Additional UDFs button.

4. After entering data, click the Save button to save your entries.

Reporting on Unlimited UDFS

You can pull in the values of your unlimited UDFS using these new functions:

• ADDNMUNL()
• ADDCOUNL()
• ADDRGUNL()