I suggest you ...

Pre-fill Data from another spreadsheet

It would be cool if a form can be pre-filled from "master data" on another spreadsheet. If I for example enter my email address it must pre-fill the form with my name, surname, DOB etc. Obviously, the data must exist on the referenced spreadsheet (database). This would be nice for a user as he/she doesn't have to enter the "master data" every time they complete your form

110 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    LouisLouis shared this idea  ·   ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  · 

        I agree.. I would love that

      • Troy NikolaTroy Nikola commented  · 

        I think this can also be very useful for things like creating invoices.

        You can have the user select the PRODUCT/SERVICE they are wanting in the Google Form, then Form Publisher would go to the MASTER REFERENCED SHEET to get the associated PRICE and fill in the area on your template document.

        This way you can update your prices on your MASTER REFERENCED SHEET and all documents would have the newest pricing on them

        *** In addition to make this fully functional would be the ability to sum the total referenced cells and fill in the template with a marker such as __##SUM##__

      Feedback and Knowledge Base