How to copy values from spreadsheet widget?

  • Profile Image
    cahillinspection
    Asked on August 03, 2019 at 08:03 PM

    Can I populate a text field with a cell from a table in the form? For example make text field 1 = cell r1,c-foundation

    https://form.jotform.com/92145928267163

  • Profile Image
    AshtonP
    Answered on August 04, 2019 at 01:26 AM

    Unfortunately, it is not possible to fetch the specific cell in the Spreadsheet widget using form calculation and conditional logic. 

    However, you can use the "Input Table" widget to replicate the behavior in the Spreadsheet widget, you just need to use Conditional Logic to calculate the values in the cell. Then you can simply fetch the cell that holds the total calculation in the "Input Table" and insert it in a Form Calculation widget. 

    Following help guides explains you on how to accomplish this:

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field 

    https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition 

    I hope this helps. Feel free to get in touch should you have further concerns.