Hi All,
I have a form with 10 supervisors fields in there. They Fields are like Supervisor1, Supervisor2 all the way to Supervisor10. Now in the view there is only one column which is for Supervisors. I want the column formula be such to check Supervisor10 first, if it is not empty just have its value else check for Supervisor9. Similarly if Supervisor9 is not empty the column should display the value of Supervisor9 otherwise look for Supervisor8 and so on.
Can anybody help with the formula.
TIA,
Ki
Subject: View Column Formula Question
@If(Supervisor10 != “”; Supervisor10; Supervisor9 != “”; Supervisor9; Supervisor8 := “”; Supervisor8; Supervisor7 != “”; Supervisor7; Superviosr6 !- “”; Supervisor6; Supervisor5 != “”; Supervisor5; Supervisor4 != “”; Supervisor4; Supervisor3 != “”; Supervisor3; Supervisor2 != “” Supervisor2; Supervisor1)
It will stop processing as soon as the if statement is true.
Subject: RE: View Column Formula Question
You can simplify the heck out of that:
@Subset(@Trim(Supervisor10 : Supervisor9 : Supervisor8 : Supervisor7 : Supervisor6 : Supervisor5 : Supervisor4 : Supervisor3 : Supervisor2 : Supervisor1); 1)
Put 'em together lowest to highest, get rid of the empties, and the first one left in the list is the lowest-level supervisor available on the document.