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.

❗

Important: See Bubble manual information when working with data: https://manual.bubble.io/help-guides/working-with-data; https://manual.bubble.io/core-resources/data.

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

Bathrooms

This data type contains the price and time(hours) for every bathroom type.

Field Name	Type	Notes
`name`	text	Stores the bathroom type name.
`price`	number	Stores the cleaning service price.
`time(Hours)`	number	Stores the time required for cleaning.

☝

Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Booking

This data type contains all the booking information a customer would provide when the customer requests a home cleaning service. The varies from the cleaning type, duration, time and date, to personal customer information.

Field Name	Type	Notes
`address`	text	Stores the address for cleaning services.
`amount`	number	Stores the number of cleaned rooms.
`cleaningType`	text	Stores the cleaning type.
`Date of cleaning`	date	Stores the date of cleaning.
`dateOfCleaning`	text	Stores the day of cleaning.
`durationOfCleaning`	text	Stores the cleaning duration.
`email`	text	Stores the client's email.
`fee`	text	Stores the fee amount.
`message`	text	Stores the message text.
`name`	text	Stores the client name.
`noBathrooms`	text	Stores the number of bathrooms.
`noBedrooms`	text	Stores the number of bedrooms.
`numberOfVisits`	text	Stores the number of visits.
`phoneNumber`	text	Stores the client phone number.
`rooms`	`Rooms`	Stores the number of rooms.
`Status`	`Cleaning status`	Stores the cleaning request status.
`status`	text	Stores the cleaning request status.
`Time of cleaning`	date	Stores the time of cleaning.
`timeOfCleaning`	text	Stores the time of cleaning.

☝

Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Cleaning_Type

This data type contains the price and time(hours) for every cleaning type. An example of cleaning type is Standard, Standard+, or Deep.

Field Name	Type	Notes
`name`	text	Stores the cleaning type name.
`price`	number	Stores the cleaning type price.
`time`	number	Stores the cleaning type time.

FAQ

This data type contains frequently asked questions about your cleaning service company.

Field Name	Type	Notes
`answer`	text	Stores the answer to the question.
`question`	text	Stores the question.

Message

This data type contains contact messages potential customers might have for your company. It contains name, email, and message fields.

Field Name	Type	Notes
`email`	text	Stores the customer's email.
`message`	text	Stores the customer message.
`name`	text	Stores the customer name.
`phoneNumber`	text	Stores the customer phone number.

Moving

This data type contains information gotten from the moving page. Information here is used to get a moving quote for the customer.

Field Name	Type	Notes
`customer`	text	Stores the customer information.
`email`	text	Stores the customer email.
`movingInDecision`	text	Stores the customer moving decision.
`movingInLocation`	text	Stores the location.
`movingInPicture`	image	Stores the moving picture.
`movingOutDecision`	text	Stores the customer moving decision.
`movingOutLocation`	text	Stores the customer moving location.
`mobingOutPicture`	image	Stores the moving picture.
`name`	text	Stores the customer name.
`phone`	text	Stores the customer phone number.

OfficeQuote

This data type contains information gotten from the officequote page. Information in this data type helps to construct an office cleaning quote.

Field Name	Type	Notes
`additionalInformation`	text	Stores the quote additional information.
`companyAddress`	text	Stores the company address.
`companyIndustry`	text	Stores the company industry.
`companyName`	text	Stores the company name.
`companyPhone`	text	Stores the company phone.
`employeeEmail`	text	Stores the employee email.
`employeeName`		Stores the employee’s name.
`employeePhone`	text	Stores the employee’s phone.
`frequencyCleaning`	text	Stores the cleaning frequency.
`numberOfEmployees`	text	Stores the number of employees.
`squareFootage`	text	Stores the area value to be cleaned.

Register

This data type contains information on all cleaner job applicants who might want to be cleaners for your cleaning service.

Field Name	Type	Notes
`CvImage`	image	Stores the cv image.
`cvText`	text	Stores the cv text.
`daysWork`	text	Stores the day work.
`email`	text	Stores the applicant's email.
`full/partime`	text	Stores the searched work type.
`gender`	text	Stores the applicant’s gender.
`location`	text	Stores the applicant’s location.
`name`	text	Stores the applicant’s name.
`phoneNumber`	text	Stores the applicant’s phone number.
`qualification`	text	Stores the applicant’s qualification.
`workExperience`	text	Stores the applicant’s work experience.
`workPermit`	text	Stores the applicant’s work permit.

Rooms

This data type contains the price and time(hours) for every room type.

Field Name	Type	Notes
`Price`	number	Stores the room cleaning price.
`Room Name`	text	Stores the room name.
`Time(Hours)`	number	Stores the room cleaning required time.

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.

This data type contains information on the current admin of your cleaning service company.

Field Name	Type	Notes
`address`	text	Stores the user address.
`admin`	yes / no	Stores the user admin status.
`bookings`	`Booking`	Stores the booking requests.
`Image`	image	Stores the user image.
`Name`	text	Stores the user name.
`New`	yes / no	Stores the new status.
`Phone`	text	Stores the user phone.
`register`	`Register`	Stores the applicant ID
`Role`	`Role`	Stores the user role.

☝

Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.

Visits

This data type contains records of the amount of cleaning visits per booking.

Field Name	Type	Notes
`quantity`	number	Stores the quantity of visits.

Variable

This data type is used to (not) allow users to use the admin features within the app.

Field Name	Type	Notes
`writeRights`	yes / no	This field determines demo user permissions.

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.

Cleaning Status

This field holds all the options available for the cleaning request status.

It comes with the following attribute:

Option	Types
Color	text

The options for this set are:

Option	Types
In work	Stores the cleaning request status.
Rejected	Stores the cleaning request status.
Finished	Stores the cleaning request status.
Expected	Stores the cleaning request status.

Role

This field holds all the options available for roles available on the template. It comes with the default "Display" attribute.

The options for this set are:

Option	Types
Admin	Stores the user role.
Cleaner	Stores the user role.
Client	Stores the user role.

💡

Tip: To find the pages where the options sets are used, use the App Search Tool within the editor.

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.