Baserow - Open source no-code database

[oseamiya]

You can use GetAllRows or GetColumn method with page more than 1 and size less than or equal to 200. For example, If you use page 2 and size 200 then you will get rows starting from 201 to 601.

[oseamiya]

Which version of the extension are you using ? How many rows of data do you have in your table ? As replied by @Prem1 , I am not getting this error too.

[Ammaraldewani]

Thank YOU

[oseamiya]

You can also use GetAllRowsmethod to get all the column at once.

For example, if my table is something like this :

I can use values (which contains list of rows and each rows contains list of item) from GetAllRows and do like this :

Internally inside program GetColumn method use similar idea to fetch a particular column for you. That’s why I always suggest users to use GetAllRows method than GetColumn. That will help you to get all the column you need quickly and it save more responses.

[Ammaraldewani]

Why when get all rows application stop running , how to fix ?

[alrmailay (Romil)]

Can you add something like that instead of fetching all the columns

@iamwsumit

Get Columns block has updated now and it is able to fetch multiple columns at a time. Pass the list of columns names to columns Names parameter and Got Columns event will be triggered with all list of values in a list.

[oseamiya]

When you fetch 16000 data directly then it will take 16000/200 = 80 responses time to get all data completely. Why are you fetching these no. of data at a time? Fetch data one by one as I replied here.

Also, What are you going to do with these much of data ? If you wanted to perform search operation or do any filters, you can use Filter block and send filter request to server than actually performing on the application.

If possible, you can send me aia.

[oseamiya]

Why not use this method to get column you need @alrmailay ? Its just couple of blocks more.

Baserow - Open source no-code database

You can also use GetAllRowsmethod to get all the column at once. For example, if my table is something like this : [image] I can use values (which contains list of rows and each rows contains list of item) from GetAllRows and do like this : [image] Internally inside program GetColumn method use similar idea to fetch a particular column for you. That’s why I always suggest users to use GetAllRows method than GetColumn. That will help you to get all the column you need quickly and it sav…

[Ammaraldewani]

Ok i will send you the aia and i want to help me if you can

[taqy (Mohammed taqy)]

Hi , can you add (Creat column) on your extension if you add this feature will help me alot .

[oseamiya]

I am testing different admin features for the next update. It will be available soon.

(Edit)
Succesfully tested

[taqy (Mohammed taqy)]

thank you so much , you such a great coder ever

[Ammaraldewani]

Please in next update
Add this block : - get table namd ID
Because sometimes I want to make a logic structure

If get baserow table name id - math = true
set call get all rows…

[rashidcsm_ctg (Rashidul Alam)]

No Data is coming in the 2nd variable. Is there anything wrong with this block

[oseamiya]

Try with latest version of the extension.

[oseamiya]

To anyone waiting for this update, My laptop is broken & being repaired in service center. So i am unable to provide the extension any sooner.

[rashidcsm_ctg (Rashidul Alam)]

I use the extension version 4.1

[oseamiya]

I don’t have a proper device to check the issue for now…
Can anyone test and verify the issue??

You can use this method to get column for now…

Baserow - Open source no-code database

You can also use GetAllRowsmethod to get all the column at once. For example, if my table is something like this : [image] I can use values (which contains list of rows and each rows contains list of item) from GetAllRows and do like this : [image] Internally inside program GetColumn method use similar idea to fetch a particular column for you. That’s why I always suggest users to use GetAllRows method than GetColumn. That will help you to get all the column you need quickly and it sav…

[rashidcsm_ctg (Rashidul Alam)]

Problem Solved. Thank you

[Rindao_Narzary (RNarzary)]

No more working in my project Baserow