-
CTecAsked on March 9, 2021 at 4: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?
-
Sara_GReplied on March 9, 2021 at 6: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: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. -
CTecReplied on March 9, 2021 at 6: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.
Please forward the decimal request, if possible.
-
Sigit JotForm SupportReplied on March 9, 2021 at 7: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
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.
-
CTecReplied on March 9, 2021 at 7: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.
-
Sigit JotForm SupportReplied on March 9, 2021 at 8: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
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.
-
CTecReplied on March 9, 2021 at 8: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.
-
Richie JotForm SupportReplied on March 9, 2021 at 8: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.