Skip to main content

Assistant Copilots

Some pages in Informer have AI Copilots with specialized knowledge and capabilities, marked by a distinct icon. The type of Copilot changes depending on where you are in the system, helping with the task at hand.

The Copilot icon that appears on pages with a specialized AI helper
The Assistant Copilot icon.

In Informer GO, this assistance is the Copilot.

Native SQL Editor​

The Native SQL Copilot helps you create, repair, and modify SQL when editing a Native SQL Dataset or Ad hoc Query. It is pre-loaded with metadata from the Datasource. It generates syntactically valid SQL that you should verify for correctness. For example:

  • "Show orders and include product name and quantity"
  • "Add in the total order amount based on unit price"
  • "Join to Employee information and add the salesperson name"

Calculated Fields Flow Step​

When editing a Calculated Field Flow Step, this Copilot helps write, update, fix, and explain the calculated script. For example:

  • "Write this for me"
  • "How does this work?"
  • "Add comments to the script"

Power Script Flow Step​

When editing a Power Script Flow Step, this Copilot helps compose a script and is aware of the special functions and variables available to a Power Script. For example:

  • "Remove records that do not have a region"
  • "Add a clickable link to Google Maps using the full address"
  • "Add a field that shows Domestic if it is in the USA, or blank if not"

Template​

When editing a Template Report, this Copilot helps write HTML and CSS and draft content. For example:

  • "Write a welcome letter to students and use variables for their name and address"
  • "Fix the HTML so it doesn't have so many inline styles"
  • "Make a table with the columns Product, Quantity, and Amount, with Quantity and Amount right-aligned"

Dataset​

When viewing a Dataset, this Copilot answers questions about that specific Dataset, primed with information about it. For example:

  • "How many records are there?"
  • "What's the average number of days to ship?"
  • "Who is my top salesperson based on order amount?"
Also available through the REST API
Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Assistant API.