We have a two-step approval form, where approval from both approver 1 and approver 2 triggers the drafting of an email to the IT department. However, this should only occur when the status is changed to "approved." To address this, I created a code in Google Sheets that functions only when the status is changed to "approved" or when the status is edited from "pending" to "approved," prompting an email to be sent to the IT person. Unfortunately, the "onEdit" function is not activated in situations where the status is changed from "pending" to "approved" programmatically, as the "onEdit" trigger in Google Apps Script only activates when a user manually edits a cell in the spreadsheet.
Automated Email Trigger for Two-Step Approval Process in google sheet
29 Views Asked by Janhvi Sharma At
1
There are 1 best solutions below
Related Questions in GOOGLE-APPS-SCRIPT
- How to use custom font during html to pdf conversion?
- parameter values only being sent to certain columns in google sheet?
- AppScript to replace image in google slides
- Email Sent Using AppScript Appears in Sent Box, but does not appear in Recipient's Inbox
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- Would like the script to return the PDF letter via email with the sheet name not the spreadsheet name
- App script to prevent duplicate form submission
- Redirect Users to another website using GAS
- How do I create a Line Graph on App Script?
- Error (Status of 500) and X-Frame-Options with google apps script redirect function
- How do I add the Luxon library google sheet script
- AppScript For Google Form
- google sheet script to convert the Scientific notation in the selected area to number
- onEdit() 'row is not defined' error using checkboxes
- Regex expression not working on Google Form
Related Questions in GOOGLE-WORKSPACE
- Allow external users to login using custom SAML app in Google Admin
- Does groups.list api in google Admin context, list indirect groups as well?
- From the Google Picker, after selecting the file, I receive a "file not found" error in the backend integration
- can replace file in google drive by c#?
- How do I get rid of any type of Memory Saver in Chrome
- How to create a list of users, source ip and lastlogin on GCPW using a google spreadsheets?
- Access Regular Gmail Account with API in Lambda
- GMAIl API: how to get messages without any prompting for authorization?
- getRange() function too slow
- Google OIDC: How to get the member_key of an external SSO user?
- Populate Simple AD from LDAP
- Google picker in Electron returns 403 when packaged but not local dev
- Automated Email Trigger for Two-Step Approval Process in google sheet
- Gmail "Layouts Tool" configurable via appscript?
- Siteground Website using Google Workspace Email & Deliverability Issues
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Try using batchUpdate() and USER_ENTERED instead of setValue(). You will need to enable the Sheets API. There is an example here.