Why another extension about Airtable? Because this one is different. This one can select/ insert/ update/ delete according to your filter/condition.

Release history

V2 Update history 2020/12/24

  1. fix bug of "can not update value with space", now in the formula, use " and " to quote the value with space.
  2. add perperty of FetchIdAndTime. if set to true, in the SelectFinished event you will get 'id' and 'createdTime' for each record.
    2020-12-24_200204.png
  3. add method 'UpdateById' and 'DeleteById' for update or delete one record, which is faster than by filter.
    2020-12-24_200214.png

all the blocks

Initialize the extension

2020-12-13_104001.png

Same like other Airtable component, get your API Key, BaseId, TableName from the airtable website.

**update on 13/02/2024
Since 01/01/2024, Airtable deprecated ApiKey, and suggest to use token. You can set the ApiKey to the token, this extension still working.**

Select records

2020-12-13_104207.png

fields: String. or called "column names", Format like "name,age,phone". Leave it blank for all fields

filter: String. condition the records have to fit. Format like "age>30" or "OR(age>20, age<50)". For more info, please refer to here

pageSize: Number. how much records returned one time.. Max value 100.

offset: String. If the records fit the filter more than pageSize, you will get an offset at SelectFinished event, use it here for more records.

sort: String. the records will be ordered on this field. Format like "age desc" or "age asc"

count: Number. how much records selected.

records: String. Json format. it's a json array of dictionaries.

Insert records

2020-12-13_104231.png

records: String. Json format. it's a json array of dictionaries. Format like [{"name":"Jasmine Lake","age":43,"phone":"513937"}, {"name":"Ava Sharp","age":21,"phone":"293309"}]

IMPORTANT: If you want to feed this param with List component, remember to check "Show List As Json" at Screen1 Properties panel.

count: Number. how much records inserted. if count=0, means no records inserted.

Update records

2020-12-13_104254.png

filter: pls refer to Select part
NOTE: ONLY up to 10 records will be updated. if more than 10 records fit the filter, there will be Error Cccured.

formula:String. How to change the data. Format like: "age += 1". there are spaces before and after the “+=”。 Now the accepted operators are +=,-=, *=, /=, = for number field, and to for string field.

count: Number. how much records updated. if count=0, means no records updated.

Delete records

2020-12-13_104311.png

filter: pls refer to Select part
NOTE: ONLY up to 10 records will be deleted. if more than 10 records fit the filter, there will be Error Cccured.

count: Number. how much records deleted. if count=0, means no records deleted

Error Occurred

2020-12-13_104319.png

message: String. Error reason.

Download link here

cn.kevinkun.KevinkunAirtable.aix

标签: AirTable

添加新评论