Use the Categorize AI task in an automation

Setting

Description

Task type

Select AI task.

Table

Table defined in the event and used by the task. See Tables: The Essentials for more information about tables.

AI task 

Input columns

Add one or more columns to use as input to the AI task, up to a maximum of 10. Click Add and select a column from the drop-down.

Basic column data types and virtual columns are supported. 

The following data types are not supported:

• Content types: Drawing, File, Image, Signature, Thumbnail, and Video
• Color 
• Show types
• Other types: URL, App

Note: List columns are not supported at this time. 

Output

Select one of the following:

• Save to table to save the extracted information to the table in your data source.
• Return value to guide AI responses without storing the results in your data source. Use the returned values in later steps, as follows: [AI-step].[column]

For best practices when saving content, see Manage updates to row data by multiple bots.

Then, select the column that defines the allowed category values. Must be an Enum or Ref column. 

Note: If you select a Ref column, it only works with existing values and there must be at least one row. AppSheet won't create a new entry in the referenced table. 

For example, you might have a column called How expensive? that is an Enum column with the following values: Inexpensive, Moderately expensive, Expensive,Other

Additional instructions

Supports up to 1000 characters. 

For example:

Inexpensive: Less than 10 dollars
Moderately expensive: Between 10 and 50 dollars
Expensive: Over 50 dollars
Other: Not sure of value

Note: Specifying a value that is not defined in the Enum or Ref column selected for the Output setting may cause unexpected behavior unless you allow other values when configuring the Enum column properties.