User-Defined Tables

•
Environment: cloud
• 1 minute to read
 • 1 minute to read

User-Defined fields. Key constants are the user-defined field progId.

User-Defined Fields

Field Type

OperationTypes

Expected Field Values

Number and

Decimal

Set

Values Count = 1

Values[0] = (int)

ShortText and LongText

Set, Clear, SearchAndReplace, RegEx

Values Count = 0 to 7

Set: Values[0] = (string)

Clear: Clears value

SearchAndReplace:
Values[1] = searchString
Values[2] = replaceString
Values[3] = options

RegEx:
Values[4] = expression
Values[5] = replace with
Values[6] = options

Date and UnlimitedDate

Set, Clear

Values Count = 1

Set:
Values[0] = (Date)
or
Values[0] = (DateTime)

Format: InvariantInfo

Clear:
Sets date to min date: 1/1/0001 12:00:00 AM

Checkbox

Check and Toggle

Values Count = 1

Check:
Values[0] = (int) or (bool)

Toggle:
invert current value

List

SelectOne, Clear (?)

Values Count = 1

SelectOne:
Values[0] = (int)

Clear:
Only on certain UDF’s.