AndrewFry
6 years agoQrew Assistant Captain
Unusual Behavior: Formula Field & Dynamic Form Rule
I have a text formula field that lists all the required fields in a form that need to be filed out by the user.
I don't have the fields marked as required in the form (the red asterisk) as I do need the form to progress in the process flow even if it is missing some "required" fields. However, the process will stop at a certain point if the fields are not filled in and will not be allowed to continue, thus forcing the user to complete the form.
As the fields are filled in, the formula automatically updates, listing only the fields that are still missing. Worked great until recently.
Recently, I added a dynamic rule that stated basically:
If the contents of field A are 123 then select Custom from field B.
Field A is a drop down list.
Field B is a multi-select list.
When the Dynamic form rule runs, it work great in that it pre-fills field B with "Custom".
But I noticed that my formula field is not picking up the change and still acts as if field B is blank, even though it has a selection in it.
If I clear out field B and then manually select Custom, it works fine and the formula updates.
Any thoughts as to what is causing this unusual behavior?
I would think that whether field B is manually filled in or automatically filled in via a dynamic form rule, the formula text field would recognize the value has change from a blank field to a non-blank field.
Seems strange to me .....
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
I don't have the fields marked as required in the form (the red asterisk) as I do need the form to progress in the process flow even if it is missing some "required" fields. However, the process will stop at a certain point if the fields are not filled in and will not be allowed to continue, thus forcing the user to complete the form.
As the fields are filled in, the formula automatically updates, listing only the fields that are still missing. Worked great until recently.
Recently, I added a dynamic rule that stated basically:
If the contents of field A are 123 then select Custom from field B.
Field A is a drop down list.
Field B is a multi-select list.
When the Dynamic form rule runs, it work great in that it pre-fills field B with "Custom".
But I noticed that my formula field is not picking up the change and still acts as if field B is blank, even though it has a selection in it.
If I clear out field B and then manually select Custom, it works fine and the formula updates.
Any thoughts as to what is causing this unusual behavior?
I would think that whether field B is manually filled in or automatically filled in via a dynamic form rule, the formula text field would recognize the value has change from a blank field to a non-blank field.
Seems strange to me .....
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------