I need to capture the IP Address to google spreadsheet via google web form

google-apps-script google-sheets google-forms
PlanetHackers picture PlanetHackers · Apr 3, 2014 · Viewed 33.4k times · Source

I have designed a Google web form. This form is sent to number of clients. All the fields that are submitted are recorded to Google spreadsheet. I need to capture the IP Addresses of clients and time-stamp to spreadsheet when client updates his information.

How can I make the client to include its own IP address to store it in spreadsheet?

Answer

Rubén picture Rubén · Jun 13, 2015

To make the clients to include their own IP address in a Google Form you should ask them to write the IP address themselves.

The alternative is to pre-populate the answers and send the custom URL to them. For identification purposes, if you don't know the IP address, instead use a unique ID.

References
Pre-populate form answers - Docs editor Help

Related questions

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question will be 'prefilled' with …

Read More
Retrieve the e-mail address of a Google Form respondent without asking for their e-mail address in the form

The scenario goes: Via email, a Google Form is sent to a respondent. Via this sent email, the respondent answers the form and sends their response. This form has no email address field. I need to retrieve the respondents e-mail …

Read More
Hidden field in a Google Form

I am adding a unique ID to each submission of the form. Right now, I made that ID the first field, and pre-filled it with the ID, along with a help text asking the user not to modify this field. …

Read More