0 Replies Latest reply on Dec 3, 2009 4:40 AM by DrDave

    Know what you are returning

    DrDave

      Title

      Know what you are returning

      Post

      I just solved a problem, which took too long to identify...so I though I would pass along the experience.

       

      I created a calculation field called NamesBoth, which was simply NameLast & ", " NameFirst

       

      I had a script that wrote a layout to both a PDF and XLS.

       

      The problem was that in the spreadsheet, the calculated field was populated with a "0" but the PDF was fine.

       

      After some time I figured out that when I created the calculated field, I was "returning a number" and not "text."

       

      If your fields are behaving "strangely" or "not as expected" ensure that the field is returning what you expect/want/need.