Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
2 years ago

Best solution for this dynamic form rules need? Change field when one modified.

I've long struggled with the best way to accomplish this. I've tried a few things and don't love any, and I am wondering what other people do.

I have a multiple choice field, that I want to use a dynamic form rule to change, dependent on other fields changing. The issue is this:

If I say, when Field A is not blank, change Multiple Choice to X selection, that works. However, if I accidentally choose wrong, and change field A, it does not update my multiple choice field.

I can't uncheck the box at the bottom (fire only when changes) because there are multiple rules to change the multiple choice. If that is selected, then the other rules are over ridden dependent on order.

Truthfully, I need a, 'When Field A Changes' condition, but that doesnt exist. Or I need to only fire it once the record is saved, BUT only if Field A was changed during that edit.

What solutions have others come up with?

------------------------------
Mike Tamoush
------------------------------

2 Replies

  • Try starting the rule with 
    When the record is saved

    You should be allowed filters like

    Field A has been changed

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MikeTamoush's avatar
      MikeTamoush
      Qrew Commander
      You have got to be kidding me. Almost 3 years of building and I never noticed that.

      And this is why you have a QB cape and I do not.

      ------------------------------
      Mike Tamoush
      ------------------------------