This section consists of Database Things and fields description for every thing which is part of the template.

Introduction

To get to the Data section, click the database icon on the left side tabs in Bubble Editor.

Data Types

Note: In case you have accidentally deleted a data type - no worries! Bubble lets you restore💪the deleted data type. Clicking on 'show deleted types' or 'show deleted fields' from the Data → Data types tab will reveal the deleted items, and a 'restore' button will appear next to each deleted entry. Simply click 'restore', to restore a field or data type.
💡
Tip: Aside from the below-listed data types and fields, Bubble creates these default fields visible in each data type: Creator, Modified Date, Created Date and Slug, except for the User data type. The User data type will have the following fields: email, Modified Date, Created Date and Slug. These fields' values can be used in workflows, conditional formatting, etc. To learn more, see the Bubble manual

AccessTemplate

This data type stores information about template access. Users with admin rights will be able to access the admin page, and those that are granted super admin rights will be able to use the admin panel features.
⚠️
Admin: See the instructions on how to grant Admin Rights in your template.
It comes with the following fields:
Field Name
Type
Notes
access
yes / no
Specifies if the user can use the admin features in full and modify/delete the data inside the dashboard page.

Category

This data type stores information about meditation categories on the platform.
It comes with the following fields:
  • color text Stores information about the color of meditation category.
  • Playlists - List of Playlists​ Stores information about the list of meditations that a playlist contains.
  • Recently_Played List of Meditations​ Stores information about the list of meditations that have been recently played by the user.
  • title text Stores the information about the title of the meditations' category.

Meditation

This data type stores information about the meditations available at the platform.
It comes with the following fields:
audiofileStores information about meditation audio files.
  • Category Category​ Stores information about the category that this meditation belongs to.
  • description text Stores information about meditation text description.
  • featured yes / no Stores information whether the meditation is featured or no. Featured meditations appear in "For today" and "Start now" sections.
  • free yes / no This field specifies if the meditation is available for users on free plan. This value is set manually by the admin in the admin panel.
  • image image This field stores the cover image of the meditation.
  • Playlist Playlist​ Stores information about the playlist the meditation belongs to.
  • title text Stores the name of the meditation.track_timetextStores the duration of the meditation.
  • video file Stores the meditation video file.
  • visible yes / no Specifies if the meditation is visible to public. It's set manually by the admin in admin panel.

Plan

This data type stores information about subscription plans used on the platform. The subscriptions are powered by Stripe. Now there are 2 plans: monthly & yearly, both with free trials.
💡
Tip: See instructions on how to configure the payments in the Setup Guide -> Payments section.
It comes with the following fields:
  • api_ID text Stores plan ID from Stripe dashboard.
  • plan_name text Stores the plan name.
  • price number Stores the price of the plan.

Playlist

This data type stores information about a playlist. Playlist is composed of audio or video meditations.
💡
Tip: A playlist is a list of video or audio meditations that can be played back.
It comes with the following fields:
  • Category Category​ Stores information about the category this playlist belongs to.
  • image image Stores the playlist image.
  • Meditations List of Meditations​ Stores the list of meditations that make the playlist.
  • playlist_cover image Stores banner (cover) of the playlist.
  • title text Stores the name of the playlist.

User

Bubble applications have a built-in User data type that acts like any type that is created in a database. For instance, you can modify a user, delete a user, list them in a repeating group, etc. To learn more, see the Bubble manual.
This is the main data type. It stores all the information about a platform user.
💡
Tip: The admin rights are stored here.
💡
Tip: The dark/lite mode is stored here.
It comes with the following fields:
  • admin yes / no Specifies if the user has access to the admin page.
  • dark_mode yes / no Specifies what mode is set by the current user - lite or dark.
  • Favorites List of Meditations​ List of meditations that current user added to his list of favorites.
  • first_name text Stores the user first name.last_nametextStores the user last name.
  • Plan Plan​ Stores the plan that current user is using.
  • refunded yes / no Specifies if the refund to the Subscription plan was made by platform admin/owner.
  • text_email text Stores the user email to filter users by email in admin panel.
  • transaction_date date Stores the day the user signed up for a paid plan.
Note: The data type has a privacy rule applied. See the 💬 in the database under the Privacy section for details.

Option Sets

💡
Tip: Option sets define a static list of choices for use in dropdowns, pop-ups, etc. Options inside the sets have at least a text display, but they can have additional attributes defined in the Data tab. To learn more, see Bubble Manual.
Below you can find the list of option set attributes and options.

Affirmation

The affirmations are listed on the index page in the side menu on the top right.
This option set does not have any additional fields. It uses a built-in attribute to display the values.
‌The options for this set are:
Asking for help is a sign of self-respect and self-awareness.The display text option.
  • I can control how I respond to things that are confronting. The display text option.
  • I can hold two opposing feelings at once, it means I am processing. The display text option.
  • I deserve information and I deserve moments of silence, too. The display text option.
  • I do not have to linger in dark places; there is help for me here. The display text option.
  • I do not pretend to be anyone or anything other than who I am. The display text option.
  • I do not rush through my life, I temper speed with stillness. The display text option.
  • I grow towards my interests, like a plant reaching for the sun. The display text option.
  • I look forward to tomorrow and the opportunities that await me. The display text option.
  • I make time to experience grief and sadness when necessary. The display text option.
  • I practice gratitude for all that I have, and all that is yet to come. The display text option.

TrackSorting

This option set is used for track sorting. The audio tracks are sorted on the admin page.
It comes with the following attributes:
  • descending yes / no Stores the sorting type: descending or not.
  • sorting text Stores the information about the sorting field.
The options for this set are:
  • By name: a-z Sorts by title field in ascending oder.
  • By name: z-a Sorts by title field in descending order.
  • Newest Sorts by Created Date field in descending order.
  • Oldest Sorts by Created Date field in ascending order.

UserSorting

This option set is used for track sorting. The audio tracks are sorted on the admin page.
It comes with the following attributes:
  • descending yes / no Stores the sorting type: descending or not.
  • sorting text Stores the information about the sorting field
The options for this set are:
  • By name: a-z Sorts by first_name field in ascending order.
  • By name: z-a Sorts by first_name field in descending order.
  • By email: a-z Sorts by text_email field in ascending order.
  • By email: z-a Sorts by text_email field in descending order
  • Newest Sorts by Created Date field in descending order.
  • Oldest Sorts by Created Date field in ascending order.
💡
Tip: To find the pages where the options sets are used, use the App Search Tool within the editor. 
Image without caption

Embedded Notes in Bubble Editor

This template comes with explicit Notes for Database fields, Option sets and their fields, and Privacy rules, which will guide you through the modification process. In order to preview a Note of any data type or field, click on the 💬 icon.
Image without caption

Helpful?