Airtable extension

Description

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

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

  1. add method 'UpdateById' and 'DeleteById' for update or delete one record, which is faster than by filter.

    2020-12-24_200214

V1:

Add a picture of all the blocks

Initialize the extension

2020-12-13_104001 Same like other Airtable component, get your API Key, BaseId, TableName from the airtable website.

Select records

2020-12-13_104207

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

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 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 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 message: String. Error reason.

Download link here

aix: v1 v2

<结束>


鲁ICP备18053419号-1