I need a Spreadsheet with large input in its first column

  • Profile Image
    menstrom
    Asked on October 29, 2019 at 09:25 AM

    I have a chart that I am trying to insert using the spreadsheet widget, but I need the first column to be very wide and to word-wrap to multiple lines, and I don't know how to use the Custom CSS within the widget to accomplish this.

    You can see the spreadsheet on the form with the extremely long text in the first column.

    Thanks,

    Marilyn

  • Profile Image
    Welvin
    Answered on October 29, 2019 at 12:45 PM

    Hello Marilyn,

    Unfortunately, you cannot change the input type in the Spreadsheet widget, so multi-line text is not possible there. You cannot change it as well with custom CSS codes. 

    You may consider using our Input Table for this purpose.

    Here's a demo form you can check: https://form.jotform.com/92126501968965

  • Profile Image
    menstrom
    Answered on October 29, 2019 at 06:09 PM

    Thank you!  This works very well!

    I clicked the button to make the cells Currency Textboxes, but it doesn't seem to matter.  It still lets me enter alpha characters, puts characters in flush left instead of flush right, etc.  So what does choosing Currency Textbox over just Textbox do?

    Thanks,

    Marilyn

  • Profile Image
    Kevin_G
    Answered on October 29, 2019 at 08:51 PM

    The user will not be able to submit the form if they enter letters in the currency field, they will get an error like this: 

    15723966192019-10-29_18h48_42.png

    It will work properly if you enter only numbers or a currency sign: 

    15723966972019-10-29_18h49_00.png

    Please kindly give it a try and let us know how it goes. 

  • Profile Image
    Welvin
    Answered on October 31, 2019 at 10:37 AM

    Hello Marilyn,

    Unfortunately, our validation will only work on the online form. The printed form cannot validate unless you will get the PDF version of the form, which requires a PDF reader to fill.

    The following guide will help you get the PDF document: 

    https://www.jotform.com/help/555-Applying-Form-Submission-Data-into-a-PDF-Document