Database Structure

Discuss
1

Our colleague Gianluca kindly sent me these codes to save this data in the firebase database.

The image shows a block-based programming script that checks if a text input is empty when a button is clicked, displaying a custom message if empty, or retrieving data from Firebase database if not. (Captioned by AI)
The image shows a block-based programming script that checks if a text input is empty when a button is clicked, displaying a custom message if empty, or retrieving data from Firebase database if not. (Captioned by AI)572×324 19.4 KB

The image shows a block-based programming script that checks if a text field is empty when a button is clicked, displaying a notification if empty or retrieving data from a Firebase database if not. (Captioned by AI)
The image shows a block-based programming script that checks if a text field is empty when a button is clicked, displaying a notification if empty or retrieving data from a Firebase database if not. (Captioned by AI)584×324 20.6 KB

The image shows a programming block that checks if a product text field is empty and displays a notification if true, otherwise it retrieves a value from Firebase Database under the tag 'Cadastro/Produto'. (Captioned by AI)
The image shows a programming block that checks if a product text field is empty and displays a notification if true, otherwise it retrieves a value from Firebase Database under the tag 'Cadastro/Produto'. (Captioned by AI)572×324 19.4 KB

A visual programming script that listens for database value changes and updates global variables and text components based on specific tags related to market registration, product, and brand information. (Captioned by AI)
A visual programming script that listens for database value changes and updates global variables and text components based on specific tags related to market registration, product, and brand information. (Captioned by AI)593×581 41.8 KB

This image shows a block-based programming interface with colourful code blocks used to check if a list is empty, display custom messages, and interact with a Firebase database and a text box component. (Captioned by AI)
This image shows a block-based programming interface with colourful code blocks used to check if a list is empty, display custom messages, and interact with a Firebase database and a text box component. (Captioned by AI)697×801 55.1 KB

Since access is now done via email and password, my structure is as follows:

image
image428×174 2.12 KB

What I want is for each user to have their own registration and then create their own budget. In this structure that Gianluca created, the data is somewhat “loose.”

Structure model:

A structured data snippet detailing a user's purchase request for rice and beans at Villefort hypermarket, including product brands, user information, and a quoted price for rice. (Captioned by AI)
A structured data snippet detailing a user's purchase request for rice and beans at Villefort hypermarket, including product brands, user information, and a quoted price for rice. (Captioned by AI)523×473 6.96 KB

2

Hi Carlos,

This was the post where I explained how to use all these blocks:
https://community.kodular.io/t/data-is-not-being-written-to-firebase/300898/4?u=rayzzz

It seems that your data structure isn’t consistent.
Inside uid, you either have a value like "xyz34" or a dictionary.

It should look like this, correct?

"users": {
  "xyz34": {
    "image": "image",
    "email": "email@email.com",
    "name": "xpto"
  }
}

If that’s the case, you would just need to add the new uid node to the GetValue and GotValue.

blocks(33)
blocks(33)513×132 7.25 KB

3

:white_check_mark: Solution

Right now, your Firebase structure is a bit loose because cadastro and orcamento are outside the user node.
If you want each user to keep their own registration and budgets, the best practice is to store everything inside the user’s UID.

Recommended Firebase structure

orcamento_compras:
  users:
    xyz34:
      image: ""
      email: "xpto@gmail.com"
      name: "xpto"
      cadastro:
        - hipermercado: "Villerfort, BH"
          produto: ["arroz", "feijão"]
          marca: ["Vilma", "Camil"]
      orcamento:
        - data_orcamento: "11/09/2025"
          hipermercado: "Villefort"
          produto: "arroz"
          marca: "Camil"
          preco: "R$ 20,00"

Why this is better

  • All user data stays under their UID.
  • Easy to fetch only that user’s info, e.g.
    orcamento_compras/users/xyz34/orcamento
  • Supports multiple users (abc12, def56) without mixing data.

In Kodular (Firebase blocks)

  • Save cadastro
    Use FirebaseDB.StoreValue
    • Tag: orcamento_compras/users/<uid>/cadastro/<unique_key>
    • Value: registration info (hipermercado, produto, marca).
  • Save orcamento
    Use FirebaseDB.StoreValue
    • Tag: orcamento_compras/users/<uid>/orcamento/<unique_key>
    • Value: budget info (date, hipermercado, produto, price).
4

In the bank it looked like this:

A screenshot of a Firebase Realtime Database JSON structure showing user purchase data with entries including supermarket, brand, product, email, and name details. (Captioned by AI)
A screenshot of a Firebase Realtime Database JSON structure showing user purchase data with entries including supermarket, brand, product, email, and name details. (Captioned by AI)1274×571 26.6 KB

On my login screen, I have: Access, Registration, and Reset Password.
In the Firebase blocks, it looks like this:

This image shows a colourful block-based programming interface, likely from an app builder like MIT App Inventor, containing blocks to store user registration data, authenticate with Firebase, and display a success message upon signup. (Captioned by AI)
This image shows a colourful block-based programming interface, likely from an app builder like MIT App Inventor, containing blocks to store user registration data, authenticate with Firebase, and display a success message upon signup. (Captioned by AI)774×994 69.7 KB

Registration screen: Hypermarkets, Products and Brands:

A visual block-based programming script that checks if three text fields are empty and either shows an alert or retrieves corresponding values from a Firebase database using user-specific tags. (Captioned by AI)
A visual block-based programming script that checks if three text fields are empty and either shows an alert or retrieves corresponding values from a Firebase database using user-specific tags. (Captioned by AI)605×660 40.9 KB

The image displays a block-based programming script for a Firebase database event handler that updates different global variables and UI components based on the value of a tag matching specific user-related paths. (Captioned by AI)
The image displays a block-based programming script for a Firebase database event handler that updates different global variables and UI components based on the value of a tag matching specific user-related paths. (Captioned by AI)507×815 52.8 KB

This image shows a block-based programming code segment designed to manage a list, check for duplicates, display custom message dialogs, and store data in Firebase Database. (Captioned by AI)
This image shows a block-based programming code segment designed to manage a list, check for duplicates, display custom message dialogs, and store data in Firebase Database. (Captioned by AI)697×801 55.1 KB

5

Thanks for sharing your blocks.

Now, what kind of problem do you face?
Explain it clearly for better understand :slight_smile: .