Workflow Plus - Free Fields

This module extends the standard limited free fields to provide 50+ fields per type with full functionality.

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

Key Benefits:

• All fields available in Standard Workflow Searches and Pivot Analysis View
• Stored in table: GLMSysWflRequests

New Features:

• Freeze Everyone for Multiple Type Requests (not available in Exact’s standard Remarks fields)

• Comment above freeze - Display remarks section above freeze line

• Add latest comment on top - Newest comments appear first (descending order)

  

Create clickable URLs in text fields using dynamic parameters from other request fields.
Example Use Case: Store a package tracking number in one field: Click hyperlink to open tracking website with that number pre-filled.

Setting	Description
URL	Target URL for hyperlink When read-only + default text set: shows default text, clicks open URL
Parameter	Dropdown: Select request fields to use as URL parameters
Parameters	Format: [URL Parameter],[Request Field] Example: Text description;DOCAuthor,EmployeeID

Result: Clicking hyperlink opens document search with “Text” and “Created by” fields pre-populated from request data.

All the free fields are stored in the table GLMSysWflRequests

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