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

Booking

This object will contain information regarding the booking of an event. It comes with the following fields:
Field Name
Type
Notes
Client
Client
This field will store information about the user that booked the event.
end
date
This field stores the end of a booked event.
Event
Event
This field will store the event for which a booking was made.
guests
List of texts
This field will store a list of guest for the booking,
note
text
This field will store notes about a booking made by the host.
start
date
This field stores the start of a booked event.

Client

This object will store information about a client. It comes with the following fields:
Field Name
Type
Notes
email
text
This field will store the client’s email.
username
text
This field will store the client’s username.

Event

This object will hold information about an event. It comes with the following fields:
Field Name
Type
Notes
active
yes / no
This field marks an event as active or inactive.
booking_interval
number
This field stores the custom interval for a slot, if the even interval is custom.
custom_interval
yes / no
This field sets the interval of an event as custom.
description
text
This field is used to store the event’s description.
end
date
This field stores the event end date.
host_email
text
This field stores the host email.
host_name
text
This field stores the host name.
host_username
text
This field stores the host username.
Invitees
List of Clients
This field stores a list of invitees to this event.
link_details
text
This field will store a link that will open additional details about an event. For example, it can be a zoom link.
minutes_after
number
This field stores the amount of time after an event slot.
minutes_before
number
This field stores the amount of time before an event slot.
name
text
This field will store the event’s name.
notice_amount
number
This field will store a number which will determine the amount of time the user has before scheduling an event slot.
Schedule
Schedule
This field will store an event schedule.
secret
yes / no
This field will mark an event as secret, it will not be shown on index.
start
date
This field stores the event start date.
Type
EventType
This field will record the type of the event.
valid_date_range
date range
This field will store the date range of the event.
valid_date_range
date range
This field will store the date range of the event.
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Exception

This object holds exceptions for a date. It comes with the following fields:
Field Name
Type
Notes
date
date
This field stores the date for which this exception will be applied.
Exceptions
List of HourRanges
This field stores a list of hour ranges, that will correspond to the actual exception you want to create.

HourRange

This object is used for storing hour ranges for a particular day within a schedule. It comes with the following fields:
Field Name
Type
Notes
range
date range
This field stores the range of hours.

Schedule

This object stores the scheduling information of events. It comes with the following fields:
Field Name
Type
Notes
default
yes / no
This field marks a schedule as default on signup. It cannot be deleted.
Events_numbers
List of Events
Counts the number of events for this schedule_pattern.
Exceptions
List of Exceptions
This field will store a list of exceptions for a particular day.
Fridays
List of HourRanges
This field will store a list of hour ranges for all fridays.
Mondays
List of HourRanges
This field will store a list of hour ranges for all mondays.
name
text
This field will store a schedule’s name.
Saturdays
List of HourRanges
This field will store a list of hour ranges for all saturdays.
Sundays
List of HourRanges
This field will store a list of hour ranges for all sundays.
Thursdays
List of HourRanges
This field will store a list of hour ranges for all thursdays.
Tuesdays
List of HourRanges
This field will store a list of hour ranges for all tuesdays.
Wednesdays
List of HourRanges
This field will store a list of hour ranges for all wednesdays.

Statistic

This object is intended to store information about subscriptions and the number of users subscribed. This object was created in order to enhance the speed of data visualisation. It comes with the following fields:
Field Name
Type
Notes
count_user
number
This field stores a number of users that correspond to the statistic type it’s being attributed to.
Plan
Plan
This field stores the plan name, for which it will count the users.

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.
It comes with the following fields:
Field Name
Type
Notes
12h_format
yes / no
This field will determine wether the time on the platform will be shown in the 24/12 h format.
admin
yes / no
This field gives the user admin access.
blocked
yes / no
This field will determine if the user was banned from the platform.
Bookings
List of Bookings
This field will contain a list of bookings that a host has for his events.
Country
Country
Stores the user country.
Events
List of Events
Stores the events that a user creates.
full_name
text
Stores the user’s full name.
ext_billing_period
date
This field stores the next billing date for the customer’s subscription.
Plan
Plan
This field store’s the plan to which a user is subscribed.
plan_schedule_cancel
text
This field stores the scheduled api WF ID which is generated when a user wants to cancel his plan. This ID can be later used to resubscribe the user to the plan. If we want to resubscribe a user to the plan, we just cancel the scheduled api WF that cancels his subscription using the stored ID.
profile_picture
image
This field stores the profile image of an user.
Schedules
List of Schedules
This field stores a list of schedules created by the user.
state
text
This field stores a user’s state if he is from the United States.
subscription_active
yes / no
This field is used to determine wether a user has an active subscription or not, it is an auxiliary field, the app can work without it, but it can be used if you need additional customisations in the app.
temp_email
text
This field will store the temporary email of an user, for which the host decided to schedule an event.
TimeZone
TimeZone
Stores a saved user’s timezone.
username
text
This field holds a user username.
welcome_message
text
This is the welcome message of a host.
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Variable

This is an object that holds template variables. It comes with the following field:
Field Name
Type
Notes
access_rights
yes / no
This field is intended to restrict a demo admin user rights, so that he doesn’t delete the template’s content.

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.

Country

This option set holds a list of countries. It does not have any additional fields. It uses a built-in attribute to display the values.
The options for this set are:

EventDuration

This field holds all the options for the event duration. It comes with the following attribute:
Attribute
Type
Notes
value
number
This value displays the event duration.
The options for this set are:
Option
Types
15
The event duration value of 15.
30
The event duration value of 30.
45
The event duration value of 45.
60
The event duration value of 60.

EventType

This option defines the event types possible on the platform. It comes with the following attributes:
Attribute
Type
Notes
icon_active
image
This attribute holds the design for the active icon.
icon_inactive
image
This attribute holds the design for the inactive icon.
The options for this set are:
Option
Types
One on one meeting
The option for One on one meeting.
Phone call
The option for Phone call.
Video conference
The option for Video conference.
All event types
The option for All event types.

Plan

This option set holds info about possible plans on the platform. It comes with the following attributes:
Attribute
Type
Notes
ContainPlans
List of Plans
This attribute helps us with filtering.
price
number
This attribute contains information about the plan’s price.
The options for this set are:
Option
Types
All plans
The option for All plans.
Free
The option for Free plans.
Monthly
The option for Monthly plans.
Yearly
The option for Yearly plans.

TimeZone

This option set holds all the timezones.
💡
Tip: To find the pages where the options sets are used, use the App Search Tool within the editor.
Image without caption
Search page and element where the option set is used

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?