Populating the spinner with database data

Discuss
1

Can anyone help me?
I have this Firebase registration:

A screenshot of a Firebase real-time database structure showing a shopping list with entries for supermarket "Villefort", brand "Camil", and product "Arroz" under the node "orcamento_compras." (Captioned by AI)
A screenshot of a Firebase real-time database structure showing a shopping list with entries for supermarket "Villefort", brand "Camil", and product "Arroz" under the node "orcamento_compras." (Captioned by AI)840×341 11.8 KB

I’m using the web component to get all the data from the Hypermarkets, Products, and Brands list and then populate the spinners.

image
image1102×205 13.8 KB

image
image1421×241 34.7 KB

blocks(14)
blocks(14)759×970 86.3 KB

But it’s giving an error, and I don’t even know what the error is.

image
image1736×452 68.5 KB

2

For now I don’t know where we’re going but when the clouds meets too much it’s where the rain falls, but I it’s feels like something bad can happen here,

I reported it, after the update takes place, boom :collision: new bug appears, but Kodular why?

If you’re creating a project makes sure not errors are in your code, else you won’t debug, this error cover all wrong places in the coed

I recently created a post, ask to Kodular, guess what I, 4 hours pending

A letter from Kodiak Team expressing gratitude to developers for using Kodiak as a platform for mobile app development and cloud scaling, highlighting its advantages and inviting feedback. (Captioned by AI)
A letter from Kodiak Team expressing gratitude to developers for using Kodiak as a platform for mobile app development and cloud scaling, highlighting its advantages and inviting feedback. (Captioned by AI)1080×2400 178 KB

The image is a screenshot of a webpage discussing issues with the Kodi platform, including broken components, user frustrations, and user requests for improved quality control and content availability. (Captioned by AI)
The image is a screenshot of a webpage discussing issues with the Kodi platform, including broken components, user frustrations, and user requests for improved quality control and content availability. (Captioned by AI)1080×2400 160 KB

The image shows an email discussing prioritizing stability in subscription platform development and includes a closing note from Ibrahim Jamil. (Captioned by AI)
The image shows an email discussing prioritizing stability in subscription platform development and includes a closing note from Ibrahim Jamil. (Captioned by AI)1080×2400 308 KB

3

Hi Carlos,

Try this,
blocks(49)

{{“key1”:“value1”}, {“key2”:“value2”}} after decode will be ((key1 value1) (key2 value2)) you need a list of pairs to dictionary to bring back to a readable format

4

It keeps giving an error. The error message appears so quickly that I can’t read it all.
Can you show me what else is missing?
I saw in the discussion about this error message that it’s a Kodular update. The problem is that the messages that appeared were fixed, so we knew where to attack. Now they appear very quickly and then this gigantic one appears that crashes everything.
Has anyone reported this to Kodular support?

The image shows a block-based visual programming code interface with colourful nested blocks, including loops, conditions, and list operations related to managing and manipulating dictionaries, keys, and lists for some form of JSON data processing. (Captioned by AI)
The image shows a block-based visual programming code interface with colourful nested blocks, including loops, conditions, and list operations related to managing and manipulating dictionaries, keys, and lists for some form of JSON data processing. (Captioned by AI)865×970 86.2 KB

5

Will the data be structured in this way?

immagine
immagine296×268 4.77 KB

6

Bucket contains

"Cadastro":{
  "Hipermercados":"Villefort",
  "Marcas":"Camil",
  "Produtos":"Arroz"
}

and you’re trying to
blocks(51)

To do this the bucket must be orcamento_compras

Let’s see if this picture can help

immagine
immagine1216×532 26.3 KB

7

I changed the bucket:

A visual programming interface displaying blocks of code related to processing JSON text, setting global variables, and walking a list by key path within dictionaries or lists. (Captioned by AI)
A visual programming interface displaying blocks of code related to processing JSON text, setting global variables, and walking a list by key path within dictionaries or lists. (Captioned by AI)1362×480 67.8 KB

But the error remains:

A mobile app interface in Portuguese showing dropdown menus and input fields for selecting a supermarket, product, and product brand, with a text input for entering the product value, alongside error message partially visible on the screen. (Captioned by AI)
A mobile app interface in Portuguese showing dropdown menus and input fields for selecting a supermarket, product, and product brand, with a text input for entering the product value, alongside error message partially visible on the screen. (Captioned by AI)296×606 25.7 KB

I’ll put the Aia on to see if you can check what’s going on.
orcamento_compras.aia (143.8 KB)

8

:warning: Always remove the API keys before putting your project online :warning:

Why are you using both the Firebase and Web components? :grinning_face_with_smiling_eyes:
You can do everything with just one.

To fix your project,

  • I simply specified the bucket in the URL /orcamento_compras.json
    https://FIREBASE_PROJECT_ID.firebaseio.com/orcamento_compras.json

  • Global res replaces your bucket variable, which is no longer needed.

  • To replace the characters, it’s enough to specify just one ".

orcamento_compras.aia (143.9 KB)

Change your API key immediately :grin:!

Happy :kodular:oding!

9

Go to this website, it’s really well made and it will clear up any doubts you might have (by using the webComponent you can also save data without those annoying quotes and even implement authentication).
The only downside is that you don’t have the .DataChanged block.

10

I had forgotten about this here:

A block-based programming script that initializes a web component with a URL formed by joining a base Firebase URL and a JSON file path, then calls a web request and sets a global variable to an empty list. (Captioned by AI)
A block-based programming script that initializes a web component with a URL formed by joining a base Firebase URL and a JSON file path, then calls a web request and sets a global variable to an empty list. (Captioned by AI)1148×267 22.3 KB

Thanks

1 Like
11

Is everything working?
If so, very good :partying_face:

Happy :kodular:oding!!!

12

It’s working when I’ve already registered items for supermarkets, products, and brands.
When nothing is registered, it displays an error.
I deleted the Firebase database and created a new one.
Is there a way to fix this?

A browser window displays a JSON file URL with a checkbox labeled "Estilos de formatação" and the text "null" underneath. (Captioned by AI)
A browser window displays a JSON file URL with a checkbox labeled "Estilos de formatação" and the text "null" underneath. (Captioned by AI)1053×168 10.3 KB

The list is probably empty.
I use the web component for postal code retrieval. I use two response codes: 200 when the data is found and 400 when it is not found.

A mobile app interface in Portuguese prompting the user to select a hypermarket, product, product brand, and enter the product's value, with dropdown menus and input fields visible. (Captioned by AI)
A mobile app interface in Portuguese prompting the user to select a hypermarket, product, product brand, and enter the product's value, with dropdown menus and input fields visible. (Captioned by AI)284×604 37.8 KB

13

Aggressive, but it works :rofl:

Add a condition so that the functions are executed only if the response has code 200 and is different from “null”.

14

Your request url is wromg. It should end with /.json and not along with the bucket. json?

It should be firebase_url/bucket/.json?

16

Can you show us how you solved it? It could be useful for anyone who encountered the same problem.