Getting a row number of cell containing a particular text


#1

Hello,
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”…

Kartik


#2

Hello,

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

https://x.thunkable.com/projects/5cd84f23e3097f3353fdad45/project/properties/designer/


#3

OMG
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,
Kartik