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

    Editing Columns in SpreadSheet Widget

    Asked by HippoDaddy on October 03, 2014 at 11:14 AM

    Add discount line to form... see attached photo.

     

    Add another column for "Task #" - up to ten characters.

     

    Ability to show total in complete dollar format with dollars and cents.      

          Example: $245.50 or $200.00 and not $200 without the cents on there.

     

     

    Thank you for your help.

    Page URL:
    http://mortanmankc.com/forms.html

    Screenshot
    show total format attached and
  • Profile Image

    Answered by Shadae on October 03, 2014 at 12:02 PM

    Hi HippoDaddy,

    To confirm you would like to add an additional column to your table in the spreadsheet widget, along with adding a row that would be minus from the total?

    If that is the case, I have made the changes and this is the current result

    If this is your desired result you can clone my form

    To make the changes to your form please make changes in the SpreadSheet Widget Wizard

    In default values place:

    a1 Task#

    b1 Service Description

    c1 Cost

    b9 Discount

    b10 Total

    c10 = c2 + c3 + c4 + c5 + c6 + c7 + c8 - c9

     

    In Custom CSS place:

    div#spreadsheetContainer {

    width: 500px !important;

    }

    table {

    width: 500px;

    }

    tr.r1 {

    width: 250px !important;

    }

    .A input {

    width: 100px !important;

    }

    .B input {

    width: 250px !important;

    }

    .C input {

    width: 105px !important;

    }

     

    If you place the values in the spreadsheet with cents, it will be calculated with cent. Like this:

    However there is no way to currently make it default to show two decimal places. I have place that request in a new thread (http://www.jotform.com/answers/438252) so that it can be submitted as a request to our devs team.

    I hope this helps. Please inform us if you need additional assistance.

  • Profile Image

    Answered by Shadae on October 03, 2014 at 12:05 PM

    Hi HippoDaddy,

    You would also change the number value for the rows and columns in the Wizard

  • Profile Image

    Answered by HippoDaddy on October 03, 2014 at 01:55 PM

    Copied and pasted the exact code... and do not have the same look.

    Can you please tell me what I did wrong?

    Thank you for your help.

  • Profile Image

    Answered by Shadae on October 03, 2014 at 02:10 PM

    Hi HippoDaddy,

    I do apologize for that. The number value for the rows and columns in the Wizard as well.

    Like this

    The amount of rows can stay at 10 as well.

    I hope this helps! Please inform us if you need further assistance.

  • Profile Image

    Answered by HippoDaddy on October 03, 2014 at 02:15 PM

    No apology needed... i missed the extra step.

    Perfect... Thank you.

    Any way to change the color of the word "discount" in this example?

  • Profile Image

    Answered by Shadae on October 03, 2014 at 02:51 PM

    Hi HippoDaddy,

    I am happy that you got it to work as desired.

    Yes you can have the discount is red as well.

    Please place this code in Custom CSS

    #B9 {

    color: red;

    }

  • Profile Image

    Answered by HippoDaddy on November 10, 2014 at 04:11 PM

    The spreadsheet is working perfectly... and is a mandatory link that must be filled out.

    The problem is that not ALL the different headings must be filled out.

    Can row 2 all be made mandatory?

    Task #

    Service Description

    Cost

     

    Here is the link to the online form....

    http://mortonkc.com/forms-service.html 

    Thank you

  • Profile Image
    JotForm Support

    Answered by KadeJM on November 10, 2014 at 05:21 PM

    Your original question was asking about the formatting and now you are asking an additional follow-up question that is a separate issue so I have moved it here.