Editing Columns in SpreadSheet Widget

  • Profile Image
    HippoDaddy
    Asked 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.

  • Profile Image
    Shadae
    Answered 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
    Shadae
    Answered 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
    HippoDaddy
    Answered 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
    Shadae
    Answered 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
    HippoDaddy
    Answered 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
    Shadae
    Answered 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
    HippoDaddy
    Answered 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
    KadeJM
    Answered 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.