Spreadsheet Widget: add Decimal functionality

  • Profile Image
    CTec
    Asked on March 09, 2021 at 04:51 AM

    Please view my form:

    https://form.jotform.com/210343973935056

    Can the spreadsheet not be clicked on, apart from the No. column?

    Also, can we show the final column to 2 decimal places?

  • Profile Image
    Sara_G
    Answered on March 09, 2021 at 06:36 AM

    Hi,

    Thanks to contact us.
    If I have correctly understood your request, you wish to be able to click on the spreadsheet from Tables, not just from the column.
    If so, please from the 'Submission Date' column, click on the 'View' button. You will see on the right of the screen a page with the details of the submission, including the spreadsheet. Now click on spreadsheet to open it, as shown below:

    127474_view%201.png

    127475_view%202.png

    127476_view%203.png

    Further details are available here: https://www.jotform.com/help/269-how-to-view-form-submissions

    Regarding your 2nd request, unfortunately, CSS can't change the decimal points function on the Spreadsheet widget.

    However, if you require we can forward your request to our Dev Team for future implementation.
    Please note that we are not able to confirm exactly an ETA of their update.

    For further requests, please let us know.

  • Profile Image
    CTec
    Answered on March 09, 2021 at 06:55 AM

    Hello,

    You have misunderstood my query,

    Currently, you can click the spreadsheet and see formulas. Can we disable this?

    See screenshot, the user of the form can change the values in any field.

    1615290864_604761f0de807_Form3.PNG


    Please forward the decimal request, if possible.

  • Profile Image
    Sigit_W
    Answered on March 09, 2021 at 07:51 AM

    Greetings,

    If you would like the cells to be read only, kindly make changes to the Spreadsheet widget settings. Type in "All" in Read-only

    1615294010_60476e3ae8e34_

    Regarding "Please forward the decimal request, if possible."

    I will be creating a feature request ticket to our developers for possible implementation. Please note that we can't give an ETA for when this will be implemented. Feature requests depend on the workloads of our developers and popularity among our users. But rest assured, we will inform you via this thread once this feature becomes available.

    Regards.

  • Profile Image
    CTec
    Answered on March 09, 2021 at 07:55 AM

    Hello,

    I don't want all the cells to be read only, I want Column C to be editable apart from the headings in red.

  • Profile Image
    Sigit_W
    Answered on March 09, 2021 at 08:06 AM

    Greeting,

    It is possible to make a cell in your Spreadsheet widget read-only.

    Example screenshot: This will disable the column 1 to 14 of £Trade Total

    1615295062_6047725614c55_

    You can change the which column to disable according to your needs. Please give it a try.

    Regarding "Please forward the decimal request, if possible." Could you provide more details of your request.

    Thank you. Regards.

  • Profile Image
    CTec
    Answered on March 09, 2021 at 08:31 AM

    Thank you, I have added the read only to certain cells.

    The decimal point request was for the last column (e). Prices that are whole numbers are shown as £239 rather than £239.00.

  • Profile Image
    Richie_P
    Answered on March 09, 2021 at 08:59 AM

    Currently decimal places function is not possible in the Spreadsheet widget.

    I have forwarded a feature request to our developers.

    Please note that we cannot give an ETA when this feature would be added or will it be passed however, once we have updates, you will be notified at this support ticket.

    Thank you.