Skip to main content
Question

Iterable Record Object

  • November 7, 2022
  • 0 replies
  • 50 views

Forum|alt.badge.img+15
I am using a Pipeline to search for records
Get the value of a Formula Numeric Field
Sum and write that value in another record.

The error message I am getting is:

Validation error: Incorrect template "
{{b|sum(attribute='total_event_bom_item_sell_price')}}".
TypeError: 'Record' object is not iterable



I have successfully done this with other Formula Numeric Fields, so I am not sure why it would break for the same calculation somewhere else.

I did open a Support Case but I have got Boston a bit flummoxed.   

Any ideas?


------------------------------
Don Larson
------------------------------

Forum|alt.badge.img+15
  • Author
  • Registered
  • November 11, 2022
Solved with the help of QB Support.

It was a Pipeline architecture issue.    To sum the data from a Search, you cannot be in a loop under the Search.   The summation has to happen outside of that Search step.

------------------------------
Don Larson
------------------------------