Re: [Apps-Script] Application Form using Google Sheets/Forms

[Matthew Hynes]

One thing people don't realise often is that you can use a Google Sheet as a way to make a more customizable front-end interface to making a Form. Below is a quick example. You can either make a sheet template and give a copy to each person you want to fill in the form, or if you are ambitious, you could write some app script code to handle a submit button with an action of saving the field data to another Google Sheet for data collection.

https://docs.google.com/spreadsheets/d/1o1IW5kranNiFtgQ6EpV7FG74XdcZQFJfDSJHCIUiLUA/edit?usp=sharing

On Tue, 10 Mar 2020 at 12:11, CSSK Infotech <csskin...@gmail.com> wrote:

I want to design a application form similar to below image and capture data in google sheets. I have created using Google Forms but not able to get below layout. Please let know if there any similar code available in Github.

Image Source: Google Images.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/998645aa-9817-434a-838a-0491903f8d33%40googlegroups.com.

[cbmserv...@gmail.com]

You can also add buttons to submit form, clear form etc..

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAHyc7xp_%3DHRr7-FEpdw%3DhSUGCaLbjC2E_1v8E0P7THE-79Bu0w%40mail.gmail.com.

[CSSK Infotech]

Thanks Matthew Hynes for spending your time in creating sample file.

Google Forms open as new (blank) every time user opens it up in browser. 

But it is difficult with Sheets, we need create multiple sheets and keep track of whom we are sharing it.

[Mani Doraisamy]

I had a similar need and wrote an addon to solve this problem - https://gsuite.google.com/marketplace/app/formfacade/743872305260

It doesn't give you 2 column by default. But, you can write custom CSS for your Google Form. Do you want to give it a try?

regards,

mani

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/0046fc0f-f66b-48b8-805e-0b0e0be06c08%40googlegroups.com.

[Alan Wells]

There are frameworks and online form builders, but whether it would be worth it for you to spend the time and effort to research what you prefer, learn how to use it, and maybe even pay money for a service, I don't know.  Google actually has some guidelines for html form components, but I don't think that they have anything for putting input elements side by side.

So, you're probably looking at building the HTML yourself, or paying for a form builder service.  Then, if you want to stay within Google products, you'd need to create an Apps Script Web App, and not use Google Forms at all.

[Luke Marshall]

I did this very thing and created a material design web form using the Materialize library to make the various line animations happen. it worked super well My only issue was having the client implement it herself as It required all the permission setting in apps script ( I haven't yet nailed down how to make that install process a seamless thing ). I used Bruce McPherson's Fiddler's library to manage the responses into a database. Its been a while since I've tried it and there are probably bugs but you're welcome to make a copy to see how I was able to create the for responses and such. HOpe it helps more than confuses I did my best to comment and create coherent variable names.
https://docs.google.com/spreadsheets/d/1CmuMxnBayh-Fhsxb39Y1nNJA2DcKwToJTGQ49yXClYw/edit?usp=sharing

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7c9f2d69-38a7-476c-9c5d-5a0ba5703a70%40googlegroups.com.

--

Sincerely, Luke Marshall

Luke Marshall
Cell: 647-525-664	Work: 519-787-1264	Lu...@countyvape.com

All communications unless specifically stated otherwise are private and Confidential. If you think you have received an email in error please disregard it's contents and delete it immediately.