Hidden Fields are Lost in the Spreadsheet Log and Email Fields

  • PESJotForm
    Asked on March 30, 2020 at 3:50 PM

    I have a condition that i created to hide certain fields when the url link contains "edit."  I used this for a customer approval.


    The fields that hide no longer show up in the spreadsheet log and are gone.  They do not show up in the email fields either.  Is there a way to keep the values even though they dont show up "edit" form?

    Jotform Thread 2233188 Screenshot
  • KrisLei Jotform Support
    Replied on March 30, 2020 at 7:05 PM

    Hi,

    I assumed that you are referring to this form, 82066322090146 correct? I checked and cloned your form also checked the submission page, it seems that the hidden fields are still showing on the submission page:

    1585609075hide field Screenshot 10

    Kindly try to slide it to the right, it seems that the columns for those fields are at the least part of the sheets. 

     Is there a way to keep the values even though they don't show up "edit" form?

    I'm not sure if I understand it correctly, you mean you would like to make those fields visible even if the URL does not contain "edit"? If so, you can just delete the Hide/Show condition on those fields.

    Please provide us more information if you are referring to a different query. 

    Looking forward to your response. Thank you.

  • Clayton
    Replied on March 30, 2020 at 7:40 PM

    The hidden fields will not show up in an email when I insert them.  The come up blank in the email and do not show in the spreadsheet.

    The last submission that worked had my hidden field conditions command turned off.  Could you try with this one turned back on?

  • Clayton
    Replied on March 30, 2020 at 7:42 PM

    The field on the spreadsheet image you sent has blank fields on the 2nd and 3rd to last submission.  Thanks.

  • PESJotForm
    Replied on March 30, 2020 at 7:58 PM

    I just did an entry and the hidden fields are deleted in the spreadsheet and the email response does not go out because this field is hidden.  thanks.

  • Kevin Support Team Lead
    Replied on March 30, 2020 at 11:20 PM

    Thanks for providing more details, I have reviewed your form and checked the conditions, it seems like you're hiding the fields based on the Get Page URL widget:

    15856230342020 03 30 20h49 39 Screenshot 10

    As I understand, the issue happens with the fields related to the "If Get Page URL contains edit", may you confirm? 

    Your form is also configured to do not clear the hidden fields, but also I noticed the field "Account Only: Status?" is empty. Now, upon checking the first condition that hides fields if the "edit" is on the URL, I can see the "Status" field is being hidden:

    15856246712020 03 30 21h14 31 Screenshot 21

    Note that this condition conflicts with the following:

    15856248102020 03 30 21h19 48 Screenshot 32

    Please kindly remove the field from the condition related to the Get Page URL widget and let us know how it goes.