How to make cells read-only on spreadsheet widget?

  • Profile Image
    mklinks
    Asked on September 26, 2019 at 07:55 PM

    Hi

    I am using spreadsheets on my forms, Could you please advise how to only accept numeric values with 2 decimals on some of the cells?

    Some of the cells are to collect data from the users and other cells have the formula to obtain percentage, but the results have too many decimal digits

    Also, Is it possible to make the user note in any way by adding colour to the background or fonts or blocking the cells, to only add data to some cells and do not input data on the formula cells?

  • Profile Image
    AshtonP
    Answered on September 26, 2019 at 09:23 PM

    You can use the Read-Only option on spreadsheet widget. Here are the steps to make your cells read-only:

    >> Go to Widget Settings > Scroll down > add all the cells that you want in the read-only mode under Read-only section > Click on update widget.

    Here is a screenshot form reference:

    1569547130The Easiest Online Form Builde

    And you can add a text message for users filling out the form that the value to be entered should be numeric only. The question text in your widget is empty so you can take advantage of that and place in the text message there.

    1569547381ssssss.png

    Here is a demo form: https://form.jotform.com/92687897158986

    Feel free to reach us in case you have any further questions.

     

  • Profile Image
    mklinks
    Answered on September 26, 2019 at 09:46 PM

    Thank you for your reply.


    On my '% Kg' cells, How can I round up the decimal digits to 2 digits only?
  • Profile Image
    Girish
    Answered on September 26, 2019 at 09:50 PM

    Hello @mklinks,

    I've moved your last query to a new thread and will answer that shortly. Here's the new thread link: https://www.jotform.com/answers/1980157