Conditional logic - multiple DO statements

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

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.