
HaloITSM Guides
Documentation to assist with the setup and configuration of the HaloITSM platform
Database Lookup Guide
- Head in to Configuration>Integrations and enable ‘Database Lookups’ by clicking on the X in the corner when hovering over the icon. Now click in to the module and create ‘New’.
- Create a name for your lookup, and select the Use:
3. In the trigger fields section, this will be the field which you want to trigger the automation of your other chosen fields, so for this example will be Email Address and this field will be required for the lookup, and the 'Active' checkbox should be checked:
4. The next step will be to set up your connection. You can connect directly to your own Halo database by selecting the following:
This can also be used to connect to external databases. If you choose this option it will look something like this:
5. After this, you will create the script which performs the lookup based on the trigger field you have chosen. Where email address matches X, it will select First Name and Last Name related to that email address within your database:
6. You now need to map the lookup fields which will be populated when the email address is entered, in this case First Name and Last Name:
Hit save. Now you have finished creating your lookup code!
Now, when an email address is entered to a form, where first and last name fields exist, they will automatically populate:
Popular Guides
- Asset Import - CSV/XLS/Spreadsheet Method
- Call Management in Halo
- Creating Agents and Editing Agent Details
- Departments, Teams and Roles
- Importing Data
- Multiple New Portals with different branding for one customer [Hosted]
- Organisation Basics
- Organising Teams of Agents
- Step-by-Step Configuration Walk Through
- Suppliers
- Syncing Exchange Calendars