Đã hoàn thành

Create a button in Google Sheets row to send email with the contents of the row in the email body

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...

Subject:

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)

Body:

Hi 'Requested by'

Your redo item is complete and ready for dispatch. Details are:

(here we would list the item details from the row)

Kĩ năng: Google Sheets

Xem nhiều hơn: automatically email google spreadsheet, google sheets - send email button, google sheets - send email when new row added, alert by email when input data on google spreadsheet meets given condition, google sheets conditional formatting to send email, google apps script send html email, send email when google sheet is updated, google sheets send email based on cell value, create link button google sites, create button google xml, create app from google sheets free, create app from google sheets, create crm google sheets, google sheets send email based on date, send email from google sheets, google sheets button to run script, google sheets macro button, how to sort by row in google sheets, send text message from google sheets, google sheets api create new sheet

Về Bên Thuê:
( 0 nhận xét ) Wanniassa, Australia

ID dự án: #27488080

Được trao cho:

nemanjadj20

Hello? I have worked on Google App/Script projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # coin api Thêm

$155 AUD trong 3 ngày
(4 Đánh Giá)
3.4

7 freelancer chào giá trung bình$95 cho công việc này

(3 Nhận xét)
4.2
royalcalif

Hi Mr. Employer, Basically the Google sheet is running by Javascript. So we have some knowledge in JavaScript. I have a lot of experience in Google sheets and I can do this project in an effective manner with 100% accu Thêm

$30 AUD trong 1 ngày
(4 Nhận xét)
3.1
finecodervw

Hi, As I understand you would like email functionality in Google Sheets. Keen to work on this project. Please suggest suitable to discuss further on the requirement. Recently completed Google Sheets/Google Maps base Thêm

$50 AUD trong 1 ngày
(4 Nhận xét)
2.8
jasonpham188

Based on what you request, this is simple function that I can complete within 1 day with small budget for you.

$30 AUD trong 1 ngày
(0 Nhận xét)
0.0
DenKar

Hello! There's no way of embedding a button PER ROW, but being honest, this functionality would be a little weird. So the common route would be either having one single button working for the currently selected row, o Thêm

$100 AUD trong 2 ngày
(0 Nhận xét)
0.0
(0 Nhận xét)
0.0