We use a google form and google sheet to request and track parts in our factory which are defective and need to be re-manufactured. Each row has information about the part so the machine operator can make it. Once the part has been made, we would like a button on each row that the operator can press which prompts an email to be sent to the person who requested the part. The information in that row needs to be in the email body. The email message may be something like...
Your redo for 'Project' 'Level' 'Unit' is complete and ready for dispatch
(the Project, Level and Unit numbers would come from cells in the row)
Hi 'Requested by'
Your redo item is complete and ready for dispatch. Details are:
(here we would list the item details from the row)