Hello all..
Not sure if this is the correct forum but I will try and see what happens..
I have a Google sheet which has records (rows) added by an online form. The rows in the sheet are just added (not edited or deleted). I am looking for an App Script that will do the following when a record is added (I can set the event trigger to run the code):
- Identify the last row - the record just added - on the sheet (MasterData)
- Check if the value of a column (say column D) of that row is greater than some value (say >7)
- If it IS then
- Copy that row to the first row (col A, row 1) of another sheet (say Sheet1). Overwrite any record that is already there (I want to leave it like this for troubleshooting purposes so that I can see if there is any record in that row)
- Build a string with values from that row (something like โThe record โ & {Col A.Value} & โwas added and has a value of โ & {Col D.value}. I donโt know the syntax.
- Send a SMS: This part I can probably figure out using this video from Youtube [Send SMS from Google Spreadsheets with AppScript]. The string built above would be the body of the SMS message
I donโt expect anyone to answer this for free and would be willing to engage someone to help me.
Thanks.
RoryF
LinkedIn
Twitter
