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

    Unintended spaces appearing in jotform generated .pdf files

    Asked by Manny on March 26, 2012 at 02:26 PM

    We copy/paste data from our jotform generated .pdfs into our database.  Intermittently, the data - appearing normal when viewing the .pdf - will paste into our database fields (and other applications) with unintended spaces added.  

    We view the .pdf files with the preview application in a Mac environment.  

    An example pasted from a .pdf we received shows a website URL submitted that looks normal on the pdf, but when pasted, appears like this:


    www .s o uls hif t mus ic .ne t 

     

    Pasting the same data into a text file, or other documents appears the same.

    Any help you can give us would be greatly appreciated.   If you would like to see the .pdf example,  I can email it. 

    Manny

    Page URL:
    http://www.jotform.com/form/13105057250

  • Profile Image
    JotForm Support

    Answered by Mike_T on March 26, 2012 at 04:54 PM

    Thank you for contacting us.

    I was able to reproduce the problem. Now I have forwarded this issue to our Development Team. Once we get any more information for you we will update this thread.

    In the meantime you can copy the text from Submissions page.

  • Profile Image

    Answered by Manny on May 25, 2012 at 01:20 PM

    Figured I'd check back in to let you know we still see the issue, though not as frequent.  Wondering if there was any more info from your dev team?

    Working from the submissions page unfortunately is not as conducive to our workflow as we need it to be, as there is often large amounts of text in certain fields as well as attached files to manage.  Working out of a dropbox with the pdf + files is how we're most effecient for this form. 

    Thanks for any info and for the helpful support.  It's definitely appreciated.

  • Profile Image
    JotForm Support

    Answered by jonathan on May 26, 2012 at 04:50 PM

    Hi Manny,

    Is there a way for you to trim the copied text data before you paste them to the database field?

    Example, you can make the text data pass thru a temp repository(table/fields) -- and get the white spaces trimmed (in SQL there is trim, ltrim,rtrim command), then plugged it to the final databse field.

    There are also some scripts that can trim spaces from a text file(if you put the text data on a notepad..). 

    Some javasript code look this... (this trim white spaces on a string data)

    function trim11 (str) {

    str = str.replace(/^\s+/, '');

    for (var i = str.length - 1; i >= 0; i--) {

    if (/\S/.test(str.charAt(i))) {

    str = str.substring(0, i + 1);

    break;

    }

    }

    return str;

    }

     

    Unfortunately, this problem is too rare and very intermittently reproduce to warrant priority over more persistent issues that our developers are handling at the moment.

    Nevertheless, you will still be informed if an updates regarding the ticket becomes available.

    Thank you for your understanding and continued support.

  • Profile Image

    Answered by 1oclock on February 17, 2013 at 09:05 PM

    I'd like to bring this issue back to the forefront. This happens EVERY time on my forms, specifically with URLs, but also with text as well. Coping from the submissions page is not particularly convenient as I upload the PDF into our CRM which is far more accessible. If you can't offer a PDF that doesn't have this issue, please stop offering that function until you can offer a function without bugs.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by EltonCris on February 18, 2013 at 02:08 AM

    @1oclock

    We'd appreciate if you could open a new thread for your issue. This helps us escalate to our development team without touching this old thread. Please provide more details and a screenshot if possible. So far on my tests, I wasn't able to replicate  the problem. Thanks!

    Thanks!