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 manualConversation
The
conversation
datatype stores information about all the conversations (personal chats).It comes with fields listed below:
Field Name | Type | Notes |
Favorite | yes / no | This data type specifies whether the conversation was pinned (favorite or added to the top) by the user or not.
The default value is set to no. |
Last_message | Message | This data type stores the information about the last message sent within a conversation. We show its preview in a repeating group at the sidebar on the left. |
Members | List of Users | This data type stores information about both members of the chat. |
Messages | List of Messages | This data type stores all the messages within this conversation (chat). |
Name_chat_partner | text | This data type stores the name of the chat partner within a private conversation (chat). |
Name_creator | text | This data type contains the name of the private chat creator. |
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.
Message
The
message
datatype contains information about the messages exchanged between the users within a chat.It comes with fields listed below:
Field Name | Type | Notes |
Conversation | Conversation | This field contains information about all the messages within a conversation (chat) |
edited ? | yes / no | This specifies whether the massage was edited or not (Default value is set to no ) |
Message_file | file | This data type stores the file sent within the conversation |
Message_GIF | image | This field stores the GIF image sent within the conversation. |
Message_image | image | This field stores the image sent within the conversation. |
Message_reply | Message | This field stores the message containing the reply |
Message_text | text | This field stores the text of the message(s) exchanged by the users within the conversation |
Read | List of Users | This field stores the list of users who have read a certain message.
When the message is read, it's marked by ✓✓. |
Search_text | text | This field stores the information about all the messages within the conversation. It's used for search within the conversation (chat) |
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. To learn more, see the Bubble manual.
It comes with fields listed below:
Field Name | Type | Notes |
Avatar | image | This field stores information about the user's avatar |
Avatar_color | text | This field stores information about the color of the placeholder avatar. It is used in case the user has not added the avatar. By default it is white |
Bio | text | This field contains information about user's bio (text description). It contains 100 symbols max. |
Conversation | List of Conversations | This field contains information about all user's private conversations. |
Current_conversation | Conversation | This field contains information about the current (last) conversation the user is in |
Favorite_conversation | List of Conversations | This data type contains information about conversations pinned by the user. |
First_name | text | This field contains the user first name |
Gif_sent | List of Search Endpoints Gifs datas | This field contains information about the gif(s) the user has sent. |
Phone_number | text | This field contains information about the user's phone number |
Search_field | text | This field stores the information about all the messages within the conversation. It's used for search within the conversation (chat) |
Theme | Themes | Users can set different themes for individual chats.
This field stores the information about the chat color theme. It's set on the signup and can be changed later by the user |
Note: The data type has a privacy rule applied. See the 💬 in the database under the privacy section for details.
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.
Colors
This option set is used for setting a color for the placeholder avatar in case the user has not added an image as an avatar. It’s set on signup.
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 |
#320E3B | This option contains mainly BLUE color. |
#2B2D42 | This option contains mainly BLUE color |
#B56576 | This option contains mainly RED color. |
#CE84AD | This option contains mainly RED color. |
#3D2B56 | This option contains mainly BLUE color. |
#EEA243 | This option contains mainly RED color. |
#283D3B | This option contains mainly GABLE GREEN color. |
Group Menu
This option set contains chat menu items.
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 |
Chat information | This option is used to display the chat information. |
Packs Menu
This option set is used Gifs & Emojis menu.
It comes with just one field:
Attribute | Type | Notes |
icon | text | This option is used for the GIF & emojis menu icon. |
The options for this set are:
Option | Notes |
GIF | This option contains GIF menu item. |
Emoji | This option contains Emoji menu item. |
Add_stickers | This option contains Add Stickers menu item. |
Skin
Users can set different themes for individual chats. Each theme contains skins that as well customize the appearance of the chat. This option set contains information on chat skins.
It comes with fields listed below:
Attribute | Type | Notes |
action_message_color | text | This is used for action messages color (when somebody leaves the chat). |
Color_primary | text | This is a primary color applied to the text & icons. |
Hovered | text | This is used for the messages text color on the hover. |
mess_color_current_user | text | This is used as color for current user messages. |
mess_font_color_current_user | text | This is used for the font color of current user messages. |
The options for this set are:
Option | Types |
Blue | This option is used for blue skin. |
Purple | This option is used for purple skin color. |
Navy | This option is used for navy skin color. |
Gold | This is used for gold skin color. |
Themes
This options set is used to store themes.
It comes with fields listed below:
Attribute | Type | Notes |
Answer_bg | Answer_bg | This option is for the background of the user's answer. |
Answer_text_color | text | This option is for text color used in the user's answer. |
Chat_bg | text | This option is for the chat background color. |
Cover | text | This option is used for selecting the current chat and inputs cover. |
Sidebar_bg | text | This option is for sidebar background color. |
Skin | Skin | This option is for the default skin color. |
The options for this set are:
Option | Types |
Day | This option is used for the day mode. |
Night | This option is used for the night mode. |
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.