Forum Discussion

Qrew Cadet

3 years ago

Pipelines Question

Hello, I have 3 tables within the same App: 1. Claims 2. Report Summary 3. Report Summary Copy Thousands of claims will be funneled into the Claims table with many different company names and p...

DougHenning1

Community Manager

Hi Shane,

Search records step returns a list of records, so you either need a loop or if you know there's only going to be one you can reference the first record explicitly for both A and B:

{{a[0].Field_1 + b[0].Field1}}

If you will have multiple records for A or B then you need to add loops.

------------------------------
Doug Henning
------------------------------

ShaneMiller1

Qrew Cadet

3 years ago

Do you happen to know why I would be getting those errors I mentioned above? I've read it is because a field is not an integer, however, I have double checked and they both are in-fact numerical fields. Is the query-code I created within the Report Summary table that sums the values from the Claims table causing the issue?

------------------------------
Shane Miller
------------------------------

DougHenning1
Community Manager
3 years ago
The error is because you're trying to reference a field for a single object (a.Field_1 and b.Field_1), but A and B return a list of objects. You can add loops to fix:

A) Search a.Report Summary Table
For each record in A
    B) Search b.Report Summary Copy Table
    For each record in B
        - Update b.Report Summary Copy Table
           Field 1 on b.Report Summary Copy Table: {{a.Field_1 + b.Field_1}}
    End Loop B
End Loop A

Note the indenting is intended to show the steps are nested inside "For each" loops (e.g. Step B is inside the Step A "For each" loop.)

------------------------------
Doug Henning
------------------------------
- ShaneMiller1
  Qrew Cadet
  3 years ago
  Doug,
  That worked perfectly. Thank you for your help!
  
  ------------------------------
  Shane Miller
  ------------------------------