Apps Script help needed..

[RoryF]

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   

[bill_pier3]

Though I don't think there's any prohibition about asking an Apps Script coding question here, I doubt that you'll get much traction in the way of answers.  That said, there are numerous better resources for just such questions and assistance.

• stackoverflow.com/questions/tagged/google-apps-script 
• pulse.appsscript.info/p/category/level/beginner/ 
• www.benlcollins.com/apps-script/google-apps-script-beginner-guide/ 
• developers.google.com/apps-script/overview 
• www.steegle.com/google-products/google-apps-script-faq 
• medium.com/search?q=apps%20script 
• www.freecodecamp.org/news/search?query=apps%20script 
• ramblings.mcpher.com/apps-script/ 
• YouTube
  • Google Apps Script - Automate Google Apps 
  • Google Apps Script 
  • Google Workspace: Apps Script in a Snap 
  • Google Apps Script - Fundamentals 
  • Google Developers: Apps Script 

I hope some of these resources might be useful.

Bill

[RoryF]

Thanks for the reply Bill..

Am I in the wrong forum (Google Workspace)? Or is it just too much like a project to get an answer to?  I am working my way through the Google Developers Codelabs to see how far I can get on this, but it will take time as I haven't used Javascript or Apps Script before (but have some VBA under my belt..).  I will see how far I get..

Thanks,

RoryF

[bill_pier3]

RoryF,

I forgot about the Workspace Developer Forum available here; try asking your question in that forum.

Bill