Forms¶

Overview¶

JMC Forms are used primarily for collecting customer information during a transaction. Loyalty customer information, billing & shipping addresses, email, birthday, etc.
They are driven from 2 database tables: CTX_FORM and CTX_FORM_FIELD.

This table is primarily used as the link between entries in CTX_FORM_FIELD, where each form field on a single form maps to the same FORM_ID.
There are only a few fields in this table:

Column name	Purpose
FORM_ID	The primary key identifier for this table.
FORM_GROUP_ID	A way to group forms together. Might be used when a different form exists on different tabs.
ICON_TYPE	The icon type for the form.

This is the driving table for what appears on any form. There are many more fields here that can be setup.

Column Name	Purpose
FORM_ID	A part of the primary key for this table, used to link several form fields onto the same form
FORM_FIELD_ID	A unique identifier for this form field
DISPLAY_ORDER	The order in which this form field should be displayed in context to other form fields
FIELD_TYPE	The type of form field that will be created. Either ALPHA, ALPHANUMERIC, NUMERIC, COMBO, PHONE, EMAIL
ADDITIONAL_STYLE	Additional style to apply to the form field
DEFAULT_VALUE	The default value that will be present in this field upon first-load of the form
ENABLED	Whether the form field is enabled by default
USE_TO_SEARCH	If this column is set it will be used to search for existing records prior to saving
ICON_TYPE	The icon type for the form field
REQUIRED	The form this appears on can't be submitted until at least this field is filled out
READ_ONLY	Makes the field un-editable.
MIN_LENGTH	The minimum length of the field used for validation
MAX_LENGTH	The maximum length of the field used for validation
PATTERN	The regular expression used to validate the field
REQUIRED_OVERRIDABLE	If set, a required field will be able to be overridden and marked as unable to be filled