AI field

The AI field type allows you to add AI models directly within Baserow. The AI field can be used to generate creative briefs, summarize information, and more.

Overview

The AI field type is only available with the Premium plan or higher. The GPT-3.5 model is currently available for free with no usage limitations.

  • Baserow Cloud (baserow.io): Baserow cloud supports the GPT-3.5 model, available free of charge and without usage limitations.
  • Baserow Self-Hosted: You are required to add your OpenAI API key to use the AI field type. API keys are configured at the workspace or instance level.

Configure API keys

You can bring your own OpenAI API key to use a different model.

Configure API keys at instance level

If you are using Baserow self-hosted, you can configure API keys at the instance level via environment variables.

Configure API keys at workspace level

To configure the API keys at the workspace level, go to workspace settings → Generative AI Settings. These settings allow you to configure generative AI at the workspace level. The settings apply to all users in the workspace.

Tutorial on how to use the AI field

The AI field may be disabled if an API key for a supported model is missing. To activate these features, specify the settings here. The configuration at the global instance level will be used by default if you leave a value blank.

OpenAI

To configure OpenAI in the workspace, provide

  • an OpenAI API key to allow using OpenAI for the generative AI features like the AI field.
  • an OpenAI organization name that will be used when making an API connection (optional).
  • a comma-separated list of OpenAI models that you would like to enable (e.g. gpt-3.5-turbo,gpt-4-turbo-preview). Note that this only works if an OpenAI API key is set. If this variable is not provided, the user won’t be able to choose a model.

Ollama

To configure Ollama in the workspace, provide

  • an OLLAMA host to allow using OLLAMA for generative AI features like the AI field.
  • a comma-separated list of Ollama models that you would like to enable (e.g. llama2). Note that this only works if an Ollama host is set. If this variable is not provided, the user won’t be able to choose a model.

Create an AI field

To create an AI field in a table,

  1. Click + Add a field. Choose the AI field from the options.
  2. Select an AI type and model from the list.
  3. Click on the Prompt field in the context menu. A new window will appear with a list of fields in your table. As you type your prompt, select the fields you want to use for your result.
  4. Click the blue Create field button.

Each cell in the field will have a Generate button. Click the button where you want the AI to start generating prompts.

AI field type

File field support for the AI field

Baserow AI allows you to use various file formats directly within the AI field. You can connect your files to the AI model and instruct it on how to process the information for data classification, text generation, content summarization, information retrieval, and similar functionalities.

Baserow AI supports a wide range of file types, allowing you to work with documents, invoices, and various other formats. For a specific list of supported file types, please refer to Baserow’s documentation on the file field.

File field support for the AI field

To be considered a valid knowledge base, the file must be in one of the following text-based formats:

  • .txt (plain text)
  • .md (Markdown)
  • .pdf (Portable Document Format)
  • .docx (Microsoft Word Document)

To leverage Baserow’s AI file support to gain insights directly from your documents, invoices, and other file types:

  • Select AI type and model: Choose the desired AI type and model from the available options.
  • Connect a file field: In the File field section, connect with a file field containing the documents you want to analyze. The AI will use the first compatible file in your selected file field as the source for the prompt. Ensure this file is supported.
  • Define the prompt: Here, you can specify how you want the AI to process the connected file.
  • Create the AI Field: Click the Create field button to finalize the configuration.
  • Generate results: Each row within your table will now display a “Generate” button. Click this button on the specific row where you want the AI to initiate processing based on your defined prompt.

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.