Retrieve data from Airtable

Discuss
#22

I mean that when A user enter that Code REF in text box so I want that every user who had created with that same code would be dispaly on users screen

#23

So it’s all about searching data on table, am I get you right? If so, follow @ImranTariq 's first reply. Get column data & put into a list, then search the list.

1 Like
#24

How to use blocks for this I am confused can you please share me blocks

#25

Here you go:

Search Community next time.

#26

I want to get whole row from 1 column how to do it please help me…
The link you shared unable to help me
I am sorry

#27

It’s not clear to me what you want. You’ve already been given material to read and test. But it looks like it’s easier if someone uploads a file aia, right? haha

See if this guide will help you. Instead of using dates, change dates to your Ref column. This way when you consult a reference you get the values of that reference. (I don’t know if that’s what you want, you’re not very clear)

#28

It should have helped! You have to make changes as per your need.

1 Like
#29

@asimjib93 With the help of these blocks I am not getting the desired thing what I want can you please help me as I need Only specific rows but by using these blocks whole data is stored in list view so can you please tell me what should I add or remove so that what I want I can get.
I would be thankful to you.
Thanks in advance :slightly_smiling_face:
Please help me …

#30

Call that specific row instead of calling column!

#31

Row number is not known

#32

I want to get whole row on the basis of its 1st column of that row.The 1st column of some rows can be same and I want, when I type data of 1st column in text box all the row present in Air table with having that data from air table should be visible on my screen.

#33

Not possible to get row number if it does not have a different ID. You must set any one table data with unique id for each row.

#34

So the rows with First column same cant be shown on screen by any way?

#35

You’re looking for someone at park you have never seen before! If two man comes to you and says, hey! It’s me you’re looking for! In fact, you’ve no clue about that person you’re looking for! :sweat_smile: Do you know how to find the right person among them?

That’s what we’re trying you to understand since the topic created.

#36

So is there any other data base from which I can get the desired result what I wants?

#37

Sorry but this method is not possible by any way.

#38

Can I explain you what kind of app I am Making so that you can give me more ideas to do.

#39

@Saksham_Goyal See if this works for you. When you type in the text box “Filter” you get a list of the data that matches that.
You get the data from Airtable.

Airtable Table:

image
image1215×288 20.2 KB

Result:

image
image720×1560 36.3 KB
image
image720×1560 25.2 KB

The blocks:

image
image783×656 51.3 KB

EDIT:
I forgot to put in the filter blocks:
image
The AIA:
SearchAirtableTest.aia (4.4 KB)

1 Like
Guide: Filter Airtable data by a specific date and display it in a ListView
#40

@pepocero But at first I dont want to show anything on screen when data is filled in Text box then after I want to get the result having same data.
Thanks in advance :blush:

#42

I forgot to put in the filter blocks. Look at my previous answer.
To do what you want you just have to modify what I send you to your convenience. The most important thing is the filtering blocks.
To not show anything at first you just have to remove the block from the Listview in GotColumn

image
image756×645 56.7 KB

And change this too:

image
image814×562 39 KB

You haven’t tried the aia I sent you…