How to detect country name for each response received

  • Profile Image
    chiragvora123
    Asked on June 26, 2014 at 02:36 AM

    I know we can track IP Address s and use importhtml() feature on Google Spreadsheets, but I always face an issue due to viewing limit. Is there any built-in function just like IP Address in JotForms so that country name is automatically comes in my Google Spreadsheets?

    Update - I want it automatic just like IP Address, as there are widgets which does it manually

  • Profile Image
    jonathan
    Answered on June 26, 2014 at 04:41 AM

    Hi,

    How about using the Address Map Locator Widget .

    Here is a demo form http://www.jotform.co/form/33264878510862

    In the form submission data, the Location will have the location/country result like this

     

    Please tell us if this will not work to what you need.

    Thanks!

     

     

  • Profile Image
    chiragvora123
    Answered on June 26, 2014 at 05:57 AM

    But the problem in this is user is able to see the details while filling the form, which I don't want. I just want it in my google speadsheet, nowhere else.

     

  • Profile Image
    NeilVicente
    Answered on June 26, 2014 at 07:02 AM

    Unfortunately, no, we don't have any other widgets that can do the job except the "Get Visitor Location" widget which is currently undergoing a bug fix.

    We will let you know if and when it gets fixed so you can start using it on your form.

    Thank you for your patience.

  • Profile Image
    chiragvora123
    Answered on June 26, 2014 at 07:10 AM

    Okay, if possible add 2 features in "Get Visitor Location"

    1. An option to Hide the details for the user who is submitting the form

    2. Option of storing only Country as currently both Country/City is getting stored

    Thanks

  • Profile Image
    jonathan
    Answered on June 27, 2014 at 07:04 AM

    @chiragvora123

    Hi, 

    The previous issue with Get Visitor Location Widget is now fixed. Perhaps you may also want to try it out on your form and see if it can work to what you need.

    Thanks!