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...
Forum Discussion
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
------------------------------
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
------------------------------
- Hey Doug,
I appreciate your input. I haven't explored loops within QuickBase Pipelines yet. I'll do some research on that and see if I can figure it out. Thank you!
------------------------------
Shane Miller
------------------------------ - 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
------------------------------- 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
------------------------------- Doug,
That worked perfectly. Thank you for your help!
------------------------------
Shane Miller
------------------------------
