-
byronmcwhinnieAsked on November 20, 2019 at 3:41 PM
Can I lock only some columns in a form using the spreadsheet function? I want the ones with formulas locked but the other ones open for data to be inputted.
Can I also have it only calculate to a certain number of decimal places? When I get emailed the form it shows that put when people are inputting the data I would like it to only go to two decimal places
Page URL: https://form.jotform.com/93235562048256 -
Richie JotForm SupportReplied on November 20, 2019 at 8:58 PM
It is possible to make a cell in your Spreadsheet widget read-only.
Example screenshot:This will disable the column 1 of Sieve Mesh and Weight.
Here is a screenshot to determine the cell column and row.
Please give it a try and let us know if you need further assistance.