What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to create filter using answers field using API?

    Asked by creswellcasey on June 05, 2017 at 03:42 AM

    Hello,

     

    I am trying to filter the submissions of a form using form's answer whose Id is 77.

    What key should I use? right now i used answers_77_answer:eq

     

    var client = new JotForm.APIClient(Helpers.EnvironmentVariables.JotFromApikey);

    Dictionary<String, String> submissionFilter = new Dictionary<string, string>();

     submissionFilter.Add("answers_77_answer:eq", Orderreq.SubmissionId);

    var submissions = client.getFormSubmissons(formID: Convert.ToInt64(jotformMenuId),filter: submissionFilter)["content"];

     

    I am getting all data. Filter is not working.

                

  • Profile Image
    JotForm Support

    Answered by Charlie on June 05, 2017 at 04:44 AM

    Hi,

    I presume you are using JotForm's API to fetch the submission and filter them? We have a separate forum page and contact for this types of concern. Please post your question in our developer's forum page here: https://developers.jotform.com/forum. You can also email our API team at api@jotform.com

    I'm also not familiar with the language you are using, but I see that in this API page section: http://api.jotform.com/docs/#form-id-submissions. There's an option to set a filter. 

    However, it seems like you can only filter submission ID, creation date and last update date, it was mentioned in this forum post: https://developers.jotform.com/forum/post/55b52d7e52ef185263000253. Although it was dated 2 years ago. It's best to confirm this with the API team. 

    Another possible way is to fetch all the submissions using the general API call and create a function or method to filter from that list.

    I hope that helps.