Forum Documentation Showcase Pricing Learn more

Explanation on Database Field Type (Field Name)


#1

Dear Bubblers,
I am still trying to get my hands dirty with bubble.
I know a little bit of database (sql).
I am having issues understanding some concepts in Bubble.
I know data types are usually text, integer, float, string, etc.

But in Bubble you can have data type (User) or data type(Product).

In implementation how does this work? How can I make changes to it?

image


#2

Hi,

I’d recommend watching the Bubble introductory tutorial videos. They explain DB practices really well…


#3

@bosunjohnson Also checkout a getting started webinar on using the database


#4

Thanks I have gone through the introductory videos.


#5

Thanks I’ll go through that now.


#6

Hello @neerja, I have go through the webinar. Thanks.

But it does not address my question.

See this example, I create a new database(products). I have a field in the product database called Owner. The datatype of Owner is User. That is Owner(User).

How can I work with this type of datatype Owner(User) in terms of retrieving data or add data.
Or how does it work generally? @NigelG


#7

In creating or making a change to a Product record, you’d set the Owner field to a value that is type User. For example:

Owner = Current User

or Owner = Current cell’s User if you’re workflow is coming from within a repeating group element on the page that is set up to retrieve a list of Users

or Owner = Search for Users :first item if you want to retrieve a specific user from the database

This “link” would allow you to create expressions like “Product’s Owner’s email address”

Hope that helps.


Gaby at Coaching No Code Apps (formerly Coaching Bubble)

Courses & Products, Tutorials, Private Coaching, and High-level Development

Start Learning Today :mortar_board:


#8

Thanks.