How can I isolate a single column of entries in a report?

  • lukeo25
    Asked on March 10, 2018 at 3:10 PM

    Hi

    I am using ajax to pull the data from a form. I use the form id and the API code to do this, it works fine but.... I was wondering if I can go one further and pull a particular value like the persons first name.

    Is this possible?

    Cheers Luke

  • Jan
    Replied on March 10, 2018 at 5:20 PM

    You can use API to capture the submission data. Please check this link: http://api.jotform.com/docs/#submission-id.

    You can get all of the field IDs in the form using this API URL: http://api.jotform.com/docs/#form-id-questions.

    If you are having any issues with the API, please contact our API team at api@jotform.com.

    You may also use Webhooks. Please check these guides: How-to-Setup-a-Webhook-with-JotForm and Webhook-PHP-Script-Examples.

    Hope that helps. Thank you.

  • lukeo25
    Replied on March 10, 2018 at 6:17 PM

    Thanks Jan,

    I noticed that the questions also have an id. Where / how do I find those ids?

  • Elton Support Team Lead
    Replied on March 10, 2018 at 9:32 PM

    You can actually get them in the same URL http://api.jotform.com/docs/#form-id-questions. Enter your form and your API key to get the questions IDs.

    The first number that holds the data is the question ID (qid)

    Example:

    How can I isolate a single column of entries in a report? Image 1 Screenshot 20

  • lukeo25
    Replied on March 11, 2018 at 5:48 AM

    Thanks Dude,

    This is very helpful indeed

    Luke

  • Jan
    Replied on March 11, 2018 at 7:04 AM

    Glad to hear that the answer provided by my colleague resolved your issue. If you need any help, please do not hesitate to contact us. Thank you.