Is it possible to pass a value from a spreadsheet widget?

  • Profile Image
    ncaaca
    Asked on August 07, 2019 at 10:28 PM

    Is there anyway to pass a value from a cell in a spreadsheet widget that I can use for calculation or payment?

  • Profile Image
    Kiran
    Answered on August 07, 2019 at 11:50 PM

    Unfortunately, it is not possible to pass values from the spreadsheet widget to an input field. As I tested, the spreadsheet widget is only passing all the field values in an Array format and only when any changes are made to the spreadsheet widget.

    You may perform calculation within the spreadsheet widget by setting up a formula for the specific field.

    156523622608082019_090837.png

    Thank you!