So the rows with First column same cant be shown on screen by any way?
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! 
Do you know how to find the right person among them?
That’s what we’re trying you to understand since the topic created.
So is there any other data base from which I can get the desired result what I wants?
Sorry but this method is not possible by any way.
Can I explain you what kind of app I am Making so that you can give me more ideas to do.
@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:
Result:
The blocks:
EDIT:
I forgot to put in the filter blocks:
The AIA:
SearchAirtableTest.aia (4.4 KB)
1 Like
@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 
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
And change this too:
You haven’t tried the aia I sent you…
With these blocks when you write, all the data appears in the list. If you don’t write anything, nothing appears.
You have to adjust the sizes in the ListView. You can use something other than a ListView though.
-
The Global Name is the variable that stores the list of all the names you want to search (the first column (ABC))
-
In that select Item we put the data of the second column (you complete the row by putting the value of each column). Here you put the variable that saves the list of the second column (123). The index is taken from the list of the first column with the item of the Foreach
-
Here you do the same but the data is taken from the third column (pqr)
@pepocero I really appreciate your help . You are so help full can you help me in changing 1 thing in this see if I have data in Aitable as like:-
123 abc asd
100 qwe xyz
178 ffg pqr and
1 rst efg
1 dfg jdf
If I type Only 1 in the textbox then all the results which contain 1 i.e. (123 , 100 , 178,1) all are shown in this case. Can this possible if I writes 1 in textbox then only row ( 1 rst efg and 1 dfg jdf) would be shown to me as result , not the other results i.e. (178 ffg pqr , 123 asd abc etc).I mean only proper matching data would be shown.
ONCE AGAIN THANKS A LOT
~Saksham~
But all the values start with 1.
I don’t know if what you want to do is very practical.
You would have to do some checking among the amount of characters, but I don’t know how to do it. Try testing with the blocks you already have…
If I fixed number of charcter than is that possible?
@pepocero helps you a lot. You can use the first search feature to find out data like you said (i.e 100, 123 etc.)
Thanks a lot @pepocero you are great and superb… Thanks a lot 
You are just awesome and so intelligent
Dear @pepocero when I got the result in List view so how to arrange those results is a systematic way as like if I want to show the name first after that DOB after that Gender etc.
Now what I am getting result is shuffeled Name has gone in middle etc. How to arrange them properly.
Use the JOIN to fix it any way you want. I put in some slashes, but you can put line breaks or HTML.
- It´s the first column. Put it where you want to show the data in the first column
- The second column. Put it where you want to show the data in the second column
- The third column. Put it where you want to show the data in the third column
While testing my app some times this error is coming
What does this mean?
That you have some empty list. Make sure you get all the data from airtable. Put each variable on a label to see if you get the values.
One very, very important thing is to check that you don’t have any empty cells in Airtable. If you have any empty cells you do not get the data and you will have an empty list
@pepocero I have one more doubt regarding this will this work if a row contains 10 columns and another row contain 5 column and If I types data of 1st column of 2nd row so will list viewer will show the result? So is there any way by which some empty columns can be ignored and I can get the result