This release is a big one! Many have requested the lookup field and webhooks, and today we’re happy to release both of these features. Easily add fields of other tables by adding a lookup field and receive HTTP notifications when a row has been created, updated or deleted via the webhooks. In addition to that, we’ve also added the Kanban view to help you organize and plan better. Apart from these big new features, you can also expect bug fixes, new templates and other small changes.
Lookup fields let you select a field in another table to display, use it to combine all the relevant fields you need into a single useful table. To starting using them, create a new field and choose the new lookup option, then select a link row field in the same table to lookup through and finally a target field in the linked table to get values for. Your lookup field will then contain the target field value for every linked row formatted into a list. Finally you can reference lookup fields directly in formulas and use the filter and aggregate formula functions to filter them down and sum them up.
Receive notifications when a row has been created, updated or deleted via the webhooks. You can create them by clicking on the three dots next to the table or the view and then on webhooks. Here you can choose an HTTP method, URL, trigger events, additional headers and see an example payload. You can even trigger a test to make sure everything works before saving it. We have also added a call log, where you can see the latest requests and responses, which is super useful when debugging.
Organize and plan better using the Kanban view! Easily workspace rows by the select options of a single select field. You can drag and drop the cards into different stacks and choose which fields you would like to show in the cards. Create a Kanban view by clicking on the view icon in the top left corner and then clicking on the create button.
We’ve been silently working on our premium version. This release also brings a licensing system that allows us to give early access to those features, to the hosted and self hosted versions. At the moment, we offer the following premium features:
We’re giving away early access to our GitHub sponsors! We’ll be reaching out to you shortly if you’re already a sponsor, feel free to reach out to us if you can’t wait. If you’re not a sponsor and you want to gain access to the early premium version, then become one here https://github.com/sponsors/bram2w. It would be much appreciated!
Baserow’s Formula language has levelled up significantly and is now industry leading with its incredibly powerful, easy to understand and blazing fast calculations:
lookup
and filter
functions let you lookup other tables values directly inside of formulas and filter them down.sum
,avg
,join
,every
,any
,stddev_pop
and more!) summarize lists of values from lookups and link row fields.’Username = ’ + lower(field(’name lookup’))
sum(filter(field(’numbers’) / 100, field(’numbers’) < 100))
filter(lookup(’customers’, ’name’), lookup(’customers’, ’age’) > 18)
any(field(’customers’, ’name’) = field(’clients’, ’name’))
All the changes of version 1.7 listed.
Baserow version 1.20 comes with email notifications, workspace level audit log, search for calendar view, new shortcuts, context menu improvements, and more.