Follow up on Powerschool DECODE statements

I would like to thank Roger Sprik at the PowerSchool User Group (http://tech.groups.yahoo.com/group/PSUG/)for helping me solve my problem. He did it by thinking smarter not harder.

I was on the right track with the decode statement. Here was Roger's solution:

You can use decode a little more creatively, taking advantage that you can have an "else" statement... since you only seem to need to do school 100 differently, just make the others the "else". Also take into account that you can apply decode only to the part where there is a difference, which will take the semicolons outside of the decode...

<meta equiv="Refresh"
content="1;URL=/guardian/~(decode;~(schoolid);100;schedule;home2).html">

Thanks Again

PowerTeacher Terms not showing the same grade

I had a teacher come to me with a problem. In PowerTeacher it was showing the correct grade in the S1 column, but the end of year grade (Y1) was showing as slightly lower. After doing some searching I found that the teacher had not set up the year for term weights but left it at total points. Once switched to term weights the semester grade and year grade were the same.

Powerschool and Decode Statements

Her is my latest puzzle. I have been try to nest IF statements to no avail (I don't think it can be done). In the process I discovered the DECODE statement. An example of the decode statement would be:

~(decode;~(schoolid);100;ES;200;MS;300HS)

It roughly translates to a DECODE statement in Oracle or a CASE statement in C. The equivilant IF statements would be:

IF schoolid==100
print "ES"
ELSEIF schoolid==200
print "MS"
ELSEIF schoolid==300
print "HS"

Here is my dilemma. We are preparing to open the parent portion of Powerschool at the end of the month. Currently when a parent logs on the parent portal the first time it takes them to a page where they must agree to the terms of service before they are allowed onto the parent portal. After they do this it redirects them to the Grades and Attendance page with the following HTML redirect:

<meta equiv="Refresh" content="1;URL=/guardian/home2.html">

The elementary school uses standards based report cards and in turn does not use the PowerTeacher Gradebook. There is no information there in the grade portion and I don't want parents of elementary children to even see this page. I decided to use a DECODE statement to redirect the initial page based on which school their child was in. The statement I tried was:

~(decode;~(schoolid);100;<meta equiv="Refresh" content="1;URL=/guardian/schedule.html">;200;<meta equiv="Refresh" content="1;URL=/guardian/home2.html">;300;<meta equiv="Refresh" content="1;URL=/guardian/home2.html">)

The problem was it didn't work. Powerschool keeps interpreting the semicolons in the HTML tags as the end of the block. Haven't been able to figure out how to escape the semicolons; I am going to post the problem on the PSUG. If I get an answer I will post it here.