1

Forgive me if I'm asking too much here. If it's too large a query I'll chop it into several posts. This is my first GAS project so here goes...

I want my sheet users to be able to launch a form by clicking on a button in the sheet. The form should be pre-populated with certain information from the row. There needs to be other fields in the form that the user can fill. Once the form is submitted I need all of the responses to be collected on another tab in the sheet. All of the form responses should be collected on the same tab.

I hope I've not been too vague, let me know if you need any extra info/examples.

Cheers,

Tom Parkinson
  • 13
  • 1
  • 4
  • What have you tried so far? Do you have any sample code of what you have written so far that isn't working? – Kmeixner Jun 05 '15 at 14:31
  • Cheers for the reply Kmeixner. Unfortunately I'm a complete app script virgin so I've no idea where to begin. I've seen a similar posts about pre-filled forms but it doesn't fit my needs. – Tom Parkinson Jun 05 '15 at 14:37

2 Answers2

1

You'll find an example of launching a form from within a spreadsheet in Single Google Form for multiple Sheets. It uses a custom menu, which is MUCH more reliable than an action attached to an image.

Instructions for creating a clickable image are found here.

Community
  • 1
  • 1
Mogsdad
  • 44,709
  • 21
  • 151
  • 275
  • Great, thanks very much for your reply, I'll have a look around these responses and come back with more specific issues as they arise. – Tom Parkinson Jun 08 '15 at 08:14
0

You can add an image to a spreadsheet, and then attach a script to the image. Some people add an image that looks like a button. The other option is to use a custom menu. So, start there, and see if you can get something to work.

Alan Wells
  • 30,746
  • 15
  • 104
  • 152
  • Great, thanks very much for your reply, I'll have a look around these responses and come back with more specific issues as they arise. – Tom Parkinson Jun 08 '15 at 08:14