IF Command with Category

Comments

3 comments

  • Rainer Grabowski (FVM)

    Hi Mike,

    cause your first try had a number as result Podio saved this calculation field as number type (click on the field settings and you see it's number type). You can't change this type later. So you have to create a new calculation field. A tip: If you want to be sure that a calculation field is saved as text type put in only a text token like @title and save it. Then go back, delete the variable and create your javascript. Same if you want to be sure that it is saved as number type. Put in a token for a number field or if you don't have a number field in your app write: //@title; 1 and save it.

    Rainer

    2
    Comment actions Permalink
  • Mike Adams

    Many Thanks Rainer, that explains it, I thought I was going mad ...
    Thanks for your excellent support

    0
    Comment actions Permalink
  • Adrien BLAISE

    Calculation fields output can be either number, date or string (text). The field type is determined when you FIRST save the field. You need to make sure your field is saved as text (not number). We usually enter whatever variable, then "TEMP", just to save as text. Then we enter the formula.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk