3 Replies Latest reply on Dec 6, 2017 7:17 PM by Norrapat Thongnop

    How can i add singlge quote in calculate field?

    Norrapat Thongnop

      There is example of my code:

       

      IF

      [Correspondence Name] == 'House Registration Certificate's Address' THEN [Address Preview1]

      ELSEIF

      [Correspondence Name] == 'Living Address' THEN [Address Preview2]

      ELSEIF

      [Correspondence Name] == 'Place of Work' THEN [Address Preview3]

      ELSEIF

      [Correspondence Name] == 'Commercial Registration Address' THEN [Address Preview5]

      ELSEIF

      [Correspondence Name] == 'Business Address' THEN [Address Preview6]

      ELSE 'House Registration'

      END

       

      I can't use 'House Registration Certificate's Address' because it has  's  ,so what should I do now.