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

Articles

This datatype stores information about articles. It comes with fields listed below:
Field Name
Type
Notes
category
List of Articles Categorieses
This field will store the category of the article.
content
text
This field will store the main content of the article.
creator
User
In this field we store the user on whose behalf the article was created.
description
text
This field will store article's description.
index
number
This field will store the article number. It is used for navigation purposes (both to the next and to the previous one). Default value - 0.
picture
image
This field stores the article preview picture.
title
text
This field stores the article title.
viewed
List of Users
This field stores the users who viewed the article.

Settings

This datatype contains information if the user is using or not the Rich Text Editor plugin by Zeroqode.
It comes with 1 field only:
Field Name
Type
Notes
Paid RTE
yes / no
This field stores the status of paid RTE plugin usage. Default value - no.

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 fields listed below:
Field Name
Type
Notes
accessrights
text
This field gives the user administrator access. To give administrator access, you must indicate "admin" in this field.
first name
text
Stores the user's first name.
last name
text
Stores the user's last name.
☝
Note: The data type has a privacy rule applied. See the πŸ’¬ in the database under the privacy section for details.

Variable

This datatype stores information about user permission to edit/delete articles.
It comes only with 1 field:
Field Name
Type
Notes
AccessRight
yes / no
Stores the user permission to edit/delete articles. Default value - yes.

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.

Articles Categories

This option set is used to set a category for a created article It has does not have any additional fields. It uses a built-in attribute to display the values.
The options for this set are:
Option
Notes
All categories
This option allows to show all categories.
Event
This option allows to show only Event category.
Development
This option allows to show only Development category.
Infographics
This option allows to show only Infographics category.
Design
This option allows to show only Design category.

Sorting Articles

This option set is used for sorting purposes, allowing to sort articles by name and time.
It comes with 2 additional fields on attributes.
Attribute
Type
Notes
Descending
yes / no
Allows to sort articles in descending order.
Sorting
text
The options for this set are:
Option
Notes
Sort by default
This option is used to display articles by default order.
Sort by name: a-z
This option is used to display articles by first letter of the article name, starting with A.
Sort by name: z-a
This option is used to display articles by first letter of the article name, starting with Z.
Recently added
This option is used to display articles by date of creation, starting with the newest one.
Oldest
This option is used to display articles by date of creation, starting with the oldest one.

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