Conditional logic - multiple DO statements

  • Profile Image
    JuanMas
    Asked on February 26, 2021 at 02:48 AM

    Hello there

    I have recently taken over the management of our online forms and am looking for a more efficient way to manage the conditional logic we use to fill form fields.

    The first step by the form user is to make a selection from a dropdown list, which then drives several static text insertions into other form fields to guide the user's subsequent entries. This is achieved using multiple UPDATE/CALCULATE FIELD conditions, for each of the available drop down list options, to insert static text.

    At present, each static text insertion requires a separate UPDATE/CALCULATE FIELD condition which makes for a large and ungainly list of conditions to manage. Is it possible to create multiple DO statements in an UPDATE/CALCULATE FIELD condition?

    Grateful for any advice you might have for me.


    Cheers


    Richard Lovatt

  • Profile Image
    Richie_P
    Answered on February 26, 2021 at 06:36 AM

    Unfortunately, it is not possible to create multiple do statements in the Update/Calculate field condition.

    If you want to populate the field data with static data, you may use the spreadsheet to form widget instead.

    Guide:https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    Sample form:https://www.jotform.com/71642066575965

    If you want to implement this to your form, I would suggest cloning your form and use the spreadsheet to form widget in the cloned form to prevent submission deletion.

    Guide:https://www.jotform.com/help/27-how-to-clone-an-existing-form-from-your-account

    Please note that if you delete a field in your form the associated data will also be deleted.

    If you have further questions, let us know.