How to adjust the Spreadsheet field?

  • Susan Lynch
    Asked on February 12, 2018 at 2:34 PM

    I'm not able to adjust the width of cell 1A - all of that text needs to be visible. When a monetary value is added into cell 1B, you have to hit the "tab" key instead of "enter" for the calculation, that's not intuitive. I would also like the monetary figures to appear with $ signs in cells 1B and 2B. 

    Does anyone have any suggestions?

  • Nik_C
    Replied on February 12, 2018 at 3:22 PM

    1) First, you should remove the Custom code in Spreadsheet:

    1518466612Screen Shot 2018 02 12 at 9 Screenshot 10

    2) Add this Custom Code CSS to it:

    td.A {

        width: 265px!important;

    }

    td.B {

        width: 120px!important;

    }

    Increase the numbers if needed.

    3) increase the width of the table:

    1518466735Screen Shot 2018 02 12 at 9 Screenshot 21

    4) And increase the width of the form so it will fit the table:

    1518466790Screen Shot 2018 02 12 at 9 Screenshot 32

    Additionally, you could make the A1, A2 and B2 fields read-only, so your users cannot change it:

    1518466892Screen Shot 2018 02 12 at 9 Screenshot 43

    You can check my demo form: https://form.jotform.com/80426404780959

    Let us know if you need any additional assistance.

    Thank you!

  • Nik_C
    Replied on February 12, 2018 at 3:28 PM

    Additionally, I'm afraid that you cannot add $ signs to Spreadsheet since it will break the calculation. 


  • BCSDSocialMedia
    Replied on February 12, 2018 at 3:38 PM

    Wow, thanks Nik_C. 

    Can you tell me why I can't grab my form when I log out and log back in? It disappears when i try to find it and then disappears when I try to double-click on it?! Thank you!


  • David JotForm Support
    Replied on February 12, 2018 at 4:45 PM

    I checked your account and the form is accessible:

    1518471766Capture Screenshot 10

    I was unable to reproduce the issue of it disappearing.  If this is still occurring, let us know and we can open a new thread for that issue.