Is there a function similar to COALESCE?

Answered

4 Comments

  • Official comment
    Andrew Forbes
    Comment actions Permalink

    Hey Jason,

     

    Another suggestion is to use Groups to organize your subfields. You can read more in this recipe.

     

    - Andrew

  • Jason McCann
    Comment actions Permalink

    It's not pretty, but I've managed to handle this with nested IF's

     

    IF ([Ticket Form] = " Form1") THEN [Form1 Component]
    ELSEIF ([Ticket Form] = "Form2") THEN [Form2 Component]
    ELSEIF ([Ticket Form] = "Form3") THEN [Form3 Component]
    ELSEIF ([Ticket Form] = "Form4") THEN [Form4 Component]
    ELSEIF ([Ticket Form] = "Form5") THEN [Form5 Component]
    ENDIF
    ENDIF
    ENDIF
    ENDIF
    ENDIF

    0
  • Jason McCann
    Comment actions Permalink

    This is a much cleaner option.  Thanks!

    0
  • Andrew Forbes
    Comment actions Permalink

    Awesome! Glad we could help.

    0

Please sign in to leave a comment.

Powered by Zendesk