- GlenbowMuseumAsked on September 18, 2012 at 03:18 PM
I've been trying to create a form to replace another of our old paper forms. On the paper form there is a section that is essentially a small spreadsheet.... multiple rows or columns. The closest component I could find that might work was the "Matrix" one.
It works 90% however in any one of the cells in the first column ( a description essentially) it can be quite short or quite lengthy.... on occasion it then splits lines right in the middle and the text is then un-readable.... (as shown in the attachment).
My questions are:
1. Is there a better method to emulate a small spreadsheet? (it does not need to do any math)
2. If not, is there a way of preventing it from splitting a line in the MIDDLE.... top half on one page, and the next half on the next page? I considered using page breaks, but that doesn't work because I never know how much text they may enter in to those cells.
Hope someone has a solution......
- fxrAnswered on September 18, 2012 at 05:44 PM
I am not quite sure which of your forms you are working on?
I am thinking we could add some Custom CSS to widen the content on the left, but would have to see the form to be sure.
Also, is this black line appearing on the form itself or after its been printed out?
The form is called Photographic Requisition....... There is no printing involved at this point, that is how it looks on-screen. That is a cut&paste of the PDF created from a test submission.
I've already played with the width of tables/cells and widened them as you suggest but it does nothing to help. If the person entering info in to the Matrix types an appropriate amount, it will still happen. I'm a bit stumped. Feel free to have a look.
I also considered using a bunch of 1-line "Matrix" components, but I haven't tried that yet as it will be "messy" at best. I've searched the forums here and have not heard of anyone with the same issue.... so either I am doign something weird ... or no one uses it like this *shrug*
Appreciate any help, thanks.
- JotForm SupportDeygusAnswered on September 18, 2012 at 06:49 PM
At this point I think that it may be possible to do this by trying to separate the data out of the larger table and froming it into smaller questionares that are more streamlined and then sending it a google spreadsheet which would post data to keep track of it for you.
This may be a possibility with Google Docs Integration. Unfortunately it may not appear as the picture since it would be broken down more.
Nah, that doesn't work for us at all.......
There's no better answer as to why it is splitting a single line in to two on two pages????? That is "normal"? I can't even understand that, as it seems like it would be a real issue.
Anyway, it is what it is, if we can't use JotForm for this form... life goes on. I am surprised though........
- JotForm SupportliyamAnswered on September 19, 2012 at 01:09 PM
Hello, just to make sure I'm understanding the case. Is this of downloading the PDF from the submissions page?
I just tried testing a download and the characters does not seem to get cut off. Can you try downloading again the PDF file and tell us that this is still the case?
- glenbowmuseumAnswered on September 19, 2012 at 01:52 PM
You are correct, the screenshot I've posted is of the downloaded PDF. Your test is working because you are not matching the screenshot I've provded (at least from waht I've seen). You are typing in a single word in the "cells". Try typing in 3 or 4 sentences, as in the example I've shown.
wow... sorry about the "spam" not once did it post... IE sat here like it was trying to post something and never did anything..... please delete the duplicates.....
- JotForm SupportMike_TAnswered on September 19, 2012 at 05:55 PM
We will see if we can do something with this matrix bug.
In the meantime, I would suggest trying the following workaround. Go to your Submissions page, click on the Print icon, and simply print it to the PDF file. That PDF will be formatted differently from the default Submission PDF file.
- GlenbowMuseumAnswered on September 20, 2012 at 10:25 AM
Appreciate the effort, but you do realize:
1. That is software on your client (not functionality everyone has) allowing you to print to a PDF.
2. I've downloaded and installed 3 different "PDF Printers" including Primo PDF (which I've used in the past) and Nitro PDF. Both results do not work as you describe at all.... they print a PDF of the webpage (submissions page) which only includes a small portion of the form...... (like the image...)
Did you even complete the process and see the results, or does yours somehow work differently? Can you show me how yours looked when using that method?
Scrap the image comment above, apparently I cannot include an image in a reply.... *sigh*
- JotForm SupportliyamAnswered on September 20, 2012 at 10:58 AM
If I'm not mistaken, Chrome has this feature where it has the print to PDF option without you needing to install softwares for this.
Anyhow, I have tried to download the PDF document from your submissions page. I was not able to replicate the screenshot that you shared.
Furthermore, you can insert an image on your reply, provided that you should upload the image somewhere, get the link, and then click on the tree icon on the reply content here to be able to insert the image.
After clicking the icon, a pop-up will appear where you can insert the image URL.
Clicking insert will make the image appear on the editor here.
- GlenbowMuseumAnswered on September 20, 2012 at 11:13 AM
Thank you, I did not realize Chrome had it built in. I've now been able to duplicate your results using Chrome..... I use IE and Chome interchangably depending on what I am doing. I had only tried in IE at that point. Sadly though, the people actually making use of this form will be IE exclusive. It will work short term... I'll carry on with the rest of the form now.... but it sure isnt as elegant as previous forms have been....
I did see the button to insert an image but did not want to put that image online, just to reference a URL... when originally posting you are able to upload a file from the PC, when responding it forces a URL......
- JotForm SupportliyamAnswered on September 21, 2012 at 03:09 AM
Hello GlenbowMuseum. I also tried downloading the PDF using IE8 and I still was not able to replicate the screenshot you shared. Can you provide us more details as to what IE version you're using? It would also help if you can share with us the name and version of the Operating System that you're using.
- guest_22636903376054Answered on September 21, 2012 at 11:50 AM
Well I am using Win 7 and IE 9....... (at least generally). I can only duplicate the above results on occasion, it really only happens if the form is submitted when the matrix contains "just the right amount of data". So it does not happen all the time.
I'm beyond that now and don't care so much as it seems infrequent from further tests.... I am having a second issue now (that is also minor). Once we decdided to proceed despite the unusual behaivour, I added the remaining fields below the matrix..... when filling out test data, and submitting it, the email only shows the information to the end of the matrix, and nothing beyond that.... yet the PDF shows all the information, even the new fields below the matrix..... any ideas?
- JotForm SupportEduardoMendezAnswered on September 21, 2012 at 12:06 PM
Can you please start a new thread for this question? Also, can you please provide us the form URL so that we can take a closer look at the issue? We'll be glad to assist you!
- guest_22636903376054Answered on September 21, 2012 at 12:37 PM
The link to the form should be https://secure.jotform.ca/form/22614909052249
I am going to run another test, maybe 2, but it seems the HTML portion at the bottom isnt included in the PDF or email.... it is weird...
- GlenbowMuseumAnswered on September 21, 2012 at 12:50 PM
the more I try to fix one thing the more frustrating this form becomes.....
I moved some of the fields that WERE below the Matrix, to a more logical position ABOVE the matrix....... there is also an HTML component below the matrix, none of these changes seem to be refelcted in the email notification, ... the PDF reflects most of the changes EXCEPT the HTML still does not appear at all.......
- GlenbowMuseumAnswered on September 21, 2012 at 12:52 PM
also... I decided to put in a "page break" after all of the top information, and above the matrix to ensure the matrix started out on a new page.......... that works "fine" when filling out the form, but has no affect on the email or PDF.... the matrix still starts in the middle of a page....... is that normal?
- JotForm SupportNeilVicenteAnswered on September 21, 2012 at 03:54 PM
the PDF reflects most of the changes EXCEPT the HTML still does not appear at all
Submission PDF files cannot display HTML fields. If you'd like to have text information displayed on the PDF, you must use a hidden box instead. It can be found under the Power Tools section.
Set as the default value of the hidden box the custom text that you want to display.
.... the matrix still starts in the middle of a page....... is that normal?
Indeed, that is its normal behavior. Like what I have mentioned in the other thread you have opened today, the submission pdf is generated independently.