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
------------------------------
