Closed

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.

Skills: Google App Engine, Script Install

About the Client:
( 2 reviews ) Raleigh, United States

Project ID: #34337203

5 freelancers are bidding on average $25/hour for this job

(18 Reviews)
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 More

$20 USD / hour
(42 Reviews)
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 More

$50 USD / hour
(0 Reviews)
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 More

$15 USD / hour
(0 Reviews)
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 More

$15 USD / hour
(0 Reviews)
0.0