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
I agree.. I would love that
Troy 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##__