GP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.
Here is a real-life example showing how you can quickly use Form Control to add formatting, validation and even Autocomplete to a field to ensure it is entered from a list of desired values.
In Microsoft Dynamics GP, many fields allow free text to be entered with no validation or formatting of the entered text to ensure it matches a desired list of expected values.
A business requirement could be for the Generic Description field on the Item Maintenance window to only allow entries from a specified list of values.
This requirement can be created with the Form Control module in a few minutes.
Adding Autocomplete to the Field
The FORM CONTROL ITEM GENERIC Form Control ID is limited by the Base Settings Resource Filter to exactly the IV_Item_Maintenance form in the core dictionary (0).
The Enable Autocomplete Field rule is limited to exactly the Item Generic Description field. Enabling Autocomplete on a field will automatically remember values entered into the field. However, you can also preload values, if desired.
The Expression field can contain a semicolon separated list of values to preload into the Autocomplete list for a field. Using the Ignore Case checkbox will populate the Autocomplete list with UPPERCASE, lowercase and Propercase values of the list.
Formatting the Field
The Format String Field Value rule is limited to exactly the Item Generic Description field.
The Expression field contains the format mask to be used, in this case forcing the characters to uppercase.
Validating the Field
The Validate Field Value rule is limited to exactly the Item Generic Description field.
The Expression field contains a semicolon separated list of validation rules. In this example we have one validation rule, that the field must be contained in the comma separate list provided.
Click the Info button to the right of the Expression field to display the help window shown above.
The screenshot above shows the AutoComplete values after typing a capital I.
Downloading and Installing
Download the example settings, import using the Project Setup window (without any project showing, select the path to the xml file and click Import):
The Form Controls will be active immediately when the affected windows are next opened.
More Information
For an introduction series for Form Control with step-by-step instructions see:
For more information see:
- GP Power Tools Portal: http://winthropdc.com/GPPT
- GP Power Tools Samples: http://winthropdc.com/GPPT/Samples
- GP Power Tools Videos: http://winthropdc.com/GPPT/Videos
Hope you find this example useful.
David
This article was originally posted on http://www.winthropdc.com/blog.