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

    Spreadsheet widget displays all cells including blank on autoresponder

    Asked by HippoDaddy on September 15, 2014 at 03:16 PM

    This is what I get on the auto responder...


    Services [[" ","#","A","B"],[" ",1,"Service Description","Cost"],[" ",2,"Description line 1 test","250.00"],[" ",3,"Line description test 2","18.25"],[" ",4,"",""],[" ",5,"",""],[" ",6,"",""],[" ",7,"",""],[" ",8,"",""],[" ",9,"",""],[" ",10,"Total",268.25]]


    Any way to clean this up so it just shows the line and the amount?


    Thank you.

  • Profile Image

    Answered by Ben on September 15, 2014 at 05:04 PM


    Can you please let us know if that is exactly what you get in the email (it looks like a plain text)?

    When I have submitted the form cloned from your form it sent me an email with values nicely presented.

    I understand that you have asked if you could hide the empty fields, but as you can see the layout above is quite nicer to follow than the text only version, so if you are getting the response in a plain text format do let us know to see how we can fix that for you.

    I believe that you can remove your JotForm autoresponder and create a new one and leave it on default. It should then show you a nice looking submission.

    Best Regards,