Not able to filter submissions based on the hidden Date field?

  • Profile Image
    Giovanni_Ahmad
    Asked on February 09, 2021 at 10:03 PM

    Hello,



    In my table Weehawken COVID-19 Vaccine preregistration.


    I have a hidden date field that i assign a date to in the back end via the table viewer.


    I can not filter it properly Please look at the column called first dose and try to filter by date it does not work properly.


    Thank You




  • Profile Image
    ashwin_d
    Answered on February 10, 2021 at 01:01 AM

    I did check your form, and it seems to be collecting the patient's health data. Please confirm if we can check form's submission data.

    Do you mean to say that when you add filter for first dose, it does not work? I have cloned your form, and it seems to work as expected. I was able to apply filter on the first dose field. Please check the screenshot below:

    1612936781_6023764d44b91_dateFilter.gif

    I would suggest you to please share a screenshot of the issue, and we will take a look. The following guide should help you how to upload the image in forum post: https://www.jotform.com/help/438-how-to-post-screenshots-to-our-support-forum

    We will wait for your response.

  • Profile Image
    Giovanni_Ahmad
    Answered on February 10, 2021 at 12:19 PM

    Yes you can access our database.


    and the date filter does not work on the first dose - it filters some and not others.




  • Profile Image
    FelipeSantana
    Answered on February 10, 2021 at 03:57 PM

    Hello @Giovanni_Ahmad,

    Thank you for the permission to access your Tables page.

    I did test the filter setting on your form using the "First Dose" Date field and it seems to be working correctly on my end. Here is a screenshot of the filter that I put into your submissions.

    1612990396_602447bc28702_

    As you can see, I have filtered the submissions to display the First Dose dates of February 12th, 2021 and it seems that all of the correct submissions as appearing. Can you kindly test this again and share which submissions are being left out?

    You can share the Submission ID of each submission that is not being filtered and we will gladly investigate this matter further. Related User Guide - Where-to-find-the-submission-id

  • Profile Image
    Giovanni_Ahmad
    Answered on February 16, 2021 at 05:46 PM

    Hi,


    We are still having an issue,

    Please look at the record for the following people

    1613515348_602c4a54c62aa_


    I modified Linda and the date comes up MDY , user jbaez@tow-nj.net modified Todd when she does is it comes up DMY.

    When a outside user fills the form " first dose" is a hidden field to them.

    Then myself or Jbaez will go to the tables and modify fist dose and give them a date on there.

    When I modify it date comes out MDY, when jbaez modifies it comes out DMY. i have changed her settings to US date etc , and still happens.


    Please help asap.


    Thanks

    Gio


  • Profile Image
    Jed_C
    Answered on February 16, 2021 at 09:35 PM

    Upon checking your data, it shows the correct date format when viewing the actual submission.

    1613529223_602c8087aacc3_Weehawken COVID

    You've mentioned that you have modified the data for Todd and Linda, kindly make sure that the First Dose date field has the format you want when filtering them as it's possible that the date format was change for the other while you have it filtered.

    1613529274_602c80ba65652_date.png