Forum Discussion

AnneMartin's avatar
AnneMartin
Qrew Trainee
2 years ago

Pipeline Advanced Query multiple conditions

I have a pipeline I'd like to trigger based on conditions from multiple fields.
These conditions work separately but I'm not able to get them to work together.
I used the syntax provided on this page: Quickbase Help

I need to use a query instead of the built in conditions because the first condition requires 2 date fields to match each other.

{35.ex.'_fid_7'}AND{36.ex.'true'}



------------------------------
Anne Martin
------------------------------

4 Replies

  • If you don't want to do the query Syntax you can make a helper field in native Quickbase and just filter on that being true.  But it's also possible that you are trying to learn the "proper" syntax.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AnneMartin's avatar
      AnneMartin
      Qrew Trainee

      I made a helper in native QB and was successful.
      I do wish I knew the proper syntax though.



      ------------------------------
      Anne Martin
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion

        The Quickbase Junkie has training videos, and many are free.

        Also, do you use any of the third-party add-ons from juice technologies? They have an awesome new tool they are about to release called query builder which completely dumbs down the process of building complex query strings.  

        Look in the second tab https://www.juicedtech.com/new-products-coming-soon



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------