Condition for a bot to check if there is a term in the last row of the table to send email

AppSheet AppSheet Q&A
, ,
1

I have a Google forms that feeds a spreadsheet and which is the database for the Appsheet application. I tried to make a bot to send an email every time a response is added to the spreadsheet AND contains a “not ok” in any column, but I failed.

So if someone can help me create a condition for the automation, I would be extremely grateful.

I need a formula to check if there is a “not ok” in the most recent response of the forms/spreadsheet (last row), whether specifying the column or not, and return yes/no.

@Steve I read many of your solutions here, can you help me pls?

2

Have you created a table using the Form as its source? Updating the spreadsheet directly, which contains the sources for tables in AppSheet does not trigger a bot.

3

You’ll need to write a Google Script in the Sheet that will do this for you. Even with the most basic programming background, you can use ChatGPT to help you write the script you need.

4

Thats a good one. I considered this idea previously, but as I urgently needed automation, I opted for Appsheet.

Thanks.

5

Really? I did not know that.

The solution I found was to use a formula to call the last row to another page in the same spreadsheet.

Thanks