In the last few weeks, our development team has been working hard to bring you a number of highly requested brand-new functionalities. Today we are pleased to provide you with an extensive overview of which new features were added to Baserow 1.15, including personal views, new formula functions, timezone changes, and much more. Keep on reading to go dive into all the new and improved in Baserow!
In Baserow, all dates are stored in the UTC timezone by default. You can now select a timezone for your date fields. In addition to this, you can optionally see the dates in your local timezone. If you want to switch from one timezone to another, Baserow will do an automatic conversion in a few seconds. You can optionally choose if you wish to show the timezone.
We are introducing the
today() function, which returns the current date, and the
now() function — which returns the current date AND time.
today() function is useful when you need to have the current date displayed in a table. It is also useful for calculating intervals.
now() function is useful when you need to display the current date and time on your table or calculate a value based on the current date and time, and have that value updated each time you open your database.
Both functions update every 10 minutes and allow you to build more powerful formulas around dates in Baserow.
Personal view is a new feature that allows you to create your own personal views, separate from shared “collaborative” view.
When creating a new view, you can now choose between collaborative and personal view types:
Personal views are extremely useful to play around with filtering or sorting a table’s data — this way you don’t need to worry about affecting the configurations of your teammates. For example, you could create a personal view with filters to only show your tasks with the highest priority that are assigned to you.
Personal views are currently available in Premium, Advanced, and Enterprise plans.
The file importer now can import to link row, single and multiple select columns and automatically set them up with links or options for you.
This is also available via the API, so now you can create and update rows with link row, single and multiple select text values instead of having to provide the internal ids.
Previously when creating a row with a link row field, you could only ever provide the numerical IDs of the rows you want to link to, for example
[1,2,3,4]. Now, you can provide the values of the target row’s primary field, for example
["name of row 1", "name of row 2", "name of row 3", "name of row 4"]. This also works for single select and multiple select fields.
This makes building integrations with Baserow much easier, as you no longer need to do filtering and lookups to figure out the row’s ID or select option ID.
We added new templates and improved existing ones. On the Templates page, you can find the most recent updates.
First, we want to say a HUGE thank you to everyone who participated in the first community contest “Made With Baserow”.We received a lot of great submissions, all of which showcased unique and creative ways people are using Baserow. Make sure to check them out, as well as congratulate the winners here.
Mark your calendars and join us for the AMA about workflow automation on the 9th of March!
Our invited expert, Troy Tessalone of Automation Ace, Certified Zapier expert and the #1 Zapier Community contributor will be answering your questions on all things workflow automation as well as sharing his tips and tricks for creating powerful workflows.
Get all the details here.
We want to acknowledge Christian Knell who built the Baserow Helm Chart so that you can bootstrap your own instance of Baserow on a Kubernetes cluster in seconds.
Thanks to Riadh Habbachi for fixing a bug with
backend-test-group-1 split group condition.
We also appreciate Shohan Dutta Roy, who contributed a feature to add filter type ‘Contains word’.
→ Troy Tessalone contributed a blog post on Top 5 Database Automation Mistakes — and How to Avoid Them.
→ Kim-David Nguyen shared a quick guide on how to deploy Baserow on AWS.
→ SwitchUpCB prepared a detailed tutorial on how to set up Baserow with SSL.
→ Marius updated his guide on how to Install Baserow on your Synology NAS (now with the power of the Portainer stack).
Big thank you to everyone who helps us to prepare educational content about Baserow 💙
permanently_empty_database, which will empty a database of all its tables.
procpssystem package to all-in-one docker image fixing
docker-composeand an HTTPS URL in
BASEROW_CADDY_ADDRESSESfiles caused by an incorrect Caddy healthcheck.
'some text' + null = 'some text'instead of previously resulting in ‘null’ for example. Check out this community post for more information.
The next big features in the roadmap are condition groups (advanced filtering combining AND & OR) plus calendar and timeline views. In addition, we will continue working on features suggested by the community and fixing bugs.
Do you have questions regarding the new updates? Or anything else? Leave your questions in our official community forum — we’re always happy to answer them!
Today we are releasing Baserow 1.15 with personal views, today() and now() formula functions, timezone support, and much more.
Want to write a post in collaboration with us?How to contribute?