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

    Hello! Need help with Spreadsheet Widget.

    Asked by saltadministration on February 23, 2016 at 04:29 PM

    Hello,

    I'm trying to create a spreadsheet widget which would enable the user to create AND submit a syllabus for a class. I know that these are very specific changes, so whatever you can help me with, I would be thrilled!

    So, I need the 3 column headers to read, "date", "class material", and "homework".  Then I would need to make the background color of the row and column headers to be something other than black to save on ink when printing.  I would also need to make the cells to be active for the user, but make the "date" column cells to be read-only.

    Is there a way to change the row numbers to be changed for the 2nd semester. For example, the 1st row for the second semester would need to read "18" not "1".  Does that make sense?

    And lastly,

    is there a way for someone to fill out the form (with this widget) and then be able to edit the syllabus they already submitted as needed at a later date?  Or would they have to start from scratch?  I should have asked this question first.  If they can edit a submission, it's a moot point.

    Thanks so much for your help!  Your support is superb!  Just an fyi, if there was a way to create a "syllabus widget" you would make many out there in the educational world so happy!  People could create and submit their forms to a institution and then the institution could save those submissions and keep them on file!  I love that idea!

     

    Jen Browder

    SALT Homeschool Co-op

    spreadsheet widget Submissions educational create fill
  • Profile Image
    JotForm Support

    Answered by Chriistian on February 23, 2016 at 10:40 PM

    1. To create the 3 columns needed, first click the wand icon beside the widget.

    Then input the default values that will be shown in their corresponding cell.

    Default values: a1 Date, b1 Class Material, c1 Homework

    Read-only: a1, a2, a3, a4, a5, a6, a7, a8, a9, a10,  (this way, the cells are read-only)

    2. To make the background color of the table to white, you simply need to inject the following code:

    th {

        background-color: white!important;

        color: black;

        border-color: black!important;

    }

    You can do so by first clicking the wand icon again. Then on the widget wizard, click the Custom CSS tab and paste the code on the text area. Click Update Widget to save changes.

    3. Unfortunately, the row number for the 2nd semester cannot be changed from 1 to 18. The row will have to start at 1 again.

    4. To better assist you with your concern regarding submissions, I have moved that question to another thread. To see that thread, simply follow this link: http://www.jotform.com/answers/779652 

    Here's a link to a sample form so you can see the spreadsheet in action: https://form.jotform.com/60538287413963

    You can also clone it to your account by following this guide: How To Clone A Form

    Do let us know if you need further assistance.

     

     

  • Profile Image

    Answered by saltadministration on February 24, 2016 at 07:57 PM

    Wow!  You guys never cease to amaze me!  I have yet to find a problem that you can't fix or find an answer for me!  Love, love Jotform!!

     

    Thanks!

     

  • Profile Image

    Answered by saltadministration on February 24, 2016 at 09:28 PM

    Ok, I have another couple questions.  I was able to create the perfect form for the task at hand. But, there were two glitches.  1. The pdf created did not include the spreadsheet.  This is critical for what I'm trying to achieve which is a submission with their syllabus (in spreadsheet form).  2. The spreadsheet is cut off at Week 13.  There are 34 Weeks in the year.  Is there a limit to the amount of things you can have on the spreadsheet?  Ok, there is one more bonus question...  

    Is there a way to wrap text so that words are kept on one line or another and not broken into?  I found the custom css (with your wonderful forum) to create text wrap, but it will break a word into when it runs out of room.
     Thanks so much for your help!  I love Jotform!

    Here's a link to my form...

     

    https://form.jotform.com/saltadministration/2016-syllabus

  • Profile Image

    Answered by saltadministration on February 24, 2016 at 09:40 PM

    Ok, sorry.  I found the fix for the 2nd question.  It was a mistake on my part.  So, I only need to figure out the text wrapping and how to include the spreadsheet in the pdf.

     

    Thanks!

  • Profile Image
    JotForm Support

    Answered by Boris on February 25, 2016 at 06:05 AM

    The spreadsheet widget should by default be included in the PDF that is generated for your submissions. I have cloned your form into my account, made a test submission, and this is the PDF that was generated by default:

    https://submit.jotformpro.com/server.php?action=getSubmissionPDF&sid=332206600721784697&formID=60552134294957

    As you can see from the PDF, the spreadsheet widget is in there - albeit on the second page because it didn't have enough room on the first page of the PDF:

    In order for the spreadsheet to show in your PDF, you must enter some data into it on your form. I see in your submission that you have filled other fields, but left the spreadsheet empty. That is why it wasn't shown in the generated PDF.

    In order to avoid confusion, we highly recommend posting one question per thread. For this reason, I have split your bonus question about text wrapping here:

    http://www.jotform.com/answers/780881

    We will be assisting you with it there, shortly. Thank you.