Data Types

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.
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:
Option
Notes
Afghanistan
This option represents the current country selection when the user signs up
Albania
This option represents the current country selection when the user signs up
Algeria
This option represents the current country selection when the user signs up
America
This option represents the current country selection when the user signs up
Andorra
This option represents the current country selection when the user signs up
Angola
This option represents the current country selection when the user signs up
Antigua
This option represents the current country selection when the user signs up
Argentina
This option represents the current country selection when the user signs up
Armenia
This option represents the current country selection when the user signs up
Australia
This option represents the current country selection when the user signs up
Austria
This option represents the current country selection when the user signs up
Azerbaijan
This option represents the current country selection when the user signs up
Bahamas
This option represents the current country selection when the user signs up
Bahrain
This option represents the current country selection when the user signs up
Bangladesh
This option represents the current country selection when the user signs up
Barbados
This option represents the current country selection when the user signs up
Belarus
This option represents the current country selection when the user signs up
Belgium
This option represents the current country selection when the user signs up
Belize
This option represents the current country selection when the user signs up
Benin
This option represents the current country selection when the user signs up
Bhutan
This option represents the current country selection when the user signs up
Bissau
This option represents the current country selection when the user signs up
Bolivia
This option represents the current country selection when the user signs up
Botswana
This option represents the current country selection when the user signs up
Brazil
This option represents the current country selection when the user signs up
British
This option represents the current country selection when the user signs up
Brunei
This option represents the current country selection when the user signs up
Bulgaria
This option represents the current country selection when the user signs up
Burkina
This option represents the current country selection when the user signs up
Burma
This option represents the current country selection when the user signs up
Burundi
This option represents the current country selection when the user signs up
Cambodia
This option represents the current country selection when the user signs up
Cameroon
This option represents the current country selection when the user signs up
Canada
This option represents the current country selection when the user signs up
Cape Verde
This option represents the current country selection when the user signs up
Central African Republic
This option represents the current country selection when the user signs up
Chad
This option represents the current country selection when the user signs up
Chile
This option represents the current country selection when the user signs up
China
This option represents the current country selection when the user signs up
Colombia
This option represents the current country selection when the user signs up
Comoros
This option represents the current country selection when the user signs up
Congo
This option represents the current country selection when the user signs up
Costa Rica
This option represents the current country selection when the user signs up
Croatia
This option represents the current country selection when the user signs up
Cuba
This option represents the current country selection when the user signs up
Cyprus
This option represents the current country selection when the user signs up
Czech
This option represents the current country selection when the user signs up
Denmark
This option represents the current country selection when the user signs up
Djibouti
This option represents the current country selection when the user signs up
Dominica
This option represents the current country selection when the user signs up
East Timor
This option represents the current country selection when the user signs up
Ecuador
This option represents the current country selection when the user signs up
Egypt
This option represents the current country selection when the user signs up
El Salvador
This option represents the current country selection when the user signs up
Emirates
This option represents the current country selection when the user signs up
England
This option represents the current country selection when the user signs up
Eritrea
This option represents the current country selection when the user signs up
Estonia
This option represents the current country selection when the user signs up
Ethiopia
This option represents the current country selection when the user signs up
Fiji
This option represents the current country selection when the user signs up
Finland
This option represents the current country selection when the user signs up
France
This option represents the current country selection when the user signs up
Gabon
This option represents the current country selection when the user signs up
Gambia
This option represents the current country selection when the user signs up
Georgia
This option represents the current country selection when the user signs up
Germany
This option represents the current country selection when the user signs up
Ghana
This option represents the current country selection when the user signs up
Great Britain
This option represents the current country selection when the user signs up
Greece
This option represents the current country selection when the user signs up
Grenada
This option represents the current country selection when the user signs up
Grenadines
This option represents the current country selection when the user signs up
Guatemala
This option represents the current country selection when the user signs up
Guinea
This option represents the current country selection when the user signs up
Guyana
This option represents the current country selection when the user signs up
Haiti
This option represents the current country selection when the user signs up
Herzegovina
This option represents the current country selection when the user signs up
Honduras
This option represents the current country selection when the user signs up
Hungary
This option represents the current country selection when the user signs up
Iceland
This option represents the current country selection when the user signs up
India
This option represents the current country selection when the user signs up
Indonesia
This option represents the current country selection when the user signs up
Iran
This option represents the current country selection when the user signs up
Iraq
This option represents the current country selection when the user signs up
Ireland
This option represents the current country selection when the user signs up
Israel
This option represents the current country selection when the user signs up
Italy
This option represents the current country selection when the user signs up
Ivory Coast
This option represents the current country selection when the user signs up
Jamaica
This option represents the current country selection when the user signs up
Japan
This option represents the current country selection when the user signs up
Jordan
This option represents the current country selection when the user signs up
Kazakhstan
This option represents the current country selection when the user signs up
Kenya
This option represents the current country selection when the user signs up
Kiribati
This option represents the current country selection when the user signs up
Kosovo
This option represents the current country selection when the user signs up
Kuwait
This option represents the current country selection when the user signs up
Kyrgyzstan
This option represents the current country selection when the user signs up
Laos
This option represents the current country selection when the user signs up
Latvia
This option represents the current country selection when the user signs up
Lebanon
This option represents the current country selection when the user signs up
Lesotho
This option represents the current country selection when the user signs up
Liberia
This option represents the current country selection when the user signs up
Libya
This option represents the current country selection when the user signs up
Liechtenstein
This option represents the current country selection when the user signs up
Lithuania
This option represents the current country selection when the user signs up
Luxembourg
This option represents the current country selection when the user signs up
Macedonia
This option represents the current country selection when the user signs up
Madagascar
This option represents the current country selection when the user signs up
Malawi
This option represents the current country selection when the user signs up
Malaysia
This option represents the current country selection when the user signs up
Maldives
This option represents the current country selection when the user signs up
Mali
This option represents the current country selection when the user signs up
Malta
This option represents the current country selection when the user signs up
Marshall
This option represents the current country selection when the user signs up
Mauritania
This option represents the current country selection when the user signs up
Mauritius
This option represents the current country selection when the user signs up
Mexico
This option represents the current country selection when the user signs up
Micronesia
This option represents the current country selection when the user signs up
Moldova
This option represents the current country selection when the user signs up
Monaco
This option represents the current country selection when the user signs up
Mongolia
This option represents the current country selection when the user signs up
Montenegro
This option represents the current country selection when the user signs up
Morocco
This option represents the current country selection when the user signs up
Mozambique
This option represents the current country selection when the user signs up
Myanmar
This option represents the current country selection when the user signs up
Namibia
This option represents the current country selection when the user signs up
Nauru
This option represents the current country selection when the user signs up
Nepal
This option represents the current country selection when the user signs up
Netherlands
This option represents the current country selection when the user signs up
New Zealand
This option represents the current country selection when the user signs up
Nicaragua
This option represents the current country selection when the user signs up
Niger
This option represents the current country selection when the user signs up
Nigeria
This option represents the current country selection when the user signs up
North Korea
This option represents the current country selection when the user signs up
Norway
This option represents the current country selection when the user signs up
Oman
This option represents the current country selection when the user signs up
Pakistan
This option represents the current country selection when the user signs up
Palau
This option represents the current country selection when the user signs up
Panama
This option represents the current country selection when the user signs up
Papua
This option represents the current country selection when the user signs up
Paraguay
This option represents the current country selection when the user signs up
Peru
This option represents the current country selection when the user signs up
Philippines
This option represents the current country selection when the user signs up
Poland
This option represents the current country selection when the user signs up
Portugal
This option represents the current country selection when the user signs up
Qatar
This option represents the current country selection when the user signs up
Romania
This option represents the current country selection when the user signs up
Russia
This option represents the current country selection when the user signs up
Rwanda
This option represents the current country selection when the user signs up
Samoa
This option represents the current country selection when the user signs up
San Marino
This option represents the current country selection when the user signs up
Sao Tome
This option represents the current country selection when the user signs up
Saudi Arabia
This option represents the current country selection when the user signs up
Scotland
This option represents the current country selection when the user signs up
Senegal
This option represents the current country selection when the user signs up
Serbia
This option represents the current country selection when the user signs up
Seychelles
This option represents the current country selection when the user signs up
Sierra Leone
This option represents the current country selection when the user signs up
Singapore
This option represents the current country selection when the user signs up
Slovakia
This option represents the current country selection when the user signs up
Slovenia
This option represents the current country selection when the user signs up
Solomon
This option represents the current country selection when the user signs up
Somalia
This option represents the current country selection when the user signs up
South Africa
This option represents the current country selection when the user signs up
South Korea
This option represents the current country selection when the user signs up
South Sudan
This option represents the current country selection when the user signs up
Spain
This option represents the current country selection when the user signs up
Sri Lanka
This option represents the current country selection when the user signs up
St. Kitts
This option represents the current country selection when the user signs up
St. Lucia
This option represents the current country selection when the user signs up
Sudan
This option represents the current country selection when the user signs up
Suriname
This option represents the current country selection when the user signs up
Swaziland
This option represents the current country selection when the user signs up
Sweden
This option represents the current country selection when the user signs up
Switzerland
This option represents the current country selection when the user signs up
Syria
This option represents the current country selection when the user signs up
Taiwan
This option represents the current country selection when the user signs up
Tajikistan
This option represents the current country selection when the user signs up
Tanzania
This option represents the current country selection when the user signs up
Thailand
This option represents the current country selection when the user signs up
Tobago
This option represents the current country selection when the user signs up
Togo
This option represents the current country selection when the user signs up
Tonga
This option represents the current country selection when the user signs up
Trinidad
This option represents the current country selection when the user signs up
Tunisia
This option represents the current country selection when the user signs up
Turkey
This option represents the current country selection when the user signs up
Turkmenistan
This option represents the current country selection when the user signs up
Tuvalu
This option represents the current country selection when the user signs up
Uganda
This option represents the current country selection when the user signs up
Ukraine
This option represents the current country selection when the user signs up
United Kingdom
This option represents the current country selection when the user signs up
United States
This option represents the current country selection when the user signs up
Uruguay
This option represents the current country selection when the user signs up
USA
This option represents the current country selection when the user signs up
Uzbekistan
This option represents the current country selection when the user signs up
Vanuatu
This option represents the current country selection when the user signs up
Vatican
This option represents the current country selection when the user signs up
Venezuela
This option represents the current country selection when the user signs up
Vietnam
This option represents the current country selection when the user signs up
Wales
This option represents the current country selection when the user signs up
Welsh
This option represents the current country selection when the user signs up
Yemen
This option represents the current country selection when the user signs up
Zambia
This option represents the current country selection when the user signs up
Zambia
This option represents the current country selection when the user signs up

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