Ha hello the mobile number already exist in our google spreadsheet list checking possible

[Raj7 (Raj)]

Ok dear i will set and test dear​

[Raj7 (Raj)]

Not working dear.

Not working please check dear

KSC ORDER ID AND MEMBERSHIP NUMBER GENERATOR

Our spreadsheet orginal link dear

[Raj7 (Raj)]

Hello dear what is the issue dear i m trying to find issue dear

[Still-learning]

thats why i suggest you to use gviz

https://docs.google.com/spreadsheets/u/0/d/
1TlzXWt6AlV6iMQRjnZxSMbUAu-tASm088rRiisd5VrA
/gviz/tq?tqx=out:csv&tq=select A where A=

[Raj7 (Raj)]

Ok i will set and test ok ok

[Raj7 (Raj)]

Not working all columns dear

Only work 4th column dear

[Still-learning]

send me your aia

[Raj7 (Raj)]

Ok dear send our aia file dear

[Raj7 (Raj)]

https://drive.google.com/file/d/1Yc_leYN0_YSicnHpW4A2ghMYn6IZoK09/view?usp=drivesdk
Please check dear

[Still-learning]

@Raj7

check dear

working good, just interchange the logical answer

length 1 mean, it returns only header so number not available

length 2 mean it returns header and the number, so number exists

pls ref

[Raj7 (Raj)]

Ok dear i will check and tell dear

[Raj7 (Raj)]

Now perfect working thanks dear