I have multiple character fields in my grid, each representing a "race class"
Each competitor is a record of its own and each competitor can only enter one class at a time.
I need to display only one field on my grid which must display the class value the competitor chose. I cannot have 24+ fields displaying on the grid.
I have used a calculated field and it DOES work and displays the correct class in the "combined field" per competitor record.
My issue is that the calculated field code is waaaayyyyyyy to long as it takes many hours to generate the javascript when I save the grid. Below is the calculated code I ended up with which i'm sure, you could either shorten heavily or give me directions on where and how to do it differently.
Short explanation;
CompAMClass1E and similar is yes/no buttons
CompAMClass1 is the "class" field
If a competitor chooses CompAMClass1E "Yes", then the related field CompAMClass1 will be populated with the OR1 class. If no then CompAMClass1 is empty.
if(CompAMClass1E = "Yes",CompAMClass1,if(CompAMClass2E = "Yes",CompAMClass2,if(CompAMClass3E = "Yes",CompAMClass3,if(CompAMClass4E = "Yes",CompAMClass4,if(CompAMClass5E = "Yes",CompAMClass5,if(CompAMClass6E = "Yes",CompAMClass6,if(CompAMClass7E = "Yes",CompAMClass7,if(CompAMClass8E = "Yes",CompAMClass8,
if(CompBMClass1E = "Yes",CompBMClass1,if(CompBMClass2E = "Yes",CompBMClass2,if(CompBMClass3E = "Yes",CompBMClass3,if(CompBMClass4E = "Yes",CompBMClass4,if(CompBMClass5E = "Yes",CompBMClass5,if(CompBMClass6E = "Yes",CompBMClass6,if(CompBMClass7E = "Yes",CompBMClass7,if(CompBMClass8E = "Yes",CompBMClass8,
if(CompCMClass1E = "Yes",CompCMClass1,if(CompCMClass2E = "Yes",CompCMClass2,if(CompCMClass3E = "Yes",CompCMClass3,if(CompCMClass4E = "Yes",CompCMClass4,if(CompCMClass5E = "Yes",CompCMClass5,if(CompCMClass6E = "Yes",CompCMClass6,if(CompCMClass7E = "Yes",CompCMClass7,if(CompCMClass8E = "Yes",CompCMClass8,false))))))))))))))))))))))))
Each competitor is a record of its own and each competitor can only enter one class at a time.
I need to display only one field on my grid which must display the class value the competitor chose. I cannot have 24+ fields displaying on the grid.
I have used a calculated field and it DOES work and displays the correct class in the "combined field" per competitor record.
My issue is that the calculated field code is waaaayyyyyyy to long as it takes many hours to generate the javascript when I save the grid. Below is the calculated code I ended up with which i'm sure, you could either shorten heavily or give me directions on where and how to do it differently.
Short explanation;
CompAMClass1E and similar is yes/no buttons
CompAMClass1 is the "class" field
If a competitor chooses CompAMClass1E "Yes", then the related field CompAMClass1 will be populated with the OR1 class. If no then CompAMClass1 is empty.
if(CompAMClass1E = "Yes",CompAMClass1,if(CompAMClass2E = "Yes",CompAMClass2,if(CompAMClass3E = "Yes",CompAMClass3,if(CompAMClass4E = "Yes",CompAMClass4,if(CompAMClass5E = "Yes",CompAMClass5,if(CompAMClass6E = "Yes",CompAMClass6,if(CompAMClass7E = "Yes",CompAMClass7,if(CompAMClass8E = "Yes",CompAMClass8,
if(CompBMClass1E = "Yes",CompBMClass1,if(CompBMClass2E = "Yes",CompBMClass2,if(CompBMClass3E = "Yes",CompBMClass3,if(CompBMClass4E = "Yes",CompBMClass4,if(CompBMClass5E = "Yes",CompBMClass5,if(CompBMClass6E = "Yes",CompBMClass6,if(CompBMClass7E = "Yes",CompBMClass7,if(CompBMClass8E = "Yes",CompBMClass8,
if(CompCMClass1E = "Yes",CompCMClass1,if(CompCMClass2E = "Yes",CompCMClass2,if(CompCMClass3E = "Yes",CompCMClass3,if(CompCMClass4E = "Yes",CompCMClass4,if(CompCMClass5E = "Yes",CompCMClass5,if(CompCMClass6E = "Yes",CompCMClass6,if(CompCMClass7E = "Yes",CompCMClass7,if(CompCMClass8E = "Yes",CompCMClass8,false))))))))))))))))))))))))
Comment