6 Replies Latest reply: Aug 14, 2012 6:59 AM by Darshan Bhatt RSS

    To change field_value

    Darshan Bhatt

      I searched the tags in the community discussions but could not get a clue. I would appreaciate any help on the following:

       

      I have two fields X and Y as below:

       

           X               Y

      VISIT 1
      VISIT 3
      VISIT 1Yes
      VISIT 3Yes

       

       

      I want to change the Field X value to 1a and 3a (as applicable) if Field Y value = Yes. I know I can use InputField function but it becomes tedious to manually change the large data set.

       

       

       

      Many thanks in advance

       

      Darshan