App script for a Google Form

已关闭 已发布的 1 年前 货到付款
已关闭

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.

谷歌应用引擎 脚本安装

项目ID: #34337203

关于项目

5个方案 远程项目 活跃的1 年前

有5名威客正在参与此工作的竞标,均价$25/小时

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 更多

$20 USD / 小时
(42条评论)
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 更多

$50 USD / 小时
(0条评论)
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 更多

$15 USD / 小时
(0条评论)
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 更多

$15 USD / 小时
(0条评论)
0.0