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.

❕

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

Message

This data type is used to display the messages under each project.

• messageBody - text - Holds the content of a message.

• messagePicture - image - Holds pictures related to a message.

Project

This data type is used to display project-related information.

• projectArchive - yes / no - Marks a project as archived.

• projectDescription - image - Hold the first part of the description of a project.

• projectDescriptionProposal - text - Hold the second part of the description of a project.

• projectFiles - List of Files - Stores files related to a project.

• projectMessages - List of Messages - Stores messages related to a project.

• projectStaff - User - Determines the staff of the project.

• projectStatus - ProjectStatus - Holds a project status.

• projectTitle - text - Store the project title.

• projectType - ProjectType - Determines the type of a project.

• projectWordCount - number - Determines the word count for a project.

Testimonial

This data type is used to display testimonial messages.

• body - text - Testimonial content will be stored here.

• creator - text - This will store the testimonial creator.

• Creator_position - text - This will store the position that the creator occupies.

• Picture - image - This will store the picture of the testimonial, if there is any.

User

This data type is used to display the user-related data.

• TotalActiveProjects - number - Total number of active project for this user.

• userFullName - text - User's full name.

• userNextBillingPeriod - date - User next billing period for his subscription.

• userPhoto - image - Contains user pic.

• userProjects - List of Projects - Contains a list of projects that are related to this user.

• userSubscriptionActive - yes / no - Determines wether user has an active subscription at the moment.

• userSubscriptionCancel - yes / no - Determines wether user canceled his subscription.

• userType - UserType - Determines the user type.

Variable

This data type holds information about variables that can be changed by the platform owner.

• Access_rights - yes / no - Determines wether demo user has rights to change the platform content.

• TotalActiveProjects - number - Stores the number of possible active projects.

• TotalArchiveProjects - number - Stores the number of archived projects.

Variables

As described before this datatype object contains parameters used to speed up the system. If you want to delete it or modify it you should know that this object is linked to some workflows that will need to be modified too.

• On the dashboard page find groups Project Archive Wrap and Project Submit Wrap and check the workflows related to them. There we are making changes to the Variable object.

• On the API Workflows page find the go archive endpoint where we also are making changes to Variable object.

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.

ProjectStatus

The option set is used to store types of project statuses. It comes with one attribute:

• display - text - Stores the status for the project.

The options for this set are:

• Assigned - Project assigned.

• Submitted - Project submitted.

• Draft - Project draft.

• Completed - Project completed.

• Delivered - Project delivered.

ProjectType

The option set is used to determine the type of the project. It comes with one attribute:

• display - text - Stores the project type.

The options for this set are:

• Quora Answer - Quora Answer option.

• Video Script - Video Script option.

• Twitter Tweet - Twitter Tweet option.

• Facebook Post - Facebook Post option.

• Press Release - Press Release option.

• Product Description - Product Description option.

• E-mail Newsletter - E-mail Newsletter option.

• Blog Post - Blog Post option.

UserType

The option set is used to determine the user type. It comes with one attribute:

• display - text - Stores the user type.

The options for this set are:

• Admin - Admin option.

• Staff - Staff option.

• Customer - Customer option.

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 with the modification process.

In order to preview a Note of any data type or field, click on the 💬 icon.