Hello! Need help with Spreadsheet Widget.

  • saltadministration
    Asked on February 23, 2016 at 4: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

  • Chriistian Jotform Support
    Replied on February 23, 2016 at 10:40 PM

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

    Hello! Need help with Spreadsheet Widget Screenshot 40

    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)

    Hello! Need help with Spreadsheet Widget Screenshot 51

    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.

    Hello! Need help with Spreadsheet Widget Screenshot 62

    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.

     

     

  • saltadministration
    Replied on February 24, 2016 at 7: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!

     

  • saltadministration
    Replied on February 24, 2016 at 9: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

  • saltadministration
    Replied on February 24, 2016 at 9: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!

  • Boris
    Replied on February 25, 2016 at 6: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:

    Hello! Need help with Spreadsheet Widget Screenshot 20

    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.