Baserow 1.8: Gallery View, Rating field, view sharing, more

Happy new year! Here is our first Baserow release of 2022! The key features are the Gallery view, which allows you to view your data as cards with an optional cover image; Public view sharing, which enables you to share grid views via a link; the Rating field, which provides an easy way to store and set ratings; Interface translation to French; User file previews in your browser. Additionally, there are some significant performance optimizations for large tables, making tables with 100+ fields usable.

Public view sharing

Baserow tables can now be shared publicly via a link, allowing users to view, sort, filter, and search a grid view. To do so, click the new Share view button found at the top of a grid view. Publicly shared views do not display filtered out rows and hidden fields, ensuring the security of your data. Viewers can apply their own temporary personal filters, sorts, and searches. Furthermore, publicly shared grid views receive real-time updates, just like normal grid views, so any viewers will see changes in real time.

Gallery view

With the Gallery View, you can view your rows as individual cards spread across the page, rather than in rows. Your cards can have an optional cover image shown by selecting a file field as the cover field under Customize cards .

Internationalization

Over the past few months, we’ve been gradually making it possible to translate Baserow into different languages. This process is now complete, and we’ve added French as the first available translation. More languages will be available soon. After signing in, you can click on the top left corner to open your account settings, where you can change the interface language.

Rating field

Quickly store and view ratings with the new Rating field. They can be configured to have different styles, colors, and maximum scores. Additionally, rating fields can be referenced in formulas, where they are converted into their numeric representation, allowing for more complex calculations such as calculating an average rating.

User file previews

Video, audio, PDF, and certain types of Office files stored in a Baserow file field can now be previewed directly in your browser, without the need to download and update them. Furthermore, PDFs and various office files can be previewed and shared directly with Google Docs. Simply click on a file field’s cell to see previews for any contained files.

Manual release step for self-hosters

In this release, there is an optional one-off manual step for self-hosters. If you have existing uploaded images that you wish to use as cover images in a Gallery or Kanban view, please upgrade to version 1.8 and then follow the instructions for your deployment type below.

Ubuntu

$ cd /baserow
$ source env/bin/activate
$ export DJANGO_SETTINGS_MODULE='baserow.config.settings.base'
$ export DATABASE_PASSWORD='yourpassword'
$ export DATABASE_HOST='localhost'
$ baserow regenerate_user_file_thumbnails card_cover

Docker-compose

docker-compose exec backend /bin/bash /baserow/backend/docker/docker-entrypoint.sh manage regenerate_user_file_thumbnails card_cover

Heroku

You need to sign into Heroku and select your Baserow app. Click on the more button at the top right corner, click on run command and then you can execute the command above directly.

DJANGO_SETTINGS_MODULE='heroku.settings' /baserow/env/bin/python /baserow/baserow/backend/src/baserow/manage.py regenerate_user_file_thumbnails card_cover

Cloudron

By logging into your Cloudron environment, you can access to the terminal of your Baserow app. There you can enter the following command to regenerate the thumbnails:

/app/code/env/bin/python /app/code/baserow/backend/src/baserow/manage.py regenerate_user_file_thumbnails card_cover --settings=cloudron.settings

All changes

All the changes of version 1.8 listed.

• Added Video, Audio, PDF and some Office file preview.
• Added rating field type.
• Added gallery view.
• Added internationalization and French translations.
• Added ability to share grid views publicly.
• Fix deleted options that appear in the command line JSON file export.
• Fix subtracting date intervals from dates in formulas in some situations not working.
• Added day of month filter to date field.
• Added length is lower than filter.
• dev.sh users Fixed bug in dev.sh where UID/GID were not being set correctly, please rebuild any dev images you are using.
• Replaced the table order index with an order, id index to improve performance.
• breaking change The API endpoint to rotate a form views slug has been moved to /database/views/${viewId}/rotate-slug/.
• Increased maximum length of application name to 160 characters.
• Fixed copying/pasting for date field.
• Allow changing the text of the submit button in the form view.
• Fixed reordering of single select options when initially creating the field.
• Improved performance by not rendering cells that are out of the view port.
• Fix bug where field options in rare situations could have been duplicated.
• Focused the search field when opening the modal to link a table row.
• Fixed order of fields in form preview.
• Fix the ability to make filters and sorts on invalid formula and lookup fields.
• Fixed bug preventing trash cleanup job from running after a lookup field was converted to another field type.
• Added cover field to the Kanban view.
• Fixed bug where not all rows were displayed on large screens.
• New templates:
  • Car Maintenance Log
  • Teacher Lesson Plans
  • Business Conference Event
  • Restaurant Management
• Updated templates:
  • Healthcare Facility Management
  • Apartment Hunt
  • Recipe Book
  • Commercial Property Management