Need Help to Filter Data From Airtable

I Use Airtable Spreadsheet for my recent Project. I Use 2 Column in Database. (See Image)

Image removed because it was containing lots of Mobile Numbers

Now Query is: I Want to show Ticket Numbers in ListView which are Bought by Mobile Number
Phone Number removed by Mod
Pls Share Blocks or guide me to solve this issue.

thanks in advance.

Use MySQL or freebase these database to work properly

@Pradyumansinh_Jadeja please re upload the image after blurring or removing the mobile numbers

if you show your database properly and we could suggest you the better one

image

In Listview, I Only need data from 111111111

https://api.airtable.com/v0/yourBaseId/YourTableName?filterByFormula={Mobile}="111111"&api_key=yourApiKey

Use this URL in web and the response content will have matching row records. From the record just take the selected col value alone using dictionary block. For more ref here

I feel this way would be easy to search. It saves multiple time. Early we have to download all col values and will compare but this one simplify all…

The above link will tell you how to take data from response content into list values or string values.

Have you tried @Pradyumansinh_Jadeja

Dear, I’m Not Fully Understand This Method. if you are free, It is Better to Create 1 simple .aia file.
Thanks in advance bro