Tools
The following tools are available to use in the interface. Largely you shouldn't have to specify you want to use a tool, the Ai should just naturally use it itself; but knowing that they're there, and what they're called, is helpful - as this allows you to "brute force" the Ai sometimes into doing what you want.
Tool
Query Data
The foundation of the system is the ability for the Ai to use the AppSheet API to query data from your app.
Description
The following text is what is provided as the description of this tool to the ai:
Retrieves records from the database; you provide the table name, and criteria, and we'll send a FILTER(TABLE_NAME, criteria) query to the AppSheet app for records - returning their results.
> Note: Only call this if you don't have the data; if you previously called this function, and the results have already been presented, use that to answer any question. (Rely on the data presented in context, over querying new data.)
> - This is an asynchronous function, there is a delay between your call and the return; take care not to call this repeatedly in rapid succession.
How To Use
To use this tool, simply ask the assistant for data from your app:
-
You could specify the individual table/slice
-
You can speak out the query you want the Ai to run, in natural language
-
You could ask, in plain language, for something
The Ai is given your table schema at the start of the conversation, so it's aware of how things are structured and put together; this allows you to speak naturally, and the Ai infers your intent - building together the necessary query and sending that off.
Tool
Add/Edit Records
This tool uses the AppSheet API to add or edit records in the selected app.
Description
The following text is what is provided as the description of this tool to the ai:
Add new records to, or edit records already present in, the specified table with the AppSheet API.
How To Use
To use this tool, simply tell the assistant you want to make a new record or edit one:
-
It might ask for more information, in order to fill in the fields
-
If it has everything it needs, it presents those details in a table-view
-
You can change any of these values before sending
All data changes must be confirmed before anything is actually sent off.
Tool
QuickChart.io Charts & Diagrams
This tool uses QuickChart.io to build visualizations on the fly.
Description
The following text is what is provided as the description of this tool to the ai:
Call this tool when you need to display something in chart form. This uses QuickChart.io as the charting service, you need to return the URL for the chart. Take care to include all opening/closing brackets and everything. Syntax errors will cause the chart to fail, so double check that all curly brackets, parenthesis, square brackets, commas, etc. are where they need to be, nothing is missing, there are no extras, etc.
How To Use
To use this tool, simply ask the assistant for a chart, diagram, or visualization of some kind.
Just about every kind of chart or diagram is possible, just ask!
-
Though it might run into syntax issues every now and then.
Examples
Tool
Web Search (shallow)
This tool uses the Google Search JSON API to perform a google search.
Description
The following text is what is provided as the description of this tool to the ai:
Search the internet for information; this will return the top 10 search results, with their URLs and snippet text. You can selectively send the search results through a LLM for refinement before returning, to extract data into JSON, find the best result, analyze or prepare the data in some way ahead of time; if you wish to do so, you need to also include the specific instructions for the LLM to use.
How To Use
To use this tool, simply ask the assistant to "search the web" for something
-
It will perform a quick search
-
Depending on the situation, it might further refine the results by passing them to a LLM for post processing
-
The assistant will provide the instructions to use, you don't need to worry about this
-
Though if you wanted to influence what it's doing, you could provide advice and guidance.
-
-
The results are then returned to the assistant, where it will then relay the information to you.
