Views

Views

Views

Views allow you to view and edit your database data in a more user friendly way.

Creating a view

Views must be created within apps. When creating a view, you will be prompted to select which database table to use as the Source for your view. Once you’ve selected your source table, you will enter the view editor, where you can do things such as:

  • Show/hide/reorder attributes
  • Specify sorts and filters
  • Edit the name and emoji
  • Pick the layout in which the data should be presented
image

Layouts

  • List (Default)
  • image
  • Card
  • image
  • Table
  • image
  • Form Used to create new records on the Source table
  • image

Join tables

If the source table used on the view has foreign key columns, then it’s possible to join the base table with other tables that correspond to the foreign key columns.

Show/hide attributes

Every attribute (i.e. table column) can either be visible or hidden. You can also specify a different set of attributes from one layout to another in order to be able to show different attributes for different layouts.

Slack notifications

You are able to enable Slack notifications on a view. When enabling Slack notifications, you must specify a “created at” date column that is used to determine if new records have been created. You can select the frequency at which slack notifications appear (daily, hourly, real-time).

image
image
💠
https://www.basedash.com

© BaseDash Inc.