Baserow - Open source no-code database

Many blocks do not work

blocks
hata

PM Me i will send you.

Hello.
I have an interesting Json file.

Retrieved from Baserow Table. In this format.

[
  "Alex West",
  "Notes",
  "false",
  "bio",
  "12x",
  "CashBack",
  "Spider Web",
  "+1458645216",
  "[email protected]",
  "false",
  "22.325.00",
  "8.156",
  "320"
]

How can I correctly extract data from this?
So that in the future you can work with each element separately…


My request:
firefox_24.05 _07.01.52
After data extraction:
scrcpy_24.05 _07.01.53



And if I still use this block I get an error:
vdiMws2RfL


How to correctly extract data using such a structure JSON. ???
I couldn’t find it on the forum.

are you using this extension? Baserow - Open source no-code database
try values and use list blocks

Taifun

Yes, I will use this expansion.
I don’t need to use a list view.
I need every block in the global array.

And i use values.

So where is the problem then?

values is a list, just use list blocks to access each item of the list

Taifun

1 Like

So you want to extract all values in your json array?

1 Like

I think I solved the problem using this method…

Thanks everyone for help.

I have one more problem. With database update.

I need to load this list into the Baserow database.
But for some reason I get an error.

In the Baserow database, it should look like this.

Tell me how to do it correctly.
And I’ve been busy with this for a very long time.


update 2

I found out that the sign (double brackets) make a mistake. If you remove them, then everything works fine…
The text is not sent with double brackets.
how can this be fixed?


update 3

I decided to experiment.
I changed " to ’ then everything worked.

Another +1 problem solved.
Maybe it will help someone else in the future.
I’ll post the diagram here.
Thanks to all…

1 Like

Do not use this abandoned extension.
It is not being maintained for a long time anymore.

And which one to use?

1 Like

Yeah, which one should we use?

You can search here in the community or in the extensions directory App Inventor Extensions | Pura Vida Apps

Taifun

Thanks oseamiya its working properly

where is the Table Name component

I am able to get column but when try to create row, it is not happening. Can anyone tell, what could be the reason?

It would really help if you provided a screenshot your relevant blocks, so we can see what you are trying to do, and where the problem may be.

To get an image of your blocks, right click in the Blocks Editor and select “Download Blocks as Image”. You might want to use an image editor to crop etc. if required. Then post it here in the community.

Taifun

First I tried it was giving me the first error of json something, so I turned on the json setting in my kodular project from general. Then it was giving error of date format which I changed, but still not working. Still giving this error @Taifun @oseamiya



Is there no one who can tell why is it giving me 2nd error and how can I fix it

1st error message: don’t use \ as seperator
2nd error message change the date format to YYYY-MM-DD

Taifun

1 Like