I am trying to get my Zoho Creator form to change values in my Google Sheets file. I've been trying different scripts but cannot find any clear direction as to how to go about doing this.
What I want is to have the ZC form with Work Order Number & Hours Worked fields. When the user clicks submit this will send these 2 fields to a Google Apps Script - which finds the row with the Work Order Number and then edits the Hours Worked entry.
I can execute the change on scripts but I cannot figure out how to send the info from my ZC form to scripts.
Any direction on accomplishing this?