User Table Validation Formula Type

The User Table Validation formula type validates entries in user-defined tables. When you create or edit user-defined tables, select the formula in the Formula field for the user-defined columns.

You can use this formula type to ensure that entries are:

• Between a specified range

• Don’t contain a negative value

You can use the EFFECTIVE_DATE (text) context for formulas of this type.

You must use one input variable called ENTRY_VALUE of data type text.

These return values are available to formulas of this type:

Return Value	Data Type	Required	Description
FORMULA_MESSAGE	Text	N	Returns a text message for either or both statuses. The message is displayed on the Create User-Defined Table: User-Defined Table Values page.
FORMULA_STATUS	Text	Y	Returns the value S (success) or E (error).

This formula checks whether the deduction value entered in the Union A column of the Union Dues table is between 10.00 and 20.00:

/* Formula Name: Union A Dues Validation */
/* Formula Type: User Table Validation */
INPUTS ARE entry_value (text)
IF TO_NUMBER(entry_value) < 10.00 OR 
TO_NUMBER(entry_value) > 20.00 
THEN
(
formula_status = 'e' 
formula_message = 'Error: Union A dues must be between $10.00 and $20.00.'
)
ELSE
(
formula_status = 's'
formula_message = ' '
)
RETURN formula_status, formula_message