SoftadminGuide.FieldInfo_Definition
Type:
Table-valued function
Used to create temp table #FieldInfo, passed to the procedure SoftadminGuide.FieldInfo_Create.
Resultsets
Resultset: #FieldInfo
Table count:
repeated exactly once
Row count:
no rows (only column metadata)
Columns
FieldInfoGuid mandatory uniqueidentifier
Identifies the field info.
TableName mandatory string
Table name of field info.
FieldName mandatory string
Field name of the field info.
FieldLabel mandatory string
Label of the field info.
ControlType mandatory string
Control type of the field info. Sometimes called "Field type".
| Possible value | Description |
|---|---|
| Boolean Dropdown | |
| Checkbox | |
| Colorpicker | |
| Consent Checkbox | |
| Date | |
| Date Range | |
| Datetime | |
| Dropdown | |
| File | |
| File Upload Area | |
| Heading | |
| Heading (Collapsible) | |
| Heading with Checkbox | |
| Hidden | |
| HTML Editor | |
| Info Text | |
| Password | |
| Radio Button Column | |
| Separator | |
| Signature | |
| Textarea | |
| Textbox | |
| Textbox with Autosearch | |
| Time | |
| Uneditable Text |
IsMandatory optional bit
"Mandatory" setting of the field info. Optional or not depending on control type.
ControlWidth optional string
"Control width" setting for the field info.
| Possible value | Description |
|---|---|
| Long | |
| Longest | |
| Medium-long | |
| Medium-short | |
| Short | |
| Shortest |
ControlProcedureName optional string
Stored procedure used by the field info. Usage depends on the control type.
AllowHtml optional bit
"Allow HTML" display setting of the field info.