Ticket Categories

In this guide we will cover: – What are Ticket Categories? – Making Ticket Categories – Setting Ticket Categories from an Action – Restricting Ticket Categories – Reporting on Categories – Rules Based on Ticket Category – Field Visibility Admin Guides: Categorisation Related Guides: Actions Billing Rules (Formerly Billing Plan Combinations)  Customer, Site and User […]

Site Address Lookup Custom Field

This custom field provides a dropdown of the site addresses for a customer select distinctssitenum as [ID],concat(sdesc,' ',Asline1,' ',Asline2,' ',ASLine3,' ',ASLine4,' ',Asline5) as [Display]from Siteleft join area on sarea=aarealeft join tree on treeid=atreeidleft Join AddressStore on AddressStore.assiteid = ssitenumwhere isnull(sisinactive,0)<>1and isnull(AIsInactive,0)<>1and isnull(ASInActive,0)<>1and sarea = (select aarea from users left join site on usite = ssitenum left join area on sarea = aarea where uid = $userid)

Dynamic Field/Value Visibility

In this guide we will cover: – What Is Dynamic Field Visibility? – Configuring Dynamic Field Visibility  – What Is Dynamic Field Value Visibility? – Configuring Dynamic Field Value Visibility What Is Dynamic Field Visibility? Dynamic field visibility is the process of making the visibility of a whole field dependant on the value of another […]

Ticket Types (Field Lists)

In this guide we will cover: – What is a Ticket Field? – Modifying Fields – Organise Fields into Pages on the Portal – Adding Signature Fields to Ticket Types Admin Guides: Ticket Types Related Guides: Custom Fields Altering Ticket Types What is a Ticket Field? A Ticket Field is a section on a Ticket […]

Dynamic Custom Fields

In this guide we will cover: – Creating Dynamic Fields using a SQL Lookup  – Worked Example -SQL – Using Variables in Dynamic SQL Lookup Queries – Formatting as a Tree Dropdown – Default to the First Returned Value – Creating Dynamic Fields using a Custom Integration Method Custom fields of type "Single Selection" or […]

$-Variables (Dollar Sign Variables)

In this guide we will cover: – What Variables can be Used – PDF Variables – Using Variables in Custom Fields – Formatting Variables – Variable Suggestions (v2.228+) Note: Any variable written in this guide is written with a hyphen between the $ sign and the word. This is so there is no replacement of […]

Restricting Field Access & Visibility

In this guide we will cover: – Restricting Field Access on a Ticket Type Restricting Field Access on a Ticket Type Restricting certain roles from being able to access particular fields on a ticket type is done within the ticket type level. Go into Configuration > Tickets > Ticket Type and enter the edit mode, […]

Database Lookup Example – Attaching the User’s Role to a Ticket.

In this guide we will cover:  – How to attach a user's role to a ticket using a database lookup One of the great features within Halo is the ability to populate fields on i.e. a ticket with information found in the database. This data is found using SQL queries which will return the information […]

Dynamic SQL Lookup Fields – Customer Specific Lookup

In this guide we will cover: – How to complete custom specific lookups for dynamic fields If you are looking to create customer specific lookups (such as a lookup of a customer’s sites) you can use the $-userid field in the dynamic SQL query. If you structure the query in a certain way this will […]

Lookups

In this guide we will cover: – What is a lookup? – How to create a lookup – Worked Example – Filtering results with variables What are Lookups? Lookups use SQL scripts to populate fields with information that already exists in your database. For example you could have user's contact details fields populate automatically on […]