recordset not working with data populated from previous form

  • Resolved benspr

    (@benspr)


    7 years, 5 months ago

    Hi-

    I have two forms, call them id=”1″ and id=”2″. After submission of form 1, users are taken to a thank you page with form 2. I have correctly applied the solution from your website under the heading “Populate the form B with the data submitted by the form A,” and the data appears in fieldname1 of form 2 on the Thank You page, just as it is supposed to.

    But something else is wrong. I have a recordset field in form 2 with a CSV. Fieldname 2 is supposed to look up the entry in fieldname1 in the recordset and return a value. But the value is blank, and I can’t get it to work.

    Please advise.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello,

    The recordset are not submitted with the rest of form’s fields, because the recordset are only functional fields.

    Could you send me the link to the website, for checking the forms in action, please?

    Best regards.

    Thread Starter benspr

    (@benspr)

    Hi again,

    The recordset is actually part of the second form. In this case, I am able to get the field imported into the second form, but the corresponding recordset line text field doesn’t match the input.

    Here’s a link where a sample of the problem exists:

    https://solarpowerrocks.com/thank-you-calculator/

    Plugin Author codepeople

    (@codepeople)

    Hello,

    Assuming that the recordset get the data from a database, and that uses the fieldname1 field for filtering the results, furthermore, assuming that the fieldname1 is populated with the data received from the first form, you should insert a “HTML Content” field in the form with the following piece of code as its content:

    <script>
fbuilderjQuery(document).one('showHideDepEvent', function(){setTimeout(function(){ fbuilderjQuery('[id*="fieldname1_"]').change();}, 1000);});
</script>

    Best regards.

    Thread Starter benspr

    (@benspr)

    Thank you. I’ll try that. Should anything in that be different if the recordset gets data from a CSV?

    Plugin Author codepeople

    (@codepeople)

    Hello,

    If you are using the fieldname1 field (that is received from the first form) for filtering the rows in the CSV file, solution would be the same. Of course, if you are using a different field for filtering you should replace field’s name in the piece of code I sent you previously by the corresponding one.

    Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘recordset not working with data populated from previous form’ is closed to new replies.