Discussions

Expand all | Collapse all

Filters in Automations - multiple conditions?

  • 1.  Filters in Automations - multiple conditions?

    Posted 11-12-2019 12:45
    Looking for a solution/work around to have more specific filters in my automation.

    I want it to fire when any of two conditions are true, AND when any of three other conditions are true. Can this be done? Maybe with a second automation?

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


  • 2.  RE: Filters in Automations - multiple conditions?

    Posted 11-12-2019 13:16
    Edited by Mark Shnier (YQC) 11-12-2019 13:43
    Can you make a formula field to calculate to to true (checked) when the more complex conditions are met.  Then hook the Automation on that field being checked?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



  • 3.  RE: Filters in Automations - multiple conditions?

    Posted 11-12-2019 13:40
    Actually, that's exactly what I figured out 10 minutes after posting this.  I was just coming back to this thread to update my solution.

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



  • 4.  RE: Filters in Automations - multiple conditions?

    Posted 11-12-2019 13:45
    The same thing can happen in Quick Base for example on Role Permissions when you need more complex conditions that simple a single level ANDs and ORs.  So we just make a formula field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------