Some data is not appearing in the Tables

  • Primes_Platform
    Asked on April 16, 2024 at 6:30 AM

    Hi


    In the attached sheet, i was trying to download the details in excel. However, many columns are appearing empty in the Excel sheet. These are mandatory columns in the form.


    Please support as the data is required for our financial calculations urgently

  • Angeli JotForm Support
    Replied on April 16, 2024 at 8:55 AM

    Hi Primes_Platform,

    Thanks for reaching out to Jotform Support. When I checked your form, it seems that you have a condition to Hide the below fields when the form is on edit:

    Some data is not appearing in the Tables Image 1 Screenshot 40

    And your form is set up to clear the values of the hidden fields upon submission:

    Some data is not appearing in the Tables Image 2 Screenshot 51

    So, the values of the fields above will be cleared or removed upon editing and submitting the submissions. To fix the issue, you can change the Clear Hidden Field Values to Don't Clear. Let me show you how:

    1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
    2. Click on Form Settings in the menu on the left side of the page.
    3. Change the Clear Hidden Field Values option to Don't Clear.

    Some data is not appearing in the Tables Image 3 Screenshot 62

    Give it a try and let us know if you have any other questions.

 
Your Answer