Forum Discussion
Ayupchap
Helper III
Helper IIIHelp with my code - Seems correct but data being pulled is incorrect
Hey all OK so I am writing this rather large piece of code which works in a custom column. It worked for the first part and seemed to be error free with the rest but it now seems I was mistaken ...
Ayupchap,
Please check if the following code returns your expected result. If not, please share sample data of your table and describe your desired result.if([grade_level_at_time_of_test]="KG" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E" or [independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K" or [independent_level]="L" or [independent_level]="M" or [independent_level]="N" or [independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "AGL" else if( [grade_level_at_time_of_test]="KG" and [assessment_name]="17-18 FP Round 1" and [independent_level]="Pre-A") then "OGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and [independent_level]="Pre-A") then "BBGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D")) then "BGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and [independent_level]="E") then "OGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K" or [independent_level]="L" or [independent_level]="M" or [independent_level]="N" or [independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "AGL" else if( [grade_level_at_time_of_test]="2" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="Pre-A" or [independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E")) then "BBGL" else if( [grade_level_at_time_of_test]="2" and [assessment_name]="17-18 FP Round 1" and [independent_level]="K") then "OGL" else if( [grade_level_at_time_of_test]="2" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="L" or [independent_level]="M" or [independent_level]="N" or [independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "AGL" else if( [grade_level_at_time_of_test]="3" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="Pre-A" or [independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E" or [independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K")) then "BBGL" else if( [grade_level_at_time_of_test]="3" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "BBGL" else if( [grade_level_at_time_of_test]="4" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="Pre-A" or [independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E" or [independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K" or [independent_level]="L" or [independent_level]="M" or [independent_level]="N")) then "BBGL" else null
Regards,
Lydia
Ayupchap,
Please check if the following code returns your expected result. If not, please share sample data of your table and describe your desired result.
if([grade_level_at_time_of_test]="KG" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E" or [independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K" or [independent_level]="L" or [independent_level]="M" or [independent_level]="N" or [independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "AGL" else if( [grade_level_at_time_of_test]="KG" and [assessment_name]="17-18 FP Round 1" and [independent_level]="Pre-A") then "OGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and [independent_level]="Pre-A") then "BBGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D")) then "BGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and [independent_level]="E") then "OGL" else if( [grade_level_at_time_of_test]="1" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K" or [independent_level]="L" or [independent_level]="M" or [independent_level]="N" or [independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "AGL" else if( [grade_level_at_time_of_test]="2" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="Pre-A" or [independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E")) then "BBGL" else if( [grade_level_at_time_of_test]="2" and [assessment_name]="17-18 FP Round 1" and [independent_level]="K") then "OGL" else if( [grade_level_at_time_of_test]="2" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="L" or [independent_level]="M" or [independent_level]="N" or [independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "AGL" else if( [grade_level_at_time_of_test]="3" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="Pre-A" or [independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E" or [independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K")) then "BBGL" else if( [grade_level_at_time_of_test]="3" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="O" or [independent_level]="P" or [independent_level]="Q" or [independent_level]="R" or [independent_level]="S" or [independent_level]="T" or [independent_level]="U" or [independent_level]="V" or [independent_level]="W" or [independent_level]="X" or [independent_level]="Y" or [independent_level]="Z" or [independent_level]="Z+")) then "BBGL" else if( [grade_level_at_time_of_test]="4" and [assessment_name]="17-18 FP Round 1" and ([independent_level]="Pre-A" or [independent_level]="A" or [independent_level]="B" or [independent_level]="C" or [independent_level]="D" or [independent_level]="E" or [independent_level]="F" or [independent_level]="G" or [independent_level]="H" or [independent_level]="I" or [independent_level]="J" or [independent_level]="K" or [independent_level]="L" or [independent_level]="M" or [independent_level]="N")) then "BBGL" else null
Regards,
Lydia
AyupchapTHanks so much Lydia, this is amazing and pulling the results perfectly!!! I had a few other assessments I needed to code but using your code method here I have a fully working system working amazing! Thanks so much!!!