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'}
Qrew LegendIf 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.
I made a helper in native QB and was successful.
I do wish I knew the proper syntax though.
Qrew LegendThe 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
I know we can use $prev for setting field values but can I access the previous value in the jinja format of the filter above? Something like {$prev.35.ex.'SUBMITTED'}AND{35.ex.'REJECTED'}
Anne,
Try this
{35.EX.'_fid_7'}AND{36.EX.'true'}
