Permit Mover for Staff Web Site

The SQL Permit Mover tool has been added to the Staff Web site. You can get to it by going to Maintenance and then the System section. The Permit Mover is part of the ZP Toolbox options in the Windows version of ZonePro SQL. It allows you to move a permit from one property to another which is useful if the permit was accidentally entered under the wrong address. I think the web version is even easier to use than the Windows version because it only presents you with drop-down boxes so there is no typing, and it gives better feedback on the chosen permit and the chosen property so that you can be sure you are making the right choices.

Expanding Source Field in Reports

There are a number of report screens in ZonePro SQL that include a Source field as part of their output (such as the Activity Report Screen). This field is a two character abbreviation of the database that the record is pulled from. Several customers have asked if their is an easy way to make this field more readable on reports by expanding "BD" to "Building Permit", for example. This can be done by using a function that evaluates the field value and outputs the alternative text. Substitute the function below for the expression in any report that prints the "Source" field. You can trim the expression down to include only those databases that matter to you. You can also edit the second argument in each pairing to read the way you want it to.

ICASE(source="ZN","Zoning Permits",source="VL","Violations",source="AP","Appeals",source="AM","Amendments",source="OT","Other Permits",source="EX","Extra Permits",source="PN","Planning",source="BD","Building",source="EL","Electrical,source="PL","Pumbing",source="MC","Mechanical",source="PJ","Project",source="RE","Rental",source="HS","Housing,source="PS","Pre-Sale",source)