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