Pipeline issue: "invalid literal for Decimal" ???

My guess at some possible reasons...

• related_customer is a numeric field being populated by a 'name' text field, the 'name' has a NULL value, or it is populating with a decimal value when it should not.
• related_company is a numeric field being populated by a 'name' text field, the 'name' has a NULL value , or it is populating with a decimal value when it should not.

If the field types match and the issue is with a NULL value, you will need to add a check to determine if it is empty first before trying to populate it.

This is an example of what would go into the "Related Customer" field in the Pipeline:

{% if a.opportunity_contact_full_name is none %}
{% else %}
{{a.opportunity_contact_full_name}}
{% end if %}

or shorthand

{{ a.opportunity_contact_full_name if a.opportunity_contact_full_name is not none }}

If the fields are both numeric and not null, I would add the int filter to the end to remove any decimal.

{{a.opportunity_contact_full_name|int}}

If you haven't checked it out I recommend my course Intro to Jinja for Pipelines. 

-Sharon

------------------------------
Quick Base Junkie
------------------------------