-
JuanMasAsked on February 26, 2021 at 2: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
-
Richie JotForm SupportReplied on February 26, 2021 at 6: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.