Fetch data of specific user from airtable

[Dr_RSMY]

Hi guys

I want to fetch data of the specific users from airtable
for instance Daniel

I will appreciate your help

[dora_paz (Dora)]

Either use an extension like

[FREE] KevinkunAirtable extension

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. [2020-12-24_200204] 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 di…

or get all data and filter it according to your needs

[Still-learning (1-2-3-4...)]

Have you tried anything so far? If so pls share with is, we will correct it. Or suggest you the modification

[Dr_RSMY]

Thanks

I tried to use some way shared in the community but I couldn’t success

[dora_paz (Dora)]

Post a screenshot of your blocks so that we can see what you did so far

[Still-learning (1-2-3-4...)]

@Dr_RSMY

but I couldn’t success

I am sure you might have missed any logical pattern… share us what you have tried…

1. get data from airtable. Add into a list, using index is in the list block extract further info from the lists…

[Dr_RSMY]

I am new to kodular, so I tried this way but It’s not working… just trying to fetch specific user data from airtable to show them in listview

I know its mess… please just take it easy and help me

[Still-learning (1-2-3-4...)]

half a way correct, but your mistake is , you have added the loop in the same place of where you are calling the data, but actually you have to use this block in when spreadsheet1 got colum data block

How many fields you are calling, * fields? as you are using index as 8?, in such case why dont you use get all rows method…

[Still-learning (1-2-3-4...)]

Refer this method of get all rows, so there by each fields(column) values you can put into a list… then as said earlier , use Index is the list method to get index of the particular name , and with the the help of this index you can get remaining details…

How to load firebase picture by airtable

Check up this… WIMAS.aia (98.9 KB)

[Still-learning (1-2-3-4...)]

what are the fields you want to get for the specific user from airtable?

[Dr_RSMY]

suppose i want just “Yara” data only… its appeared in differnt rows

I just want her data to appear only in the list

[Still-learning (1-2-3-4...)]

can you show your airtable structure for Yara??

[Dr_RSMY]

[Still-learning (1-2-3-4...)]

Oh, multiple places are there… hmmmm

Totally in mow many places the name is there… wait let me find it from here

[Dr_RSMY]

Yes its correct now… seems you used another spread sheet, could you please share aia… really appreciate your kind support

[Still-learning (1-2-3-4...)]

[Dr_RSMY]

Awesome… thanks for your kind support, really appreciated

[Still-learning (1-2-3-4...)]

(deleted)

You have to delete the unwanted blocks and all herethen… I hope all the spreadsheet calling the colums are can be deleteable i think…( no need of it)

check up and let me know

But i believe instead of that big block(design procedure), simply you might have use collintree or default list view with image blocks, @Dr_RSMY

[Dr_RSMY]

sure i ll delete… thanks a lot

[Still-learning (1-2-3-4...)]

Yes… Better you can regenerate the api key from the airtable also can change the table name for your safety. …

Click on account> Regenerate API key