6 Replies Latest reply on Oct 4, 2016 9:29 AM by Andrew Watson

    New Calculated Field From Leading Character in Existing Field

    Michael Rothschild

      I need to create a "District" field based on the first character of an existing field.

      I know how to do startswith, but I'm having trouble actually creating the new field:

       

      If startswith([login],"a') = true then DIstrict = "Boston" elseif

      startswith([login],"b") = true then District = "New York".......

       

      login is the existing field. District is the new field.