We are super excited to release today, Rowy's next big version. This release has over 100+ amazing new features, enhancements and fixes that our team and a large group of open-source contributors have been working over the last one year in develop branch.
With this release Rowy's open-source project and Rowy.app cloud version - our goal is to bring to you the most powerful, advanced yet easy, intuitive and flexible way to to manage your database on a collaboration spreadsheet / CMS UI - especially for Firestore and Google Cloud/Firebase stack.
Before diving into the release notes, we invite you to celebrate with us as Rowy's open-source project crosses the milestone of 5,000 stars! 🌟🥳 We will give your project built with Rowy a shoutout in our social channels if you tweet at us @rowyio and say what you built.
- [New] Multiple filters support - finally! Filter using multiple fields and navigate your data better.
- [New] Support for bulk deletion of rows by @il3ven in https://github.com/rowyio/rowy/pull/1291
- [New]: Workspaces with multiple project support in Rowy.app. Connect to different Firebase projects - dev/testing/prod or from different ideas/clients - to manage them efficiently with a single unified dashboard.
- [New] Rowy.app: User management and in app table rules generator. Table level admin perms. Set which roles can view, create, update and delete data on your tables. You can also add table level admin permissions.
- [New] "Filter by" option to filter by the value of the cell
For complete changelog, see our release notes on Github.
We added an ability to click on an option and edit its value from the single and multi-select modal
You can now import packages using the "import" method, in addition to the previously supported "require" method.
Get a URL that represents the current filtered view of a table. Useful to share with colleagues, bookmark for self, or link from other tables as a way to show foreign key data.
We’ve added the capability to select colors based on starting, mid and ending percentage. The color for the range in between will be automatically calculated.
Simply right-click the context menu and choose the "filter-by" option to filter a table by a specific value. This will instantly apply a filter to the table, utilizing the selected column and the field cell value across all field types.
We have introduced a sort button that allows you to instantly identify whether a column is sorted or not.
Select desired column, sort direction (ascending or descending), and remove any existing sorts → all within your column configuration.
Airtable sometimes makes it hard to use images and file URLs in your apps. It also lacks a strong content delivery network (CDN) to quickly distribute your files globally. Also, the attachment images/files URL expire.
One solution is to move your data from Airtable to Rowy. This will automatically import and upload all of your files and images to Firebase's storage. Firebase provides a powerful backend platform to manage your assets and, with Rowy's table UI, you can manage them effortlessly in a no-code environment.
New import wizard helps you import data any number of times with insert / search-update. This means you can import and reimport data from CSV, JSON, or Airtable without getting duplicate rows.
To do this, make sure you match by a unique ID field when importing. If you select columns as unique row identifiers during import, then the import ensures that it updates existing rows if it can find one or add new rows only if the existing row is not found. This is useful when you need to make bulk updates or reimport data.
Give your data life with colors. Pick a color for options in the single-select and multi-select fields.
You can now export large tables to CSV files with ease. The exported file gets stored in your own Firebase Storage and the link to download it from the Rowy UI expires after 1 day. This ensures your data is secure and stays in your own cloud project.
Large export is a Rowy Pro paid feature.
Copy data from one project to another with ease.
You can now change the order in which the images and files are listed on your table by simply dragging and rearranging them.
Want a table to be always sorted by a specific column? You can now sort tables on a column and save that as the default view for everyone viewing that table. Super useful when you want to ensure sorting by a datetime field or some value for all your users.
You can now view all your existing collections and set them up with one click, with pre-filled config.
Get calculated field values based on other columns. You can code in javascript to calculate anything: eg - add numbers, logic, concat strings etc.
Lightweight UI-only field, not stored in the database (use derivatives if you want data persisted).
One of the most asked column types. You can now easily create arrays, using Firebase like UI, esp if the JSON field type with array didn't cut it for you.
Build any workflows and assign row items to users. Useful in a variety of use cases such as operational admin, project management, customer support, and many more.
One of the most asked features is now available to Rowy Pro users. Search across your Rowy Tables and Firestore collections with ease. Don't worrying about the case sensitivity of the search term. No need to know the complete search term.
Just start typing and get a list of rows that match it across your table.
New table interface should give you much smoother experience of scrolling and browsing your data. With seamless infinite scroll, cell navigation and overall accessible experience.
You can now have multiple workspaces with your teams and connect with any number of Firebase projects. Create one for development, testing and production to build reliable and tested backend system.
You can reorder columns and hide away the ones you do not need using the column menu option at the top of your table.
Allow for project deletes and leaving workspaces with ability to transfer ownership of workspaces. Fix issues around user invites, cancelling of team invites.