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.Conversation
This data type stores information about the conversation between admin and user sending his inquiry.
Field Name | Type | Notes |
messages | List of messages | This field stores messages related to a conversation. |
users | List of Users | This field stores users related to a conversation. |
Drafts
This data type stores drafts of posts made by users.
Field Name | Type | Notes |
content1 | text | Stores text of the draft. |
content2 | text | Stores text of draft of thread message. |
date | date | Stores the date when draft was made. |
image1 | image | Stores the image inside the image post. |
image2 | image | Stores the image inside the image thread post. |
posted | yes / no | Specifies if the post was published or not, used as display filtering option for RG. |
social | Social | Stores the name of SM where the draft will be posted. |
thread | yes / no | Specifies if the post contains a thread. |
type | text | Specifies the type of the post (text, image or video). |
video1 | file | Stores the information about the video inside the video post. |
video2 | file | Stores the information about the video inside the video thread post. |
MenuTab
This data type stores information about tabs names available on the mobile version
Field Name | Type | Notes |
name | text | Stores the names of tab categories. |
number | number | Stores the tab order number. |
Message
Stores information about the message within a conversation between the admin and the user.
Field Name | Type | Notes |
content | text | Contains the text of the message. |
conversation | Conversation | Stores information about the conversation of the admin with the user. |
guest | yes / no | Specifies if the conversation implies a guest user. |
guestName | text | Stores the name of the guest user who sent the message. |
new | yes / no | Specifies if the message is new. |
reply | text | Contains the reply to the message. |
user_email | text | Contains the email of the user who sent the. message. |
Post
Stores information about the post text.
Field Name | Type | Notes |
cancelScheduleAPI | text | Stores the publication ID, to be used for editing or publication. |
content1 | text | Stores the taxt of the post |
content2 | text | Stores the information about the text inside the text thread post. |
date | date | Stores the date when the post was published. |
draft | Drafts | Stores information about the post Draft. |
image1 | image | Stores the information about the image inside the image post. |
image2 | image | Stores the information about the image inside the image thread post. |
posted | yes / no | Specifies if the post was published or not. |
publishing | yes / no | Value publishing = yes is used as a display condition for "publishing ..." text, when a post is created.
|
social | Social | Stores the SM where the post will be published. |
thread | yes / no | Specifies if the post contains a thread. |
type | text | Specifies the type of the post (text, image, video). |
video1 | file | Stores the video inside the video post. |
video2 | file | Stores the video inside the video thread post. |
Posting_Day
Stores information about the date when post is scheduled for posting.
Field Name | Type | Notes |
day_number | text | Stores information about the week date number of the publishing date. |
day_text | text | Stores information about the week day of the publishing date. |
posting_times | List of dates | Stores information about the time for the scheduled publishing. |
Posting_Schedule
Stores information about the posting schedule.
Field Name | Type | Notes |
Posting_days | List of Posting_days | Stores information about the posting days that a posting schedule includes. |
Social
Social contains within itself information about the connected social media on both the front and backend part of the app.
Field Name | Type | Notes |
picture | image | Contains social media's logo |
posting | Posting_Schedule | Stores information about the posting schedule for this SM. |
posts | List of posts | Stores information about the list of posts for this SM. |
social | text | Stores the name of the SM. |
socialConst | socialConst | Contains the name of the SM. |
socialType | socialConstType | Specifies the type of SM used (for test purposes we added Twitter, FB and Linkedin, but just Twitter is configured.) |
timeZone | timeZone | Stores information about the time zone used for publishing posts. |
twitter_oAuth | text | It allows an authorized Twitter developer App to access private account information or perform a Twitter action on behalf of a Twitter account. |
twitter_oAuth_secret | text | Stores information about Twitter access token. An access token and access token secret are user-specific credentials used to authenticate OAuth 1.0a API requests. They specify the Twitter account the request is made on behalf of. |
twitterBanner | image | Stores Twitter banner image. |
user | User | This field is used to separate the current user from other users, as everywhere is it used the Current user value. |
username | text | Contains information about the username used for this SM. |
SocialMedia
Stores information about the social media connected.
Field Name | Type | Notes |
icon | image | Stores information about the icon of the social media connected. |
soon | yes / no | Specifies if the SM is has a "coming soon" icon. |
title | text | Stores information about the title of the social media connected. |
Subscription
Stores information about user's subscription to the platform.
Field Name | Type | Notes |
canceledByAdminDate | date | This stores information about the date of user's subscription cancellation by the admin. |
stripeSubscription | Stripe Subscription | This stores information about the Stripe ID of the user's subscriptions. |
SubscriptionActive | yes / no | Specifies if thee subscription is currently active. |
SubscriptionCanceled | yes / no | Specifies if thee subscription is currently cancelled. |
SubscriptionID | text | Stores to the subscription ID. |
SubscriptionNextBilling | date | Stores the next date of subscription billing. |
SubscriptionPlanName | text | Stores the name of the Subscription (Plan). |
Token
This data type is used for the Twitter API call setup.
Field Name | Type | Notes |
data | text | Stores the token required for Twitter API call. |
User
Stores information about platform users.
Field Name | Type | Notes |
admin | yes / no | Specifies if the user has admin rights. |
currentSocial | Social | Specifies currently used SM. |
currentSocialMedia | socialMedia | Stores the name of the most recently added SM. |
email | text | Contain user's email. |
name | text | Contain user's name. |
picture | image | Stores user's avatar. |
posts | List of posts | Contains information about posts published by the user. |
socialsList | List of Socials | Stores the number of social accounts. |
subscription | Subscription | Stores information about the current subscription of the user. |
trialStarted | date | Specifies the date when trial subscription was started. |
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.
SocialConstType
This option set is used for choosing between registered social networks.
Attribute | Type | Notes |
logo | image | Stores the Social Media logo. |
soon | yes / no | Stores the status of SM in the template (already added or not). |
The options for this set are:
Option | Notes |
Twitter | Twitter option. |
Facebook | Facebook option. |
Instagram | Instagram option. |
LinkedIn | LinkedIn option. |
TimeZone
This option set is used for timezone setup.
Attribute | Type | Notes |
hour | number | Stores the hour. |
seconds | number | Stores seconds. |
The options for this set are:
Option | Notes |
Local time zone | Local time zone selection |
+14:00 | An option. |
+13:45 | An option. |
+13:00 | An option. |
+12:00 | An option. |
+11:00 | An option. |
+10:30 | An option. |
+10:00 | An option. |
+9:30 | An option. |
+9:00 | An option. |
+8:45 | An option. |
+8:00 | An option. |
+7:00 | An option. |
+6:30 | An option. |
+6:00 | An option. |
+5:45 | An option. |
+5:30 | An option. |
+5:00 | An option. |
+4:30 | An option. |
+4:00 | An option. |
+3:30 | An option. |
+3:00 | An option. |
+2:00 | An option. |
+1:00 | An option. |
-1:00 | An option. |
-2:00 | An option. |
-3:00 | An option. |
-3:30 | An option. |
-4:00 | An option. |
-5:00 | An option. |
-6:00 | An option. |
-7:00 | An option. |
-8:00 | An option. |
-9:00 | An option. |
-9:30 | An option. |
-10:00 | An option. |
-11:00 | An option. |
-12:00 | An option. |
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.
