[Free] Extension AirtableClassic -Airtable powered Spreadsheet

spreadsheets
free
extension
airtable

#1

AirtableClassic Extension

image

Airtable is a service that looks like a spreadsheet but actually acts like a database.
Airtable powered spreadsheet has been already introduced in Thunkable X.
This extension is to connect Airtable database with Thunkable Classic.

Setup

  1. Create your free Airtable spreadsheet and account
    See documentation by Thunkable for Thunkable X.

  2. Connect your Airtable spreadsheet with Thunkable.
    See documentation by Thunkable for Thunkable X.

  • After obtaining properties API key, Base ID, Table Name and View Name

image

Getting, uploading, updating and deleting data. [ Methods and Events ]

1. Getting data

  • Get all data
    image

image

  • Get the value of a cell
    image

    image

  • Get Row
    image
    image

2. Uploading and updating data

  • Create Row
    image
    image

  • Update a cell value.
    image
    image

  • Update a row
    image
    image

3. Deleting data

  • Delete by row number.
    image
    image

Note: responseCode = 200 means success.

Some sample blocks

image

image

image

Download Extension AirtableClassicimage

Suggest new updates, report bugs, errors and stay tuned…

  • Loved this extension?? :heart:

Donate image

Through Paytm

Through Paypal


Airtable Spreadsheet in Thunkable Classic
Cloudstitch not working since this morning [Solved]
Spreadsheet Update with query Code?
Editing Spread sheet
Please introduce airtable in classic android also
How to we use airtable in thunkable
Suggestion to use sheet in
Cloudstitch - Spreadsheet DOWN SERVICE!
Cloudstitch to Airtable
Cloudstich Widgets Problem
Cloudstitch - Spreadsheet DOWN SERVICE!
#2

Nice work @Jerin_Jacob. :+1::+1::+1::+1::+1:


#3

Good Job! @Jerin_Jacob


#4

Hi @Jerin_Jacob
Please ! what is the alternative block for use airtable?

for example in spreadsheet (cloudstitch) I use for Get Data -> Put in ListPicker -> Select -> and put in TextBox option selected:

what are the block for same procedure in Airtable?

Thxu in advanced !


#5

Great job brother


#6

Dear !..

How can i Get value of next cell/Column?
Por example:

If I select from list_picker (A2)
How can i get (B2) ?

imagen

what airtable extension block use ?


#7

Hi @B_Hdez,
You can use
image
for getting column values .

And you can use
image

for getting a cell value using row number.


#8

Thx u @Jerin_Jacob

I get Column fine and listing value in my List_Picker, but i dont know how get the next cell A2:B2 what will procedure for get B2 value?


#9

You can get the row number from, listpicker and set the column name from which you want the value
image


#10

Solved !


#11

Check your table name and view name everything is ok.


#12

Thx u ! @Jerin_Jacob

Problem solved ! i get Vale B2


#13

hI @Jerin_Jacob

What value use i for ilimited cell in column?

maxRecord: “X” ?

Can i use “FALSE” ?

Sorry for my bad english and thunkable use, im Newbie…


#14

You mean, you don’t want that maxrecord?


#15

Correct, i want get all value from column (unlimited). or what is the meaning of maxRecord ?


#16

maxRecord means the number of rows you want to return.
There is no proper solution for it now, alternatively, you can set maxRecords to a large value.


#17

OK Mr.

I can use value = 10000
for not have problems…

thx u


#18

Dear @Jerin_Jacob

Please, the following blocks do not connect !

image

Any idea ?


#19

Its a list you want to use make a list block.

Or if you have only one value you can use set cell method.


#20

Hooo… Thx U Monster !

Work Fine !