AI prompt field in Baserow

The AI prompt field lets you generate text, summaries, classifications, and insights directly in your Baserow tables using dynamic prompts that reference other fields. It supports multiple AI providers and can process documents (PDF, DOCX, TXT, MD) for automated analysis.

The AI prompt field is available on Premium plans and higher. Upgrade your subscription to access this feature.

Overview

The AI prompt field transforms your Baserow tables into intelligent automation engines. Reference data from other fields to create dynamic prompts, classify content, summarize documents, or generate creative text, all without leaving your database. Each cell includes a generate button that processes your prompt on demand.

How it works

AI prompt fields use large language models to process prompts you create. These prompts can reference other fields in your table, making responses contextual and dynamic. Configure the model, temperature, and output format, then click generate in any row to produce AI-powered results.

Common use cases:

  • Summarize customer feedback from long text fields
  • Classify support tickets by urgency or category
  • Generate product descriptions from specifications
  • Extract key information from uploaded documents
  • Create personalized email drafts based on customer data

AI prompt field configuration interface

Before you begin

Ensure AI is configured in your workspace:

  1. Check that generative AI is configured at workspace or instance level
  2. Verify your plan includes AI prompt field access (Premium or higher)
  3. Have your source data ready in other table fields

Create an AI prompt field

Basic setup

  1. Click + Add a field in your table
  2. Select AI prompt from the field type options
  3. Name your field (e.g., “Summary”, “Classification”, “Generated Description”)

Configure AI settings

Setting Purpose
AI type & model Choose provider (Baserow, OpenAI, Anthropic, etc.) and specific model. GPT-3.5 for speed, GPT-4 for quality
Temperature Control creativity (0-2). 0-0.3 for factual, 0.7-1.0 for creative
File field The first compatible file in the field
Output type Format the response. “Text” for open-ended, “Choices” for classification

Build your prompt

  1. Click the Prompt field in the configuration panel
  2. Write your instruction (e.g., “Summarize the following customer feedback:”)
  3. Reference other fields by selecting from the list
  4. Example prompt: Classify this review as Positive, Neutral, or Negative: {Fields > Income 2025}
  5. Click Create

Generate results

Each row now displays a Generate button in the AI prompt field. Click it to process the prompt using that row’s data. Results appear in the cell once generation completes.

AI prompt field with generate button

Use AI with file fields

Supported file formats

The AI prompt field can analyze text-based documents directly:

Format Extension Common Use
Plain text .txt Notes, logs, transcripts
Markdown .md Documentation, articles
PDF .pdf Invoices, reports, contracts
Word .docx Documents, proposals

Setup file analysis

  1. Create or identify a file field containing your documents
  2. In the AI prompt field configuration, connect to that file field
  3. Write a prompt that instructs processing (e.g., “Extract the invoice total and date from this document”)
  4. The AI uses the first compatible file in the row as context

Example workflow:

  • Upload invoice PDFs to a file field
  • Create AI prompt field with prompt: “Extract: Invoice Number, Date, Total Amount, Vendor Name”
  • Click generate to automatically extract structured data

File field support for AI analysis

Output types explained

Text output

Returns free-form AI-generated text. Best for summaries, descriptions, or creative content where responses vary widely.

Example: “Write a professional email response to this customer inquiry: {Support Ticket}”

Choices output

Constrains AI to select from predefined options. Ideal for classification, categorization, or structured responses.

Setup:

  1. Select “Choices” as output type
  2. Define your options (e.g., “Positive, Neutral, Negative”)
  3. Prompt: “Classify the sentiment: Fields > Review Text

The AI will return only one of your specified choices, ensuring consistent categorization.

Temperature settings guide

Temperature controls response randomness:

Range Behavior Best For
0 - 0.3 Focused, deterministic Factual summaries, data extraction, classification
0.4 - 0.6 Balanced General business writing, Q&A
0.7 - 1.0 Creative, varied Marketing copy, brainstorming, creative content
1.1 - 2.0 Highly experimental Rarely recommended; very unpredictable

Pro tip: Start at 0.5 and adjust based on results. Lower if responses are too random, raise if they’re too repetitive.

Practical examples

Example 1: Classify support tickets

Fields:

  • Ticket Description (long text)
  • Priority (AI prompt field)

AI configuration:

  • Output type: Choices (Low, Medium, High, Urgent)
  • Temperature: 0.2
  • Prompt: Classify the priority of this support request: {Ticket Description}

Example 2: Generate product descriptions

Fields:

  • Product Name (single line text)
  • Features (long text)
  • Marketing Description (AI prompt field)

AI configuration:

  • Output type: Text
  • Temperature: 0.8
  • Prompt: Write a compelling 50-word product description for {Product Name} with these features: {Features}

Example 3: Extract invoice data

Fields:

  • Invoice PDF (file field)
  • Extracted Data (AI prompt field)

AI configuration:

  • Connected file field: Invoice PDF
  • Temperature: 0.1
  • Prompt: Extract and format: Invoice Number, Date, Total Amount, Vendor Name

Frequently asked questions

What AI models can I use with AI prompt fields?

Available models depend on your generative AI configuration. Self-hosted users can configure OpenAI, Anthropic, Ollama, OpenRouter or Mistral models.

Do AI prompt fields update automatically when source fields change?

No. AI prompt fields generate on demand when you click the generate button. This prevents unnecessary API calls and gives you control over when processing occurs.

How much does it cost to use AI prompt fields?

Baserow Premium plans include AI prompt field usage. Monitor your usage through your provider’s dashboard.

Can I reference multiple fields in one prompt?

Yes. Reference unlimited fields and select from your table’s fields. Example: Compare {Fields > Product A} and {Fields > Product B} and explain which is better for {Fields > Use Case}.

What happens if file analysis fails?

Common causes include unsupported file formats, corrupted files, or files exceeding the model’s token limit. Ensure files are in supported formats (.txt, .md, .pdf, .docx) and under 10MB. Check error messages in the cell for specific guidance.

Can I bulk-generate results for multiple rows?

Currently, AI prompt fields require manual generation per row. For batch processing, click generate on each row sequentially, or use the Baserow API to automate generation via scripts.

Tutorials


Need help? Visit the Baserow community or contact support for assistance with your account.