Generate formulas with AI in Baserow

Using AI can save significant time previously spent crafting formulas manually. This section details how to use Baserow’s AI capabilities to automate formula creation directly within your Baserow workspace.

Baserow AI features are available to those on the Premium plan or higher.

Generate formula with AI baserow

Overview

The AI-powered formula generator simplifies the process of creating formulas by understanding your desired outcome in plain English. This helps with tasks like:

  • Managing project progress and deadlines
  • Calculating costs and budgets
  • Creating complex formulas based on date and time values

Baserow Cloud supports the GPT-3.5 model, which is freely available without usage restrictions. For Baserow Self-Hosted or those wishing to use a different model, use this guide on configuring the OpenAI API key.

Using the AI formula generator

  1. Create a formula field: In your table, add a new field and select the “Formula” field type.
  2. Generate formula using AI: Within the formula editor, locate the “Generate using AI” option. Click on this button to open a dedicated modal window.
  3. Choose an AI model: We suggest using high-parameter models like GPT-4 or llama3-70b for optimal performance.
  4. Describe your desired action: In the modal window, write a clear and concise prompt describing the action you want the formula to perform. Be as specific as possible to ensure accurate results.
  5. Generate formula: Once your prompt is ready, click the “Generate” button. Baserow will process your request and display a formula within a few seconds.
  6. Review and create: Carefully review the generated formula. If it meets your needs, click the “Create” button to finalize and implement the formula in your workspace.

Related content

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.