Hi Numan, You *may* be able to do it using Google Apps Script (aka GAS), using a simple (aka. non-installed) event-handler for the 'on form submit' trigger. The event-handler would use Session.getUser().getEmail() to get the information you desire.
Events - http://code.google.com/googleapps/appsscript/guide_events.html <http://code.google.com/googleapps/appsscript/guide_events.html>User Class - http://code.google.com/googleapps/appsscript/class_user.html I say "may" because it's not clear from the documentation that form-submission necessarily establishes a Session. Please follow up this topic on the Google Apps Script forums, not here. http://www.google.com/support/forum/p/apps-script/browse?hl=en You might want to review the following threads before feeling elated that your problem is 'solved': * http://www.google.com/support/forum/p/apps-script/thread?tid=3c5eea5eb2fd9582&hl=en * http://www.google.com/support/forum/p/apps-script/thread?tid=09dda3fa53b2b388&hl=en regards, David. <http://code.google.com/googleapps/appsscript/guide_events.html> On Tue, Apr 26, 2011 at 3:30 AM, numan <[email protected]> wrote: > I am interested in collecting user email addresses in the form without > having to explicitly asking the users to enter that data in the form itself. > > I couldn't find a way to do this. The spreadsheet data that is populated in > the back, only shows timestamps and not the email. > > Is there a way I can get the user to authenticate though openId or whatever > and have the email address automatically be associated with the user's data > in the spreadsheet. > > Thanks, > numan >
