form Table (482)

•

Environment: onsite, online

• 2 minutes to read

A form which can be published on a webpage and submitted by visitors

Fields

Name	Description	Type	Null
form_id	Primary key	PK
name	The name of this form	String(4000)	●
description	Detailed description	String(4000)	●
config	The JSON-formatted config of this form	Clob	●
folder_id	The folder which this form belongs to. -1 indicates that the shipment is on the root	FK s_picture_folder
script_id	The CRMScript Macro which will be run when the form is submitted.	FK ejscript
response_shipment_id	The id of the s_shipment that is used to send the response mails	FK s_shipment
registered	Registered when	UtcDateTime
registered_associate_id	Registered by whom	FK associate
updated	Last updated when	UtcDateTime
updated_associate_id	Last updated by whom	FK associate
updatedCount	Number of updates made to this record	UShort
active	Indicates if this form is active and available for customers	Bool	●
expires	After this datetime, the form will become inactive	DateTime	●
maxSubmits	After this number of submits, the form will become inactive	Int	●
type	What kind of form is this? Indicates if this is a normal form or a template	Enum FormType
recipe	The JSON-formatted recipe of this form	Clob	●
group_id	The group which this form belongs to.	FK UserGroup
form_key	A short string used as unique id to access this form	String(32)	●
new_ticket	True if this form creates a new ticket	Bool	●

form table relationship diagram

Table	Description
associate	Employees, resources and other users - except for External persons
ejscript	ejscript
form_submission	A form submission
s_picture_folder	This table contains all picture folders
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr
UserGroup	Secondary user groups