1 Reply Latest reply on Feb 12, 2019 9:21 AM by Paul Wachtler

    Calculation to combine fields

    hina.waheed.0

      Hello,

       

      I am trying to combine the highlighted fields in classification column with the surgery name column. Is there a way to combine certain fields with other columns?

        • 1. Re: Calculation to combine fields
          Paul Wachtler

          Hi Hina,

           

          To simply join the two fields you could use:

          [Surgery Name] + " " + [Classification]

           

          If you want to only use it for certain surgeries or classifications you could do something like this:

           

          if [Classification] = "ANTERIOR CERVICAL ARTIFICIAL DISC" or [Classification] = "CHIARI MALFORMATION" or (fill in the rest of the if statements here)

          then [Surgery Name] + " " + [Classification]

           

          end

           

          Best,

          Paul