Forum Discussion

ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago

Alternative to form rules when making changes via Grid Edit

So I think it is pretty well known by now that form rules don't fire when making changes to records in grid edit form. My question is what is the alternative to automating changes? I guess the obvious...
Forms
Pipelines
Quickbase Automations
ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago
Hi Austin,

I have not hear of the Pipelines, I will have to look into those. As for what i am trying to do, there are 3 choices in a dropdown field of like 10 total choices that if any of the 3 were selected I would like the check box to go from unchecked to checked. So with a formula I could do something like:  If([Epic Compatible}="No", Yes) or something to that effect?

------------------------------
Chris Swirtz
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Can you tell us are the three valid choices where you want the checkbox to be checked and what is the name of the field that has the drop down?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • ChrisSwirtz2's avatar
    ChrisSwirtz2
    Qrew Cadet
    6 years ago
    The name of the dropdown field containing the 3 validation choices is [Epic Compatible]. And the 3 choices to select are as follows:

    No, Not compatible
    No, does not meet Epic's minimum specifications
    Will not be used with Epic

    ------------------------------
    Chris Swirtz
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Try this as a formula checkbox field

      [Epic Compatible] = "      No, Not compatible"
      or
      [Epic Compatible] = "No, does not meet Epic's minimum specifications"
      or
      [Epic Compatible] = "Will not be used with Epic"

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • ChrisSwirtz2's avatar
        ChrisSwirtz2
        Qrew Cadet
        6 years ago
        This works perfectly! Thank you!

        ------------------------------
        Chris Swirtz
        ------------------------------