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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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:

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.
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.
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:
Column 1
Column 2
Column 3
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:
Column 1
Column 2
Column 3
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:
Column 1
Column 2
Column 3
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

Helpful?