[FREE] KevinkunAirtable extension

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

Runtime error
Expected a number for an index, but got “Column1” instead.
Note: You will not see another error reported for 5 seconds.

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

is this working for you with this extension?

[Taifun]

@Kuldeep_Pilania

Expected a number for an index, but got “Column1” instead.

It would really help if you provided a screenshot of 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

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

is this works?

[Kevinkun]

why not try by yourself?

[Abhishek_Rawat]

i stuck in how to filter records … i try allot but i am not getting any solution

i have all this records in my table

And I want this extension fetch only those record in which , column (Tittle) having Cp3 value

like this

So I try this Formula But it Fetching all records

“Where[Tittle] [contains] [Cp3]”
and this formula not working i am getting this result

It fetching All records so what wrong I am doing in filter Section

[dora_paz (Dora)]

Use filter Tittle="cp32"

[Kevinkun]

or try to use
FIND("Cp3",{Title})>0
as filter, which means if Title column contains ‘Cp3’

[Kevinkun]

useful function that can be used in filter:

Summary

[drpeterramsis2007 (Peter Salib)]

I can’t download the extension … the website is not opening or working?
any help in that

[Kevinkun]

The website is working, pls try again.

[drpeterramsis2007 (Peter Salib)]

I checked again and it works …

is there away to check if the any data in the table was modifed even the number of rows arenot changed … without getting all the coloumns … and if there any change so start to grab the whole data from the table?

[Kevinkun]

With Baserow it’s possible.

[FREE] Baserow Socket Extension - An Extension for real-time collaboration with Baserow

[icon] Baserow Socket Hello Everyone, I am here again with my new extension that is Baserow Socket. This extension helps you to use Baserow websocket API for realtime collaborations in your apps. It is same as firebase real-time database. This extension notify you all changes that are making in your database. There are some specific events for specific changes. You can receive all update of a table after subscribing it. Let see its blocks and their documentation. All Blocks [blocks (1)] …

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

@drpeterramsis2007

without getting all the coloumns

I hope this is possible with Google sheet

With the help of function Onedit script.

[amitontheweb (Amit Sharma)]

Hello Kevin,

Thank you for the excellent extension. I have a little problem with the filter - when I use a string in a text field, it works. But when I try to join several text fields to create a string, then the filter doesn’t work.

Here are the blocks for your reference:

Works:

Doesn’t work:

There is no error message, but the filter either does not return results, or the filtering code is not effective in filtering, and all records get fetched.

The Join method works if the second variable (filterby_subcategory) is given as a text string, but not when it is kept as a variable.

Looks like at least one of the inputs in the filter equation needs to be a text string, both can’t be kept as variables.

Kindly help.

As a workaround, I have made the filters required and stored them in a list, and I then fetch them in the filter field as per the case required.

Thank you.

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

@amitontheweb

As a workaround, I have made the filters

In that case, click the do it button in both blocks and compare what is missing…

[amitontheweb (Amit Sharma)]

Apologies, the join block is working! There was no relevant row to fetch, so blank rows were being shown, and I mistook that for a flaw.

Here is the filter block that works just as it should:

My query can considered as resolved.

[Sooraj_Aniyeri]

Can i add new data to table top using this??

[NY_ERINING]

i have buy premium airtebal subscription one table 50000 row provide me so im use user extension so what entr page size ? 100 Ya 50000

[Satvik1 (Satvik)]

Hello @kevinkun your extension is very good. I have a small suggestion for you, you can add a block wich can create field (coloum) in airtable database. I think it will help people to create direct fields without going in airtable, ya i know for *base id, api key, and table name they have to copy. But massive time they have to go for create coloum and copy, if you give create coloum option so coders can directly create coloum easily thanks. My English is poor so is any mistake then forgive me.