Forum Discussion

AmyGosz1's avatar
AmyGosz1
Qrew Trainee
3 years ago

Jinja to compare values of fields in two different tables

I have a Pipeline that when a record is created or updated in a table, I need to search a second table to find the Project Code that matches from the created record, then update a field in the second ...
DonLarson's avatar
DonLarson
Qrew Elite
3 years ago
Amy,

You can find the record you need with out Jinja.   Assuming that the two fields are

[Code in Table One]  Field ID 10
[Code in Table Two]  Field ID 20

In the Advanced Query of your Search Step on Table Two you would put

{20.EX.'{{a.code_in_table_one}}'}

This is the Quickbase Query not Jinja.  You can read more here:

https://helpv2.quickbase.com/hc/en-us/articles/4418310913684

------------------------------
Don Larson
------------------------------
  • AmyGosz1's avatar
    AmyGosz1
    Qrew Trainee
    3 years ago
    Worked perfect! Thank you Don!

    ------------------------------
    Amy Gosz
    ------------------------------