[FREE] KevinkunAirtable extension

[Kevinkun]

yes the select method will return a json string. you can use this JsonTools to parse it to a dictionary (i guess, never use it).

[Abhishek_Rawat]

what should i have to give in data actually I want to update cell like before is False But after clicking button i want to update cell from false to true

And I Need one more help that how to filter 2 column

I did like this
Column1=“abc” & Column2=“xyz” i want airtable send only those values in which abc and xyz value is there

[Kevinkun]

data socket should be a json/dictionary.
for two filters, maybe try AND(filter1, filter2)

For more formula, pls check the aiatable api section.

[Abhishek_Rawat]

I stuck in one thing that how to load data after every 25 record

Like i have table and 100 record is there
And i want that whenever screen initialises then it fetch 25 itms then after 25 itms if user scroll down again then it fetch next 25 itms …this process continuously run till it not reach 100 or fetch all 100 record

[Kevinkun]

please see post #5

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

Please add this producer Function in next version of Kevinkun extension than we can reduce our block and get Airtable files data List easily by using single Block.
Read my Post

Airtable Advance Tutorial : How to get Multiple Column List or File List From Airtable Sheet

How to get Multiple Column List or File List From Airtable Sheet by Using One Airtable Block or Procedures Method 1 : Only for String Column Data List If your Airtable Doesn’t Contain Files have only Text or Strings Than Use Simple Block and get Multiple Columns [blocks(15)] Method 2 : For String or Files Both Columns List Here we ca do call all the below Topic Get Multiple Column in List Format Get File list ,File Name List, Image Thumbnail List Step 1: First import the Procedure that…

[Abhishek_Rawat]

Hi extension working perfectly but my question is how i can store value in variable
I have 10 column in airtable and every column have 1 variable
So how to store every columns value in their variable

While i am showing only title value in notifier then i am not getting any value

While i am showing records then i am getting value

I am trying this method

Airtable Advance Tutorial : How to get Multiple Column List or File List From Airtable Sheet

How to get Multiple Column List or File List From Airtable Sheet by Using One Airtable Block or Procedures Method 1 : Only for String Column Data List If your Airtable Doesn’t Contain Files have only Text or Strings Than Use Simple Block and get Multiple Columns [blocks(15)] Method 2 : For String or Files Both Columns List Here we ca do call all the below Topic Get Multiple Column in List Format Get File list ,File Name List, Image Thumbnail List Step 1: First import the Procedure that…

[dora_paz (Dora)]

@Abhishek_Rawat

So how to store every columns value in their variable

So the question is how to store/send data in airtable ?

[Abhishek_Rawat]

Not In airtable After Fetching Data From Airtable I want To Store value in App Variables

Like in Airtable having 10 Column , Column 1 To Column 10 And Every Column Having more The 100 Records So After This Extension fetch 20 Records From Airtable, i want to Store every Column records in Their particular Variable (i created 10 Variables In App)

So My qn Is How to do this

[dora_paz (Dora)]

Using dictionary blocks

[FREE] KevinkunAirtable extension

Let’s say we have a table like this: [2021-09-05_171512] and we try to get ‘name’ column like this: [2021-09-05_171941] the global records is a list of list of list. if you want to get a simple list (not nested list), do this: [2021-09-05_171947]

[Abhishek_Rawat]

i Am fetching all column1 to Column 10( all row ), that’s why i am asking how to Store Every Column Record in Different Different Variables

[dora_paz (Dora)]

Example with 3 columns, modify it accordings to needs

[dora_paz (Dora)]

Above example Airtable Advance Tutorial : How to get Multiple Column List or File List From Airtable Sheet works if you use spreadsheet component not airtable extension

[Kevinkun]

@Kuldeep_Pilania

Please add this producer Function in next version

thank for your suggestion, but it’s about how to manipulate data, not the relevant function of Airtable extension.

[Abhishek_Rawat]

Sorry for irritating u all but i need one more help that how i can fetch single cell by row id

Like in airtable having 3 column ( in 3rd column i type paragraph ) and I can’t fetch alll data once

So i want that after fetching 1 and second column i will show those values in dynamically so if user will click 4 number card so i want app call airtable column number 3 cell no 4 value

How to do

[Kevinkun]

normally every record should have a index column, which means every data in this column is unique, you can use a auto increased number or uuid string.

so when you click record number 4, you should know its unique index and use it as filter to SELECT data.

[Abhishek_Rawat]

This post was flagged by the community and is temporarily hidden.

[Abhishek_Rawat]

i have one more question

Actually everything is working perfect after installing apk in my mobile i noticed this

So i read again this topic that how to call record in ascending order

But i am not getting any records after giving these values in sort ( in fields and filter part i add empty string block)

What wrong i am doing here

[Kevinkun]

what about sort only on one field? Since I wrote this extension long time ago, and forgot if more sort fields allowed or not. I need to check the source again later.

[Abhishek_Rawat]

Okay i am waiting for your response