Workflow Plus - Free Fields
Additional Free Fields
Section titled “Additional Free Fields”Workflow Plus extends the standard free fields by providing additional fields across multiple field types, with up to 150 fields available depending on the field type.
Available Free Fields
Section titled “Available Free Fields”| Field Type | Additional Fields | Total Available |
|---|---|---|
| Free Text | 135 | 150 |
| Free Date | 95 | 100 |
| Free Yes/No | 145 | 150 |
| Free Number | 45 | 50 |
| Free Amount | 45 | 50 |
| Free GUID | 40 | 50 |
| Free Comment | 20 | 20 |
| Free Signature | 10 | 10 |
| Free DateSignature | 10 | 10 |
| Free Attachment | 25 | 25 |
| Free CommentHTML | 20 | 20 |
| Free ImageSignature | 10 | 10 |
| Free PersonSignature | 10 | 10 |

- All fields available in Standard Workflow Searches and Pivot Analysis View
- Stored in table:
GLMSysWflRequests
Enhanced Free Comment Fields
Section titled “Enhanced Free Comment Fields”Enhanced Features:
-
Freeze Everyone Prevents further comments from being added for Multiple Type Requests.
-
Comment above freeze - Displays the remarks section above the freeze line.
-
Add latest comment on top - Displays the newest comments first.

Free Text Fields: Hyperlink/URL
Section titled “Free Text Fields: Hyperlink/URL”Free Text fields can be configured as clickable hyperlinks. URL parameters can be populated dynamically using values from other request fields.


Hyperlink Configuration
Section titled “Hyperlink Configuration”| Setting | Description |
|---|---|
| URL | Target URL for hyperlink |
| Parameter | Dropdown: Select request fields to use as URL parameters |
| Parameters | Format: [URL Parameter],[Request Field] |
Result: Clicking hyperlink opens document search with “Text” and “Created by” fields pre-populated from request data.
Free Field Database Mapping
Section titled “Free Field Database Mapping”All free fields are stored in the GLMSysWflRequests table.
| Field Type | Request Field Range | Column Name Range |
|---|---|---|
| Text | Free: Text16 – Free: Text150 | FreeTextField_16 – FreeTextField_150 |
| Date | Free: Date6 – Free: Date100 | FreeDateField_06 – FreeDateField_100 |
| Yes/No | Free: Yes/No6 – Free: Yes/No150 | FreeBooleanField_06 – FreeBooleanField_150 |
| Amount | Free: Amount6 – Free: Amount50 | FreeAmountField_06 – FreeAmountField_50 |
| Number | Free: Number6 – Free: Number50 | FreeNumberField_06 – FreeNumberField_50 |
| Guid | Free: GUID11 – Free: GUID50 | FreeGuidField_11 – FreeGuidField_50 |
| Comment | Free: Comment1 – Free: Comment20 | FreeCommentField_01 – FreeCommentField_20 |
| Comment HTML | Free: CommentHTML 1 – Free: CommentHTML 20 | FreeCommentHTMLField_01 – FreeCommentHTMLField_20 |
| HTML (Request) | Free:Request*HTML | RequestCommentsHTML |
| HTML (Workflow) | Free:Workflow*HTML | WorkflowCommentsHTML |