Why are custom field values different when exporting?

We have custom fields that are set up using Case Statements to determine the values. When viewing the values on the Item Record and in Saved Search results, the values are correct. However, when I export the Saved Search as a CSV or source and display the field values on our website, the values are incorrect. The incorrect value is the ‘Else’ value from the Case Statement.

Does anyone know why this is happening, and if is there anything that can be done to correct it?

Rookie Asked on October 18, 2021 in Other.
Add Comment
1 Answer(s)

Are you using a Formula Numeric? Is the formula written in the field itself?  If that is the case the formula is probably stating “Else 1 END”. If that is the scenario, the else is setting the value to 1 and the formula is looking for a value equal to that value.  You may need to set the field value with a workflow instead.

Intermediate Answered on November 4, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor