Build a google form using App Script and forward information to google sheets and prepare packing slip

I would like to design a form using Google App Script that sends information to a google sheet and generates a packing slip that gets sent to the user.

I have a sample script and form that can be used as a base to achieve the results but the following are the conditions:

* The script must have validation for example to validate if the contents of a specific cell is a number.

* The form should have an intro to explain the process and a thank you page that summarizes what happens after the use submits the information

* A mock up is provided using Microsoft Excel Forms and VBA. This is for illustration purposes only but will be a great asset in understanding what we want to achieve

* The form can be similteanously used by several users (usually 1-6 at a time)

* Some fields appear or disappear (get disabled or enabled) depending on a choice from a drop down.

* If there is a viable alternative to Google Apps Script/Google Sheet, I am open to suggestions.

* The script should be easy to modify (not encorded) in case I want to rename columns. The beautiy of using Web App Script is the ability to use HTML to control where every thing is placed.

Habilidades: JavaScript, Google App Engine, AJAX, Google Sheets, Formulários Eletrônicos, Python, Arquitetura de software, Desenvolvimento de Software

Veja mais: google apps script: dynamic form, google forms triggers, google form pull data from spreadsheet, google form response script, google form script examples, create google form programmatically, google form script on submit, onformsubmit

Acerca do Empregador:
( 15 comentários ) Toronto, Canada

ID do Projeto: #27665934

Concedido a:


hello, i read your requirement carefully.i can make script for this.i have a lots of work in google app script.

$45 CAD em 2 dias
(4 Comentários)

7 freelancers estão ofertando em média $65 nesse trabalho


Hi there,I'm biddin on your project "Build a google form using App Script and forward information to google sheets and prepare packing slip" I have read your project description and i'm an expert in Python and machine Mais

$60 CAD in 3 dias
(83 Comentários)

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 Mais

$30 CAD em 1 dia
(25 Comentários)

Hello I am a talented developer who has built many projects in Google Script/Google Sheets/Google Forms. I cannot download the mockups, so please send them to me directly. Your price range is quite low, but I assure y Mais

$130 CAD in 2 dias
(14 Comentários)

Hi there, Hope you are doing well. I have 6 years of experience in Google scripting. I can do your work asap. also can provide demo of existing work. Love to know and discuss in detail. Regards Rahul

$100 CAD em 1 dia
(3 Comentários)

Hello, Sir. I read your requirement. I have experience of 6 years and done similar projects before. I can develop your project with full perfection. Let me go on, you can get the best project that you can ever get. Ski Mais

$30 CAD in 7 dias
(0 Comentários)

Hi, I'm an experienced javascript/angular developer, new here at freelancer. I have worked in several google spreadsheet addon. For you requirement, it's the best choice to go with google sheets and scripts, since it Mais

$60 CAD in 7 dias
(0 Comentários)