Forum Discussion

AndrewFry's avatar
AndrewFry
Qrew Assistant Captain
6 years ago

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
------------------------------
  • AndrewFry's avatar
    AndrewFry
    Qrew Assistant Captain
    Nevermind. I figured out the issue.

    I had added an additional field that was messing with my formula. It had nothing to do with the dynamic form rule.

    ------------------------------
    Andrew
    andrew.fry25@gmail.com
    ------------------------------