Changelog

Bulk view creation

We’ve totally revamped the way you create new views to allow for bulk view creation. This means that you can select multiple tables from your database, and we’ll automatically generate views for them all. This makes the initial setup process of a new team much faster and smoother.

You can try it out in two ways:

1. Create a new team. The initial state of the team page will let you create views.
2. Add new views to a team. You’ll see a modal that lets you create views from your database.

We have more improvements planned for bulk view creation, so keep your eye out on our changelog. To keep up to date, you can follow Basedash on Twitter, and join our Slack community where we post updates, share access to beta features, and listen to your feature requests and bug reports.

Other improvements and fixes

• Added the ability to edit and delete pages directly from the sidebar
• Fixed workspace switcher sometimes being unreliable
• Fixed moving pages to other teams when they were originally part of a section
• Fixed web app crashing in some cases where there was a mismatch in cache state
• Fixed creating Slack alert subscriptions from the desktop app
• Fixed search history not closing after applying a search
• Fixed views disappearing from the sidebar after being edited

‍

View relations (beta)

We’re excited to announce a beta release for view relations. View relations allow you to connect data together across different tables—or even different data sources—to easily see which records are related to the currently selected record. Once you create a relation on a view, you’ll be able to see a list of records related to the selected record in the right details panel.

For example, with view relations you can show:

• Users in a selected workspace
• Orders made by a selected customer
• Products made by a selected manufacturer
• Variants of a selected product
• Anything else you can think of

Check out the full docs here: https://docs.basedash.com/views#31539877ad05480aad2cb91337fc6713

See how it works in a quick video demo: https://youtu.be/NAIiKbV4uio

Redesigned sidebar navigation (beta)

We completely redesigned the sidebar to simplify navigation and allow you to quickly jump between pages, no matter where you are in Basedash. Along with this change, we also renamed “Apps” to “Teams”. Now, your teams appear as folders in the sidebar, letting you easily access the pages within.

Alongside the changes to the sidebar, we also made the decision to remove the raw table editor from Basedash. You can still create views of your database in the table layout, but nothing is created automatically after connecting a database. This change aligns the new user experience with our intended primary value of Basedash.

Because these changes are significant and remove some functionality, they have not yet been applied to existing workspaces, only newly created ones. If you want to upgrade your workspace to the new design, send us a message in the app, or in our Slack community. We plan to migrate all existing customers in the coming months.

Other improvements and fixes

• Added team membership indicators on the members page
• Added the ability to create multiple views at once after creating a new team
• Updated searches to save to the URL for sharing
• Improved default attributes visible on views using AI
• Removed members page in apps in favor of directly opening the members modal
• Fixed searches not being cleared when switching between pages
• Fixed filter values being reset when changing the filter column
• Fixed views becoming temporarily hidden in the sidebar after being edited
• Fixed HTML rich text editor not being able to be saved

PlanetScale support

We’re excited to announce first-party support for PlanetScale as a data source.

PlanetScale is a high-performance MySQL-compatible database platform. With Basedash, you can build fully-featured admin panels on top of your PlanetScale database in seconds. This lets you build things like user dashboards, order management tools, or approval workflows in a few clicks. Everything you build in Basedash is shareable with your team, with full permission controls at your fingertips.

To connect a PlanetScale database, create a new connection in Basedash and select “PlanetScale” as your database. You can retrieve your connection credentials from the PlanetScale dashboard for easy connection to Basedash, with full read-write capabilities.

Once connected, you can create views to allow certain tables to be viewed and edited, and also write SQL queries directly against your database. Both views and queries can be shared with teammates with either view or edit access.

Basedash also supports PlanetScale Boost for ultra high performance queries. Any SQL queries you write in Basedash that match a query that you’ve cached in PlanetScale will be boosted. For now, you need to manually enable Boost cached queries on your database connection by running the following SQL query in Basedash: SET @@boost_cached_queries = true;

Search history

We now save search history within views so that you can easily go back to previous searches. We also now persist your search query on a view when you switch pages and come back. This makes it much easier to jump between pages and cross-reference data.

Other improvements and fixes

• Added the ability to transfer workspace ownership to another member
• Added a footer to the sidebar with user info
• Added support for MySQL timestamps
• Added dedicated Members pages within workspaces and apps
• Added activity logs for record creation
• Added ability to move pages to another app
• Added tooltips with keyboard shortcuts on more sidebar items
• Added the ability to save a partially-created action
• Added the ability to partially select text in table cells
• Added a workspace switcher on mobile
• Added a demo Postgres database to all new workspaces
• Improved styling of list layout header
• Updated filters to maintain value if possible when switching columns
• Updated the search bar to retain its value after changing pages and closing the app
• Updated onboarding to automatically create a workspace on signup
• Updated Slack alerts to only show the attributes selected on the active layout of the view
• Updated styling of toast for updating the app to be less intrusive
• Fixed new Slack alerts not being able to be created
• Fixed page limit not being applied in some cases
• Fix loading data from tables that use object-based primary keys
• Fixed onboarding flow for Google signups
• Fixed recent search not being cleared after clearing search bar
• Fixed issues with avatars not being perfect circles
• Fixed API settings automatically saving when clicking on a header
• Fixed changing connection names
• Renamed “History” to “Activity” in record details
• Removed “Pages” section header from app sidebar

Database connection URIs

You can now connect a database way faster by just pasting in a single connection URI from your hosting provider. We’ll automatically parse the connection string and fill out the individual field components so you don’t have to.

Onboarding checklist

When you create a new workspace, we’ll now show a simple onboarding checklist so you always know the next step to improve your apps and views. Each step has instructions, docs, and videos to explain how to move forward with setting up your workspace.

AI-generated view emoji

When you create a new view, we’ll now automatically choose a relevant emoji to represent your view and make it recognizable. We’re using GPT-3 to choose an emoji based on the name of your view’s base table.

Other improvements and fixes

• Added ability to transfer workspace ownership to another member
• Added ability to dismiss app update toast
• Improved security of API headers
• Updated layout of view header bar to give search more room
• Updated styling of app card borders
• Moved the profile dropdown to the bottom of the sidebar
• Fixed attributes marked as uneditable not being able to be set during record creation
• Fixed attribute syncing after changing a database column to nullable
• Fixed Slack alert notification creation
• Fixed actions not appearing in the sidebar immediately after creation
• Fixed appearance of apps with no cover image
• Fixed record edits being applied multiple times in some cases
• Fixed long foreign key values being cut off
• Fixed removing filters sometimes removing the incorrect filter
• Fixed positioning of attributes popover for tables with many columns
• Fixed some avatars appearing as ovals instead of circles
• Fixed attributes still appearing in views after being deleted in the database

App templates

When you create a new app, we’ll now suggest some templates to give you ideas of the kinds of apps you can create. For now, they set the name, image, and icon of the app—in the future, we may use the templates to make even more suggestions on the kinds of views or actions you can create within the app.

Automatic record images

When you create a view, we’ll now automatically look for any columns that store URLs to images, so that we can show the image inline in your new view. That makes it way easier to create beautiful list or card-based views of your database.

You can always set the display image attribute manually in your view settings.

Other improvements and fixes

• Updated default view names to be humanized
• Added a workspace setting to prevent non-admins from inviting new members
• Added a CTA to upgrade when nearing your plan’s page limit
• Improved onboarding sequence to speed up time before creating an app

Vertical card orientation

We’ve added a new orientation to card layout that lets you stack an image from your database above any important information. It’s perfect for any image-heavy data, letting you quickly navigate through your records. You can fully customize the image and data that shows up on each record’s card, and independently control which attributes are visible and editable in the side panel.

You can switch between vertical and horizontal card orientation when creating or editing a view.

Action history

You can now view the run history of any action directly on the action page. This lets you see every time that an action has been run by you or your team, along with the details of the input values and API response.

For more information about actions and what you can do with them, check out our docs: https://docs.basedash.com/actions

Other improvements and fixes

• Added ability to delete app sections
• Added support for editing interval columns
• Added inline warnings to the action creation page
• Added support for self-hosting on AWS ECS
• Added an error message for SQL queries that time out
• Added workspace switcher to new workspace onboarding flow
• Added indicator to show which trigger was clicked when opening a popover
• Added ability to run draft actions from the action builder
• Simplified signup form
• Improved database sync performance
• Improved signup page for joining the demo workspace
• Updated tooltip copy on the “Publish” view button
• Updated styling of list and card layouts to have a maximum width
• Fixed alignment of switch inputs
• Fixed button to remove filters sometimes not working
• Fixed “New record” button appearing on uneditable pages
• Fixed disconnected tables showing on the connections page
• Fixed duplicating queries to redirect to the newly created query

Improved desktop tabs

We’ve improved tabs on the desktop app even further, by allowing you to open multiple tabs of the same app. This lets you easily cross-reference views or actions in the same app for complex workflows.

You can open a new tab by clicking the new “+” button in the tab bar, or by holding Ctrl/Command when opening an app from the Home page.

You can download the Basedash desktop app for Mac, Windows, and Linux here: https://www.basedash.com/download

Other improvements and fixes

• Added a history pane to the action editor
• Added a separate “Save” button in the action editor
• Added an improved empty state for lists that support adding and removing entities
• Added number indicator to History tab in record details panel
• Added actions to record history panel
• Added tooltips with keyboard shortcuts across the app
• Added new tab button on desktop app
• Added support for multiple tabs of the same app on the desktop app
• Added more information to action history items
• Added “Share” button to database tables
• Added support for line breaks in action descriptions
• Added support for Slack notifications on self-hosted setups
• Added support for Google sign-in on self-hosted setups
• Added support for self-hosted AWS ECS deployments
• Fixed links in emails for self-hosted deployments
• Fixed loading spinner appearing after resizing a table column
• Fixed tab location resetting in some instances
• Fixed deleted views not disappearing from the sidebar for other users in the workspace
• Fixed duplicated views not being added to the correct section
• Fixed action inputs not updating immediately
• Updated display images to show a placeholder for records with undefined values
• Improved the performance of load times for re-opening views that have been opened recently
• Removed the limit on number of apps based on plan
• Renamed “collection page” to “view”

‍

Record-level activity

You can now see edits that have been made on a specific record. Just select the record in a collection page, then switch to the “History” tab in the panel on the right. You’ll be able to see a list of recent edits including the person who made the change, the before and after value, and the time the change was made.

Desktop app tabs

On the Basedash desktop app, you can now open apps as tabs to easily navigate between them. You can also switch between them with your keyboard by pressing Ctrl/Cmd + 1-9.

You can download the Basedash desktop app for Mac, Windows, and Linux here: https://www.basedash.com/download

Drag pages between sections

You can now click and drag to move pages between sections in an app. This makes it way easier to organize your apps just the way you want them.

You can create a section by clicking “New” in the sidebar, then “Section”. Once you have multiple sections, you can simply click and drag a page to a new section.

Share button

We added a Share button on all pages within an app so that you can easily see who has access to the page, copy the link, and invite new members to your app.

Other improvements and fixes

• Added the ability to include links in page descriptions
• Added a button to the date picker to select the current date
• Added a button to the date picker to clear the value
• Added a button to return to the Apps launcher from within an app
• Added support for non-admins to sort collection pages
• Added user-level persistence of sorts on collection pages
• Added the ability to rename workspaces from settings
• Added the ability to update workspace logos from settings
• Added an indicator showing the number of pages in an app
• Added template cover images when creating and editing apps
• Added a link to download the desktop app from the profile dropdown
• Added new content explaining page types when you create a new app
• Added a new email alert for getting invited to an app
• Improved performance of loading action-related data
• Improved responsiveness of form fields at small screen sizes
• Updated the behavior for opening apps on the web to not open a new tab
• Updated styling of login and signup pages
• Updated opening animation of modals
• Fixed running actions with interpolated values
• Fixed editing joined attributes on collection pages with joined tables
• Fixed database tables not appearing in command bar after opening and closing an app
• Fixed a bug where the page limit would be hit before reaching the full limit
• Fixed help text on switches being squished
• Fixed app members with edit access not being able to edit some data
• Fixed sorting on database tables
• Fixed action inputs not being cleared when navigating between actions
• Fixed some optional attributes not being able to be hidden from collection pages in form layout
• Fixed duplicating pages in an app
• Fixed loading spinner appearing excessively on collection pages

We’re excited to release our biggest update ever to Basedash. We’re introducing two new major features, along with many other smaller features and improvements.

We made a quick 5 minute video showing off the full process of building an internal app with actions.

We’re also live on Product Hunt with these changes, join the discussion here: https://www.producthunt.com/posts/basedash-apps-actions

Apps

Apps are a new way to organize your views + queries. Each app can have its own set of members, so you can create one for each team in your company. You can also create sections within apps to organize your pages further.

With apps, we’re now letting different teams within the same company work together, while still providing robust permissioning and access controls. Some ideas of apps that you can create:

• Engineering
• Support/CX
• Sales
• Investor metrics
• Content moderation

Actions

With actions, for the first time, we’re expanding Basedash beyond the database.

You can create actions to integrate with any third-party service with an API. You and your teammates can trigger actions to call an API (either internal or external) with the click of a button. Actions can also be triggered on database records, allowing you to take action directly on your data.

Before creating an action, you need to create a connection to an API. We have some templates for common third-party APIs, but you can always add your own.

Some ideas of what you can do with actions:

• Send an email to a user through SendGrid
• Refund a purchase on Stripe
• Trigger a workflow on Zapier/Make
• Update records through your internal API for complex validation
• Create an order on Shopify
• Update a customer on Salesforce/Hubspot

Other features

Pricing

We’ve updated our pricing to remove the limit on number of members and number of connections. You’re now free to add as many members as you’d like on any plan, including the free plan.

See our updated pricing page here: https://www.basedash.com/pricing

Sections

You can add sections to further organize your apps. Sections contain pages, and show up in the sidebar so you can easily find the page you’re looking for.

Form layout

We added a new layout type that only allows users to create new records in a database table. When this layout is selected, all other layouts will be disabled for that collection page (to prevent viewing and editing of existing data).

Display image

You can now explicitly set a display image on your collection pages. This image shows up in both list and card layouts, as well as in the record details panel. This is incredibly useful for data that revolves around images, such as users, products, properties, or companies.

Collection page description

You can now set a description on a collection page, which will show up in the record details panel when no records are selected. You can use this to describe how a collection page should be used by users.

Collection page permissions

You can now set certain permissions directly on a collection page:

• Record creation
• Record deletion
• Record editing
• CSV exporting

These are all enabled by default, but you can disable them by editing a collection page and navigating to the “Info” tab.

Sidebar search

You can now search for pages directly from the sidebar. Just hit ‘/’ and start typing to filter items in the sidebar.

Other improvements and fixes

• Improved responsiveness of fields
• Fixed some hidden attributes still appearing when creating a record
• Updated command bar to allow navigation to pages within an app
• Fixed loading spinner showing on collection pages unnecessarily
• Updated styling of login and signup pages
• Updated animation of modals and dialogs
• Improved precedence of keyboard shortcuts depending on focus
• Added link for new users to join the demo workspace directly
• Added an empty state to list and card layouts
• Added information about when a collection page was created and last updated
• Changed the default collection page layout from table to list
• Improved styling of date picker in dark mode
• Improved layout of rows in list layout
• Removed restriction of primary attribute always showing as the first column in a table
• Improve interface for adding and removing attributes in a collection page
• Update styling of switch inputs
• Added new icons to some inputs
• Removed roles. Apps provide all the same functionality, plus allow for more organization of pages
• Improved support for collection pages with many columns
• Improved stability of keyboard navigation in list and card layouts
• Added field to set an icon on collection pages and queries within edit mode
• Removed navigation footer on mobile

‍

Connection summary

After connecting a database, we now show you all the steps we take to humanize your data in Basedash, including setting primary attributes, obscuring personally identifiable information, and prettifying table and column names.

You can review your database schema, and compare the humanizations made in Basedash. Note that we don’t make any changes to your database schema itself, just the way it’s

Sidebar search

You can now search the contents of any sidebar in the app to quickly find the page you’re looking for. You can also focus the search bar immediately with the keyboard shortcut “/”.

Other improvements and fixes

• Added tabs to view settings sidebar
• Added the ability to delete records on tables with no primary key
• Added support for real-time avatar list of more than 3 users
• Moved view icon switcher to view settings
• Moved query icon switcher to query settings
• Moved ‘remove connection’ flow to a modal from the connection settings
• Updated URL paths for connection-related pages
• Updated styling of outlined buttons
• Fixed workspace switcher text color
• Fixed the activity page crashing the app in rare cases
• Fixed accessing favorited views from the Home tab
• Fixed connections not being removed after being deleted by another user
• Fixed roles not being removed after being deleted by another user
• Fixed new connections not immediately appearing in the sidebar