How to filter submissions by IP addresses.

  • silasouza
    Asked on July 23, 2015 at 5:17 PM
    Now another question.

    Considering that I’ve already integrated my form to the spreadsheet and I’ve been receiving the results inside it, can I get back the results inside a form using a key to filter, such as the IP number?

    What I’m trying to do is provide some form where the user can check the submissions that he done so far getting the information from the integrated spreadsheet filtering by his IP.

    Do you think its possible to do that?

    Thanks again!
  • Jeanette JotForm Support
    Replied on July 23, 2015 at 5:18 PM

    I've opened a new thread since this is a different question.

    You can see the IP addresses, of course, you can even have them in the spreadsheet, here is how:

    http://www.jotform.com/help/31-How-to-See-IP-Addresses-of-Form-Submitters

     

  • silasouza
    Replied on July 23, 2015 at 5:49 PM
    Dear Jeanette,

    Thanks for your response but I think that you couldn’t see my question in details.

    I don’t want to simply check the IP address of a form submitted.

    I want to provide a form with the results of forms that the user already submitted, from a database (spreadsheet) that is integrated with the form. Check this out:

    1 – the user fill a form and submit it (ok)
    2 - the form results go to a spreadsheet (ok)
    3 – At the end of the day, the user go to another form (or report, I don’t know) and see a table of contents with his submitted results from the spreadsheet above (he can’t see the results of someone else, only his results) – (here is my challenge!)

    Regards

    Respeitosamente,

    Assinatura de e-mail PM TEC ok


    De: JotForm Support Forum [mailto:noreply@jotform.com]
    Enviada em: quinta-feira, 23 de julho de 2015 18:19
    Para: silas.souza@pmteconsultoria.com.br
    Assunto: Re: How to filter submissions by IP addresses.

    A new response has been received:
    Imagem removida pelo remetente. JotForm
    Answered by Jeanette
    I've opened a new thread since this is a different question.
    You can see the IP addresses, of course, you can even have them in the spreadsheet, here is how:
    http://www.jotform.com/help/31-How-to-See-IP-Addresses-of-Form-Submitters

    View this thread on browser » Unsubscribe Thread
    1437686332
    ...
  • Jeanette JotForm Support
    Replied on July 23, 2015 at 7:45 PM

    I can see that. In that case, you might want to share a report. Here is a section with several guides about it: https://www.jotform.com/help/chapter-6-Reports

    For example, you could create an Excel report and share it with your users, you can select the fields of your choice, including the IP address field.

    How to filter submissions by IP addresses Screenshot 20

    Here are more specific guides about the reports that might work for your special requirement:

    https://www.jotform.com/help/101-How-to-create-an-Excel-Report

    https://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report