+ Reply to Thread
Results 1 to 12 of 12

Google Forms

  1. #1
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Google Forms

    Hi,

    I have a fairly simple and short Google form with questions on it. However, towards the end there is (or I want to have) a section that is for the use of someone else i.e. not the person filling in the form. Essentially the form is for people to submit a proposal idea and the end section is for their boss (boss 1) to say whether they approve the proposal or not base don the information submitted. If they do approve it I want them to be able to then complete their bit. In addition it may also need higher approval and there are two more questions for another boss (boss 2) to complete (this is all once section currently).

    So....my question is, currently I have made it so the form ends at point "A" and the user then clicks submit. However I then need boss 1 to be able to access that form again and enter their decision at point "B" in the form (i.e. after the submit point). Is this even possible and if so how? Also could boss 1 and 2 get notified when these sections are completed so they know they need to go in and do something or is this too advanced and if so what is possible?

    Thanks
    MissDB

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Google Forms

    It's possible I'd imagine.
    But it's been couple of years since I last worked with Google Form...
    Quick Google Search turned up below.
    https://support.form-publisher.com/h...on-Google-Form

    There may be other custom module that could be installed out there.

    If that isn't an option, you'd probably have better luck getting help, if you ask the question in Google Form specific forum.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Google Forms

    Hi CK76,

    That's great, thank you for the quick response, will check it out.

    Best wishes
    MissDB

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Google Forms

    Oh, if above isn't an option. Here's what I did in the past.
    1. Create 3 separate forms.
    2. Create custom web pages (could be hosted locally in company network to limit access). With form parts embedded.
    3. Add Google Scripts to send out notification once form is submitted to each of the form's linked sheet, along with info (include unique identifier).

    So when initial user submits form, notification along with UID goes to boss 1 & 2. Boss 1 then opens up form 2 and enter UID along with his actions.
    Boss 2 then receives notification, submits form 3 along with UID.

  5. #5
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Google Forms

    We are quite restricted here sadly but I will have a look into that to see if it is possible. Many thanks again!

    Miss DB

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Google Forms

    MissDB, for future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Google Forms

    I apologise if my thread title did not comply with forum ruled. I was struggling to verbalise a shortened form of my question. I was also at work and had time pressures. I Will ensure future posts are as descriptive as possible.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Google Forms

    No problem, thanks for understanding

  9. #9
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Google Forms

    I have marked this threaed as "solved" because sadly we had to abandon this approach and I am now using Excel!

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Google Forms

    Sadly? Not exactly the best term to use on an excel forum LOL

  11. #11
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: Google Forms

    I meant sadly in the sense that I had done a lot of work and wanted to be able to post a solution on here as is expected by the forum "rules"/etiquette but I was unable to see this method through to complete. I am over the moon about using Excel, just wish I had been able to use it form the start!

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Google Forms

    aahh OK, I understand (I was just pulling your leg btw)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. inporting data from google forms
    By nappy1001 in forum Excel General
    Replies: 1
    Last Post: 09-20-2018, 04:32 PM
  2. Google forms type like excel sheet.
    By Makaron in forum Excel General
    Replies: 1
    Last Post: 11-28-2017, 12:59 AM
  3. online Google Forms calculating through formula and show the result to responder
    By Faizan.h.hashmi in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-20-2017, 03:15 AM
  4. Excel Survey like Google Forms
    By howaboutno in forum Excel General
    Replies: 8
    Last Post: 07-24-2016, 07:41 AM
  5. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  6. Google (sheets, forms, etc)
    By BRIZZLE101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-03-2013, 08:55 PM
  7. [SOLVED] Google Forms Usage Tips Request.....
    By spiwere in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 04-03-2013, 02:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1