Value from Spreadsheet to form's field not being copied into text box.

  • AgilityAssoc.Canada
    Asked on February 5, 2021 at 12:13 PM

    Hi,

    RE: 210304415948957 - Value from Sheet-2-Form input not being copied into text box.

    On the first part of the form there is the sheet-to-form widget to validate a members number. I want to copy this value into #input_116. I am using logic I've used in the past but the value is not being copied.

    1612545040 601d7c1075342 copy=value Screenshot 10

    The validated field #id_116 is hidden. I wanted to use 'filled' logic to show the next part of the form. What am I doing wrong?

    Best, Robert

  • Ariel JotForm Support
    Replied on February 5, 2021 at 2:41 PM

    Hello,

    The Spreadsheet to form's field doesn't return a value thus can't copy its value. A workaround would be to add a Short Text field with a label matching that of the widget's Access code column header so it gets populated by the widget like so:

    161255403720210206 033845 Screenshot 10


  • AgilityAssoc.Canada
    Replied on February 5, 2021 at 3:47 PM

    Hi,

    Yes of course. This is not the first time that this has been pointed out to me... perhaps the third... maybe more, I don't remember... :(

    Oh well!... I guess at 73, my neurons at starting to fail me. Thank you for your help... Until next time...

    Best, Robert