2 Replies Latest reply on Jan 30, 2017 1:34 AM by Santhosh Kunder

    Referencing the entire column in a calculated field

    Santhosh Kunder

      Hi All,

       

      I am very new to this form and in need of something which is not a straightforward  requirement.. I have placed a sample table below. All i need is a calculated field which returns the value TRUE when the logged user lies in the column SupID...We used USERNAME() function to achieve this but with no luck as i was not able to reference the entire column..

       

      Example: When the Logged in User is BD21 then the result column should be updated with TRUE by referencing the entire column(I would Redmond to avoid any helper columns to achieve this)

       

      EmpID

      SupID

      Result

      AB12EE11TRUE
      BC56BD21TRUE
      DF98DD11TRUE

       

      Your help on this is much appreciated

      Thanks