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

Question

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 1

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

Answer 2

You can set up a reverse proxy that injects a javascript file in the form, that JS bit can detect and save the user IP in a field, along with any other info you’d need such as user agent, language, local time and so on. This isn’t exactly trivial but may be worth exploring.

I don't have any precise examples but what you can do is:

1. set up apache with mod_proxy to act as reverse proxy in front of the website
2. use mod_substitute to replace some JS on the page with a version you host
3. add any fields you need to the form so that when it's sent you get the data in the parameters

https://httpd.apache.org/docs/2.4/mod/mod_substitute.html