Conditional logic - multiple DO statements

  • Profile Image
    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.


    Richard Lovatt

  • Profile Image
    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.


    Sample form:

    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.


    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.