Getting a row number of cell containing a particular text


I want to get the Row Number of a particular cell containing a particular text…
I used for loop to search the text. But I didn’t get my expected result…
This is what I did :point_down::point_down:

For getting the email, I need to input the full text present in the cell in the spreadsheet.
Example : the cell in the sheet contains “Kartik”; My aim is : If user enters “Kart”, get the email of the cell containing text “Kart”…




an example of searching and filtering data from AirTable can be viewed on the scrAirTable screen in the project:


Thank you so much!
You built such a great quick tutorial app from which any beginner can get help!
This solved my above + many problems…:grinning::grinning:
Thanks a lot,