[FREE] KevinkunAirtable extension

Extensions
#22

Updated.
1.bug fixed.
In the formula, for value with space pls use " and " to quote them, for example: name to "Melqui Castro Isaza"
2. Add UpdateById and DeleteById method.
3. Add FetchIdAndTime property.

1 Like
#23

Great work Thanks

#24

Great extension!
UPDATE is PUT or PATCH?

I made this manually using WEB component…
However, the WEB component does not have the PATCH method

#25

Coming in the next App Inventor release :slight_smile:

2 Likes
#26

Patch, only change the column you specified.

1 Like
#27

Can you please PM me ?

#28

Pm what???

#29

Click here to download both aix and aia,if needed…

#30

Please pm me i want to talk something other thing

#31

how to get row data by id?

#32

Use select block, set filter to id＝"the id here"

1 Like
#33

thanks…

#34

How Update by id and Delete by id works? nothing happens when i try to delete…

idairtable
idairtable1360×434 37.3 KB

#35

Id is not a number, not the row number. It’s a string. Pls check on airtable database.

#36

it does’nt work for me. can you share blocks for Delete by id and update.

#37

See here about record id

2 Likes
#38

thanx alot. it worked

1 Like
#39

Try something like this

image
image1204×435 39.6 KB

4 Likes
#40

Please tell me how to use UpdateById.
I want to update the cell value.

#41

First set FetchIdAndTime to true, then you need to get the records with SELECT block, and parse the response to get the id of the record, like dora_paz wrote in last post.
then something like this:

2021-04-29_105135
2021-04-29_105135956×246 55.8 KB