Baserow 1.24: AI field, new filters, styling, and more
April 11, 2024
âą
Bram Wiepjes
Weâre introducing AI to supercharge your productivity. It all starts with the new AI field type, which allows you to use generative AI capabilities directly within your Baserow Database tables.
Additionally, there are tons of new features and improvements to both Baserow Database and Application Builder modules.
Hereâs whatâs new:
AI field type
The first version of Baserow AI introduces the AI field type, which allows you to add AI models directly within Baserow. The AI field can be used to generate creative briefs, summarize information, and more. This is just the beginning, with many more AI-based features to come.
To create an AI field, click â+ Add a fieldâ. Choose âAI fieldâ from the options. Then, select an AI type and model from the list. Next, 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. Finally, click the blue âCreate fieldâ button. Each line in the table will have a âGenerateâ button. Click the button where you want the AI to start generating prompts.
The AI field type is only available for those who are on the Premium plan or higher.
Cloud version (baserow.io): the hosted version supports the GPT-3.5 model, available free of charge and without usage limitations. However, we plan to introduce a usage-based model in the future. You also have the option to bring your own OpenAI API key to use a different model. To configure the API keys, go to âWorkspace Settingsâ â âGenerative AI Settingsâ. Please note that these settings are configured at the workspace level and apply to everyone in the workspace.
Self-Hosted version: you are required to add your own OpenAI API key to use the AI field type. API keys are configured at the workspace or instance level, the latter can be done via environment variables.
Check out this video walkthrough to see how to configure OpenAI API keys.
New styling and format support for the long text field
Baserow now supports hyperlinks and @-mentions within the long text field type.
Hyperlinks: Highlight the text you want to link, then click the ââŸâ icon in the formatting toolbar. A dialog box will appear for you to input the URL. Once confirmed, your text will transform into a clickable link.
Mentions: Type @ followed by a collaboratorâs name to send them a notification.
Co-branding for Enterprise
Baserow now provides a co-branding option for Enterprise plan users. This feature allows you to upload your logo and tailor Baserowâs appearance to align with your companyâs brand. The Baserow logo will be updated with a custom one across all locations where it is currently displayed.
To upload a custom logo, navigate to the âAdminâ tab and select the âSettingsâ tab. This will open the âAdmin settingsâ page. Scroll to the end of the page to find the âBrandingâ section, and look for âLogoâ category. Here, you can replace the Baserow logo with your custom alternative. Note that the image must match the dimensions listed.
Paste a single value into all selected cells
If you copy a single cell and select five cells to paste the data into, the content will be replicated in all five cells.
Visibility tab for the Application Builder
You now can set the visibility of each element in your application according to a userâs authentication status. To achieve this, select an element, then navigate to the âVisibilityâ tab on the right side panel. Here, you can choose who can see this element:
All visitors
Logged-in visitors
Logged-out visitors
You have the option to set different visibility levels for each element in your application.
After-login event for the Application Builder
You can now trigger an action for the login element. After creating the log-in element, click on it and navigate to the âEventsâ tab on the right side panel. Here, you can select an event for the âAfter loginâ action, such as:
Show Notification
Open Page
Logout
Create Row
Update Row
You can also configure multiple actions for one login element.
Logout action for the Application Builder
If your application includes a login feature, you can now also add a logout action. This can be set up as a button element, with the âOn clickâ event configured to trigger a âLogoutâ.
Keyboard shortcuts for the Application Builder
Now, you can navigate and build with Baserowâs Application Builder using only your keyboard. Utilize these shortcuts for swift actions:
Delete/Suppr key to remove an element.
DÂ key to duplicate the selected element.
Up/Down/Left/Right keys to select another element
Ctrl + Up/Down/Left/Right keys to move the selected element
PÂ key to select a parent element.
CÂ key to select the first child of the currently selected container element
PostgreSQL 15 upgrade in the Docker image
The all-in-one Docker image (baserow/baserow:1.24.0), now contains PostgreSQL 15 embedded. If youâre adding the DATABASE_* environment variables, then nothing changes for you, but if you donât, then youâre using the embedded PostgreSQL database. Because this is an upgrade from version 11 to 15, you need to run a manual step to update your data. Weâve made it as easy as possible for you. All information about the upgrade can be found here https://baserow.io/docs/installation%2Finstall-with-docker#upgrade-process.
We recommend backing up your data volume before attempting the data upgrade.
Other new features and updates
Clickable links in email notifications.
Support for â&&â and â||â operator symbols in the formula field type.
New filters: greater than or equal (>=), less than or equal (<=), is any of, and is none of.
Option to select all values of a multi-valued property in the Application Builder.
Ability to use values from previous actions to configure subsequent ones in the Application Builder.
Company news
Global Industries event
In March, we attended the Global Industrie conference in Paris. It was a big event where we caught up with some of our users and also met with various new businesses shaping the industry.
A big thank you to everyone who joined the challenge. Even though the event is over, the building never ends. Continue to make the apps youâve always dreamed of and help make the world a more productive place with Baserow.
Community tutorials and events
Check out this step-by-step video guide to install Baserow effortlessly on Docker from BigBearTechWorld.
Discover how to transform Shopify Marketing Data into Insights with n8n & Baserow by Sascha.
Check out how to do report automation with Make, ChatGPT, and Baserow from our ambassador, AJ.
Discover how to automate audio-to-text transcriptions using Baserow from our ambassador, AJ.
[Portuguese] Learn how to use Baserow with Typebot. By myzapbots.
The next big features on the roadmap include the two-factor authentication, templates for the Application Builder, a timeline view, and other features suggested by the community.
If you have any questions about the new updates, please leave them in our official community forum. Weâre happy to answer them!
All changes, including bug fixes
New features
Make links in the URL field type clickable in the row edit modal. #1072
Display unavailable advanced/enterprise roles even if the user isnât on one of these plans #1313
Made email notifications clickable and link to related row. #1881
Introduce âgreater than or equal toâ and âlower than or equal toâ filter types for number fields #1988
Add support for user mentions in the rich text field. #2041
Introduced is any of and is none of filters. #2102
Add keyboard shortcuts to interact with Application Builder elements: c (select child), p (select parent), arrow keys (select elements), arrow keys + alt/option (move elements). #2198
Add a new data provider that allows to use values from previous actions in formulas #2224
For Grid view, show field name on hover if it doesnât fit in the field width #2236
Made the application request serializers polymorphic.
Breaking change: when an application is created or updated via the API with an invalid type we will now return an ERROR_APPLICATION_TYPE_DOES_NOT_EXIST error code, rather than ERROR_REQUEST_BODY_VALIDATION.