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

  • Profile Image
    AgilityAssoc.Canada
    Asked on February 05, 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.png

    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

  • Profile Image
    Ariel_P
    Answered on February 05, 2021 at 02: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.jpg


  • Profile Image
    AgilityAssoc.Canada
    Answered on February 05, 2021 at 03: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