Kapalı

App script for a Google Form

I have this Google form for purchase requests in my company, [login to view URL]

First would it be possible to assign a unique number in column A of the linked spreadsheet for each form entry. This could be called, "PO Request #".

Next, we would like when the form is submitted, that an email automatically go to the department head that Asks the department head, "Is the Purchase Request below Approved or Not approved"? and below the question has a summary of the Form contents and includes the attachment required by the form. Ideally the subject line would be, "PO Request [insert unique #] " and I would like cc'd on the email to the department head the requestor's email address and [Removed by Admin].

For testing you can use my email address [Removed by Admin] as the department head, once the app is ready to go I will replace that with the email address of the actual department head.

Beceriler: Google App Motoru, Betik Yükleme

Müşteri Hakkında:
( 2 değerlendirme ) Raleigh, United States

Proje NO: #34337203

Bu iş için 5 freelancer ortalamada $25/saat teklif veriyor

(18 Değerlendirme)
5.3
gangabass

I have a huge Google Apps script experience (with 1,000+ reviews) that's why I'm sure that you'll be impressed with my work. I can add code that will automatically add unique PO Request # and send email with the form Daha Fazla

$20 USD / saat tutarından itibaren
(42 Değerlendirme)
4.7
AwaisChaudhry

Hello, I hope you are doing great. I have good experience with doing similar jobs. You can check my portfolio here: https://www.freelancer.com/u/AwaisChaudhry?w=f I can do this job because have great experience with Go Daha Fazla

$50 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
SaraHaider01

Greetings I can surely help you for App script for a Google Form I am in the IT industry since more than a decade and serve so many clients for building and rebuilding websites, software and applications and I have Daha Fazla

$15 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
raidevbrat

Hi there, For your query, yes it’s possible to assign unique number for each new entry in linked spreadsheet. Also we can send emails with each entry in the format you described. Please ping me for details and if yo Daha Fazla

$15 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0