(Spreadsheet) Insert , Clear And Delete A New Sheet With Your app In google spreadsheet database

What is present in label text?

([email protected])

quite surprize. May be extra text may be added to the label. Click on all the four and do, do it to make sure it is showing same details

it is the same, I even tried putting it manually

So the situation is, I have a column in the sheet for emails, and I want to check if the email entered in the text field(Label1 in this case) in the app is present in the email column or not.

then in such case use query method. if you get return value then the email id is exists. if it returns no value then that email id is not exists

what could be the query for this case?

you will have query function in the blocks.

Imagine col a is email and col B is having some data regarding to the email. So the query will be

Select B where A = textbox text or label text

when web got text
if the response content text is empty then such email id is not exists in the gsheet

1 Like

Worked! Grasias!

Hello @AppHelper_Studio, I am using your Spreadsheet Extension, although it’s working all fine. I just needed a little help, what if after creating or updating the google sheet i want to share a downloaded excel sheet via mail or anything, possible?