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

Address

This object stores saved customers’ addresses.
Field Name
Type
Notes
AddressApartment
text
Stores the apartment number
AddressCity
text
Stores the customer’s city
AddressEntrance
text
Stores the customer’s entrance number
AddressFloor
text
Stores the customer’s floor number
AddressHouse
text
Stores the customer’s house number
AddressLine1
text
Stores the customer’s address line 1
Country
text
Stores the customer’s country
Default
yes / no
Checks whether the saved address is the default one
Postal_code
text
Stores the customer’s postal code
State
text
Stores the customer’s state when selecting the USA option as a country

Comment

This object that will contain information about the platform comments.
Field Name
Type
Notes
Body
text
Stores the content of the comment
File
file
Stores the file attached to the comment
Sender
User
Stores the sender of the comment

Company

This object that will contain information about the company.
Field Name
Type
Notes
Address 1
Address
Stores the company address
Company_email
text
Stores the company email
Company_subscription
yes / no
Checks whether or not the company subscription status is active
Customers
List of Users
Stores the list of company’s customers
Logo
image
Stores the company logo
Name
text
Stores the company name
Next_billing_date
date
Stores the next billing date according to the company’s subscription plan
Phone_number
text
Stores the company phone number
Plan_name
Subscription
Stores the company subscription plan information
Plan_name
text
Stores the company subscription plan name
Primary_industry
Industries
Stores the industry which the company operates in
Sub_schedule_cancel
text
Stores the id of API Workflow used to resubscribe the company to the plan
Team_members
List of Users
Stores the list of employees of this company
Website
text
Store the company website link

Invitee

This object stores information about all the users invited to the platform.
Field Name
Type
Notes
company
Company
Stores the company which invited the user (invitee)
email
text
Stores the invitee email
email_sent
yes / no
Checks whether or not the invitation email has been sent
manually
yes / no
Checks whether or not the users were added manually via CSV file
name
text
Stores the full name of this invitee
type
User_Type
Stores the user type of this invitee

Message

This object stores the support ticket message (text & attachments).
Field Name
Type
Notes
New
yes / no
Determines whether or not the message is read
Picture
image
Stores the image attached to the message
Text
text
Stores the actual text message

Notification

This object will contain information regarding the notifications on the platform.
Field Name
Type
Notes
New_for
List of Users
Stores the list of users to which this notification will be new
Notification_type
Notification
Stores the notification type
Recipient
List of Users
Stores the list of users that will receive this notification
Task
Task
Stores a task related to this notification

Payment

This object stores information about subscriptions that companies pay to use the platform services without limits. It is used to show statistics in the admin dashboard.
Field Name
Type
Notes
Amount
number
Stores info about the amount of the payment
Company
Company
Stores info about the company name

Subscription

This object contains information about the subscription plans for companies.
Field Name
Type
Notes
id
number
Stores an id of Subscription plan (used on the admin_dashboard page)
idPlanStripe
text
Stores the Stripe ID of this subscription plan
Managers
number
Stores the maximum number of managers allowed on this subscription plan
Name
text
Stores name of this subscription plan
PlatformFee
number
Stores the platform fee for this subscription plan
Price
number
Stores the subscription plan price
TasksAllowed
number
Stores the maximum number of tasks allowed on this subscription plan
TeamMembers
number
Stores the maximum number of employees allowed for this subscription plan

Support_Ticket

This object stores information about the support ticket opened by the user.
Field Name
Type
Notes
Closed
yes / no
Checks whether or not the support ticker is closed
Company
Company
Stores the company this support ticket is related to
Conversation
List of Messages
Stores the list of messages from a conversation between users
Subject
Support_Subject
Stores the support ticket subject
Task
Task
Stores the task this ticket was opened from

Task

This object contains information about the tasks and requests.
Field Name
Type
Notes
AddressLine1
text
Stores information added by the customer to the Address Line 1 field
Apartment
text
Stores the apartment number
Assigned_to
User
Stores the employee assigned to the task
Charge_ID
text
Stores the charge id for the paid task (used for refund action if required)
City
text
Stores the customer’s city
Comments
List of Comments
Stores the list of comments related to this task
Company
Company
This field links the task to the company the customer was invited by
Complete
yes / no
Checks whether or not the task is completed
Country
text
Stores the customer’s country
Customer_name
text
Stores the customer’s name that created the task
Deadline
date
Stores the deadline date for this task
deadline_payment
date
Stores the date of the payment deadline for this task
Description
text
Stores the task description
Entrance
text
Stores the customer’s entrance number
Files
List of files
Stores the list of files attached to this task
Floor
text
Stores the customer’s floor number
House
text
Stores the customer’s house number
Postal_code
text
Stores the customer’s postal code
Price
number
Sores the task price (set by the manager before approval)
Special_instructions
text
Stores the additional special instructions for the task if there are any
State
text
Stores the customer’s state in case the selected option is USA
Status
Status
Stores the task status
Task_name
text
Stores the task name
Type
Task_Type
This field determines whether this object is a task or a request. The request becomes a task after the manager’s approval
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

User

Object that will contain information regarding the user.
Field Name
Type
Notes
activeCardID
text
Stores the user card ID
address
List of Addresses
Stores the user’s saved addresses
ban
yes / no
Checks whether or not the user is blocked
company
Company
Stores the company object related to this user
company_name
text
Stores the company name related to this user
first_name
text
Stores the user’s first name
full_name
text
Stores the user’s full name
last_name
text
Stores the user’s last name
phone
text
Stores the user’s phone number
Photo
image
Stores the user’s profile picture
Tasks
List of Tasks
For “Customer” user type this field stores the list of tasks created by this user. For “Staff” user type this field stores the list of tasks assigned to this user.
Tasks_count
number
Used for “Staff” user type. This field stores the number of tasks assigned to this user. Used for automatic assignment of tasks to the staff
Type
User_Type
This field stores the user type of the registered user. (Customer, Staff, Manager, Company owner or Platform admin)
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Variables

This object contains information about platform fees and the settings of the deadline for payment of tasks.
Field Name
Type
Notes
Access rights
yes / no
Stores the access rights for the demo users
App fee
number
Stores the app fee value
pay_due(hrs)
Deadline
Stores the number of hours set as task payment deadline

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.

Countries

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

CSV New Team Members

This field contains a template for loading users into the database in the CSV format
Column 1
Column 2
Column 3
Column 1
Column 3
CSV Template
This attribute contains CSV template file
It comes with a single option:
Column 1
Column 2
CSV
The CSV option to download the template file

Deadline

This option set determines the number of hours after the manager’s approval the task in which the customer has to pay
Column 1
Column 2
Column 3
value
number
This attribute contains the number of hours after the manager’s approval the task in which the customer has to pay
It comes with the following options:
12
The 12 hours deadline option.
24
The 24 hours deadline option.
48
The 48 hours deadline option.
98
The 98 hours deadline option.

Industries

This set of options contains a list of industries available on the platform.
Column 1
Column 2
1
The only option for this display set.

Navigation

This option set contains a list of items for the side navigation menu and their icons.
Field Name
Type
Notes
img
image
This attribute contains an image of the icon in the default state
imgActive
image
This attribute contains an image of the icon in the active state
imgHover
image
This attribute contains an image of the icon in the hover state
Type
List of User_Types
This attribute contains a list of user types for which the option will be displayed in the menu
The options for this set are:
Task management
The option for this set.
Overview
The option for this set.
Users
The option for this set.
Subscriptions plans
The option for this set.
Team
The option for this set.
Invitees
The option for this set.
Tickets
The option for this set.
Calendar
The option for this set.
Membership
The option for this set.
Profile
The option for this set.

Notification

This option set contain information regarding the notifications types.
Field Name
Type
Notes
Customer
text
This attribute contains the text that is displayed for the customer user type
Manager
test
This attribute contains the text that is displayed for the manager user type
Style
Notification_Style
This attribute defines the style of this notification
It comes with the following options:
Approved by manager
The option for this set.
Rejected by manager
The option for this set.
Completed
The option for this set.
Refunded
The option for this set.
Request received
The option for this set.
Declined Payment
The option for this set.
Rejected by customer
The option for this set.
Refund requested
The option for this set.
Task paid
The option for this set.
Task completed
The option for this set.
Support ticket sent
The option for this set.
Team member registered
The option for this set.

Notification_Style

This set of options determines the notification style. It comes with the built-in attribute Display.
The options for this set are:
Error
The Error option.
Informational
The Informational option.
Success
The Success option.
Warning
The Warning option.

SortByDate

This option set contains options for sorting. It comes with the following attribute:
Field Name
Type
Notes
Bool
yes / no
This attribute determines the sort order (descending or not)
The options for this set are:
Newest
Sorting by the newest in descending order
Oldest
Sorting by the oldest in ascending order

Status

This option set determines the task status. It comes with the following attribute:
Field Name
Type
Notes
Type
List of Statuses
This is an auxiliary attribute to display all statuses when the “all” is selected
The options for this set are:
Accepted
The option for this set.
Awaits payment
The option for this set.
Paid
The option for this set.
In progress
The option for this set.
Completed
The option for this set.
Rejected
The option for this set.
Request
The option for this set.
Done
The option for this set.
All
The option for this set.
Dismissed
The option for this set.
Refunded
The option for this set.

Support_Subject

This option set has a list of options that a user can choose as a subject for his message to the app’s support. It comes with the built-in attribute Display.
The options for this set are:
The job was not done
The option for this set.
The job was done not as requested
The option for this set.
Refund request
The option for this set.
Job description needs an update
The option for this set.
Other
The option for this set.

User_Type

This option set determines the user type. It comes with the following attribute:
Field Name
Type
Notes
type
List of User_Types
This is an auxiliary attribute to display all statuses when the “all” is selected
The options for this set are:
Admin
The option for this set.
Manager
The option for this set.
Customer
The option for this set.
Staff
The option for this set.
Company
The option for this set.
All
The option for this set.
💡
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 with the modification process.
In order to preview a Note of any data type or field, click on the 💬 icon.
Image without caption