Spreadsheet Widget: the possibility to get the value of a cell in the spreadsheet widget for calculation or condition

  • Profile Image
    tecknow
    Asked on November 01, 2021 at 11:43 AM

    How do you pass the value from spreadsheet cell to another field in the form



    This is a re-post of a comment on How to Set Up the Spreadsheet Widget?

  • Profile Image
    Basil
    Answered on November 01, 2021 at 12:53 PM

    Hi,

    When you name the sheet column the same as the name of the field labels, the data will be filled in the field when the user enters a correct access code.

    Guide for further information:

    https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget/#_

    Please let us know if you require any further assistance.

  • Profile Image
    tecknow
    Answered on November 01, 2021 at 10:51 PM

    I am sorry, I should have been more clear. I am talking about the Spreadsheet widget. Not the spreadsheeet to form widget.

    Can I pass values into and out of the Spreadsheet widget (like we do in the Input Table). Can those cells of the table be used in Calculation, outside the Spreadsheet.

    For eg. In my Spreadsheet widget I compute a Total of all cells of the column. Can this Total be displayed in a field on the Form.

  • Profile Image
    Ahmed
    Answered on November 02, 2021 at 03:16 AM

    Greetings,

    We apologize for this inconvenience, unfortunately it's not possible to access specific cell in Spreadsheet widget by calculation or condition unlike the the Input Table as you've mentioned which is possible to access its fields by form calculation or condition, I'll raise this issue to our developers team to consider adding this option to the Spreadsheet widget as new feature, although we can't provide estimates for when this feature would be implemented but you will be notified once we have an update.

    Thank you for your understanding and please let us know if you need further assistance, we are happy to help.