Baserow - Open source no-code database

[Arpan_Chakraborty]

Can I create unlimited rows and columns? Or are there some limitations? I know this is a stupid question as this is open source but…

[UnknownMan541 (Shubhanshu Jaiswal)]

You can create unlimited rows but you cannot call all rows at once , @oseamiya gave a trick

@oseamiya

I think 200 rows/size can be retrieve only on page. So if you wanted to retrieve 400 datas then you might have to send page number to 2. I’ve never tested it though. I’ll test it & update result here

[oseamiya]

@oseamiya

You can create unlimited number of rows in baserow aswell you can fetch as many row you need.

For example, if you have 456 rows in a single column named Name then you can fetch first 200 datas from page 1 and second 200 from page 2 and remaining from page 3 .
If your page is invalid then it will raise the event OnErrror with page invalid message.

You can use logic like this to fetch rows maximum than 200 .

-------Updated------------

No need of this if you are using version 3.1 or above. The extension will itself handle the situation when you are trying to get rows more than 200.

[UnknownMan541 (Shubhanshu Jaiswal)]

Sorry @oseamiya

[oseamiya]

This extension is now available at GetAix. You can download this extension from GetAix too

Extension Baserow | Free

[sherif (Sherif Hassan)]

Despite its ease of use and many advantages
Saving list in a list, for example ((a b c) (d e f )) is very difficult in baserow database

[oseamiya]

Is this solution is not working ?

Baserow - Open source no-code database

Yeah, I found that whenever we send JSON as a cell-data, it is triggering the error occured event. A temporary solution can be using zero-width space character. Copy from this website : ​ - Zero Width Space: U+200B - Unicode Character Table (unicode-table.com) [image] What i did here is copied zero width space from the website i mentioned and then rather than sending the lists, i sent datas as String separated by that zeroWidthSpace . Or use this extension which use same method as above b…

Soon, When i will be free enough, I will go through the issue & try to add a solution within extension !

[iamwsumit (Sumit Kumar)]

@sherif

for example ((a b c) (d e f )) is very difficult in baserow database

Maybe, it works if you store the lists in encoded form.

Then after retrieving decode the value back.

Or there is another way. Convert your list into csv text and store them.

The after retrieving convert the csv to list back.
I have not tried to store it in baserow so I am not sure it will work but it should work.
You should try it once.

[Still-learning (1-2-3-4...)]

Why don’t he use for each item block

For each item list
Add items to the list (list 1)
Item (make a list - get item)

This also will convert into json list like

In spreadsheet extension i am trying the same

[oseamiya]

Using Json is giving error. Its because extension have to send Json included Json, so getting error from server.
Threads :-

Baserow - Open source no-code database

Updated @sherif , I’ve updated ListToJson extension and added two more methods so that it will be easy for you to parse to JsonRepresentation and decode the JsonRepresentation too. ListToJson.aix (5.1 KB) [image] Java code used : @SimpleFunction public String ParseJsonFromList(YailList items){ return items.toJSONString(); } @SimpleFunction public String GetJsonRepresentation(Object value){ return JsonUtil.getJsonRepresentation(value); } @Sim…

Baserow - Open source no-code database

[{D1D0842A-CB14-4760-BE63-B7D62FDFFF04}.png] [{1F894906-CB92-49CC-93AA-5469F38DF90D}.png] There is an error saving JSON format in Baserow table

[Sg00 (Professional Developer)]

Why i am not getting data from baserow.i checked api or table id everything right but not get data from baserow

[oseamiya]

GetAllRows method will trigger GotAllRows event not GotRow event. Read the documentation clearly.

Also, you can use OnError event to get any error.

[Sg00 (Professional Developer)]

I am not getting any error

[oseamiya]

@oseamiya

GetAllRows method will trigger GotAllRows event not GotRow event. Read the documentation clearly.

GetRow method will trigger GotRow event.

[Sg00 (Professional Developer)]

Thanks @oseamiya that’s my mistake now my problem is solved. I read the documentation already but i forgot gotallrow event. Thanks​

[AJOY_DAS]

I was using this extension in my current project. But I am having some questions.

1. How to get the row number of the last row i created ?
2. How to get the rows of several IDs at once. If It contains a value like this: 1, 3, 6, 11 then it will call 1, 3, 6, 11 rows at once. Is it possible? If possible the can anyone kindly guide me ?

Thanks in advance.

[oseamiya]

@AJOY_DAS

How to get the row number of the last row i created ?

This example will get last row Id, It works for more than 200 rows too.

@AJOY_DAS

If It contains a value like this: 1, 3, 6, 11 then it will call 1, 3, 6, 11 rows at once. Is it possible? If possible the can anyone kindly guide me ?

You can get all the rows using GetAllRows method either or you can fetch rows single row from GetRow method.

[AJOY_DAS]

@oseamiya

You can get all the rows using GetAllRows method either or you can fetch rows single row from GetRow method.

Can i get rows more than 200 at once with get all rows method without error ?

[UnknownMan541 (Shubhanshu Jaiswal)]

Won’t you scroll up and see

Baserow - Open source no-code database

You can create unlimited number of rows in baserow aswell you can fetch as many row you need. For example, if you have 456 rows in a single column named Name then you can fetch first 200 datas from page 1 and second 200 from page 2 and remaining from page 3 . If your page is invalid then it will raise the event OnErrror with page invalid message. You can use logic something like this to get all the rows from baserow. [blocks (2)] Here, all the list of datas/rows of column name Name is st…

[AJOY_DAS]

As I can see, here he used Get Column block. Not GET ALL ROWS block. So, i was just asking him because i don’t know how this works. i am used to airtable and we can call infinte rows at once there.

@UnknownMan541

Won’t you scroll up and see

@AJOY_DAS

Can i get rows more than 200 at once with get all rows method without error ?

I knew that you I can’t call more than 200 rows while getting a column because I DID scroll through the entire post. Also i watched a Youtube video where he was calling all rows using GET ALL ROWS block. So, I got confusion. Because you know… all youtube videos aren’t correct always.
But thanks @UnknownMan541 for replying to my comment.