V2 Update 2020/12/24
- fix bug of “can not update value with space”, now in the formula, use " and " to quote the value with space.
- add perperty of FetchIdAndTime. if set to true, in the SelectFinished event you will get ‘id’ and ‘createdTime’ for each record.
- add method ‘UpdateById’ and ‘DeleteById’ for update or delete one record, which is faster than by filter.
v1:
Write a short description
Why another extension about Airtable?Because this one is different. This one can select/ insert/ update/ delete according to your filter/condition. You can add or delete records freely, NO NEED to take care about the row number changed or not.
Add a picture of all the blocks
Initialize the extension
Same like other Airtable component, get your API Key, BaseId, TableName from the airtable website.
Select records
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)”. Leave it blank for no special condition. 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
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
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 Occurred.
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
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 Occurred.
count: Number. how much records deleted. if count=0, means no records deleted
Error Occurred
message: String. Error reason.
Include a Download link here; can be direct or a link to your website/host
aix: AirTable Extension - 浮云小站
demo aia: Airtable.aia (67.1 KB)
Bug report
if any bug, please tell me here.
======