Feature Spotlight: Zoom In/Out Enhancement
To allow for greater control over the zooming on forms in Virtual Ticket, a new zoom percentage popup button has replaced the + and - magnifying icons in the Virtual Ticket browser window. Now users can choose the zoom percentage they would prefer from 50% to 400%.
Q&A with Technical Support: Sorting a Static List via MetaScript
How can I execute a MetaScript when certain fields are edited?
By using a Regular Expression in MetaScript, you can watch a field or group of fields and trigger the execution of a specific script when a specific field has been edited. For example, suppose you have series of fields whose names contain '30Days' and '60Days' and you only want MetaScript to update a last edited date field when one of the '30Days' fields are edited but should not execute when the '60Days' fields are edited. This task can be accomplished by setting up a loop with a regular expression that looks for '30Days'. Knowledge Base article 16358 contains an example script for this scenario.
For more information visit:
http://developer.metacommunications.com/kb/16358
Smart Tip of the Month: Removing Text Via MetaScript
You may have a scenario where you would like to display some information already contained in a field but is included with other information you do not want to display. For example, suppose you would like to display the name of the sales rep on a Quote Print form you send your customers. The Sales Rep name information is contained in the Employee_2_Name field in the Estimates-Quotes folder type but the field also includes the employee number information in the following format [10] Joe Smith. Using the MetaScript String Split function, you can drop the employee number information by identifying a character ( ] ) which it will be easy to split the value into two different items. Then you can choose to display the information after the splitting character. Knowledge Base Article 16357 provides an example for solving this scenario.
For more information visit:
http://developer.metacommunications.com/kb/16357
Additional Resources: SQL Query Examples
Earlier in this edition, we discussed enhanced functionality to the Custom Query capabilities of Workgroups. The following web site provides a cheat sheet of common SQL queries including: locating items that are in one table but not another, doing aggregates, inserting information, updating information, and much more.
For more information visit:
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=27
Knowledge Builder
New articles this month
16357 - Removing Text Via MetaScript
This article provides an example of using the MetaScript function String().Split which can be used to split a text string into multiple parts based on an identifier.
http://developer.metacommunications.com/kb/16357
16358 - Executing MetaScripts Based on Field Naming Conventions
This article provides an example of how to execute a MetaScript when changes are made to fields named according to a naming convention.
http://developer.metacommunications.com/kb/16358
16359 - Error When Editing a SQL Server Maintenance Plan
This article describes a problem that can occur when attempting to modify an existing SQL Server 2005 Maintenance Plan.
http://developer.metacommunications.com/kb/16359
16360 - Open Workgroups Portal Links in a New Tab or New Window
This article describes a feature which allows for the user to easily open links in Workgroups Portal in new tabs or new windows.
http://developer.metacommunications.com/kb/16360
Have an idea or topic you would like covered in the MetaCommunications Support News? Send your ideas, topics and comments to:
support@meta-comm.com