[FREE] KevinkunAirtable extension

V2 Update 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:

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

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)”. 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

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 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

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 Occurred.

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

Error Occurred

2020-12-13_104319
message: String. Error reason.

Include a Download link here; can be direct or a link to your website/host

aix: http://www.kevinkun.cn/airtable.html
demo aia: Airtable.aia (67.1 KB)

Bug report

if any bug, please tell me here.

======

25 Likes

@wangsk789 Congratulations. can you add output screen shot is better to presentation.

3 Likes

data loading speed will be same?

Can you elaborate more about this?
By the way nice extension

1 Like

Great extension.

1 Like

Hi, this will explain :

If you have more than 100 records (age>20), you will get an offset (not empty) in SelectFinished event, then you can use it for next time select.

1 Like

Can you added filter with word option.& that extension will be fast more that kodular airtable extension?

1 Like

Would you pls give more about word option?
the most useful filter for string field is like name=“kevin kun” or FIND(“kevin”,name)>0

Maybe someone can give a try for the speed test.

1 Like

I am telling about this.that was very helpfull.thank you for creating such a great extension.

1 Like

Good Job :thumbsup:

1 Like

This extension is awesome thank you so much
This extension also support send text to airtable in language (hindi,urdu,marathi like almost all)
I tested its work perfert

2 Likes

:grinning:

Thanks you for your test and feed back. How about the speed compare to the build-in one?

1 Like

Good job! Thanks for your contribution.

1 Like

@wangsk789

:+1: :ok_hand: :+1:
Say, I want to sort all the list with a particular word…we call it tag/categories in blogging…is it possible?

It would be a great extension if,

  1. Loading speed is good
  2. A video demo for all features of the extension (showing how it works)
1 Like

Can you please provide an aia file

1 Like

Do you want to get the records with one column containing some special word? use this as filter: FIND(“kevin”,name)>0

For speed, the select and insert shout be fast than update and delete.

1 Like

demo aia uploaded at end of first post.

1 Like

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

Thanks for your feedback.
This is a small bug: You can not use space in the string value when update or delete
For now please use this to avoid this error:


Maybe fix this bug next release

2 Likes

Does this increase the speed of loading data from airtable ???

1 Like

no. This use same api with build in component.

1 Like