replacing results with custom text

[rebecca]

I had posted this question a few weeks back.

-----------------------------

"Hi, I'm trying to get a summary of individual items on a value lists base on the person's social security by semester.

 

This is the scenario:

 

Fields created:

 

Social Security

Name

Semester

Classes (which is a value list)

 

Value list "Classes":

199A

199B

199C

199D

 

I'd like to know how is it that I could accomplish the following. For example: Let's suppose that Jane Doe with social 609-65-9551 took just two classes (199B and 199C) on Semester (May 2000).

 

This is how I'd like the report to look like:

 

Semester "May 2001"

 

Name: Jane Doe

Social: 609-65-9551

Classes:

199A

0

199B

1

199C

1

199D

0

 

where "1" represents that the class was taken and "0" represents class not taken.

 

I know this is a hard one,

 

thanks everyone

 

Becca "

 

-----------------------------------

This was the solution posted by "andygaunt"

 

Present in Class 199A = Calculation [number]

 

If( PatternCount(Classes,"199A"), 1,0)

 

Repeat for each class.

 

Then If the class is checked in the value list it will add a one, otherwise a zero.

 

-------------------------------

This is my other question: How do I get custom results from calculated fields?. Lets use the example listed above by andygaunt:

 

If( PatternCount(Classes,"199A"), 1,0)

 

Now, I want the results to be "x" instead of 1 and "-" instead of 0.

 

What should I do?

 

Bye and thanks everyone. I know I bug you a lot, but that's what forums friends are for. Isn't it?

 

Becca

[andygaunt]

Hi Rebecca,

 

If you want it to display x instead of 1 and - instead of 0 just change the calculation to match, making sure that you change the calculation result at the bottom left of the window from number to text.

 

Therefore it will now read.

 

Present in Class 199A = Calculation [text]

 

If( PatternCount(Classes,"199A"), "X","-")

 

Repeat for each class.

 

HTH

 

Your forum friend.

[rebecca]

Thanx once again andygaunt. Your advice has helped me keep my new job.

 

I was able to change the 1's for "x"s and 0's for "-" However, I don't know what happen to the report now.

 

It is only showing the first chosen option and not the following ones. For example

 

Value list "Classes":

199A

199B

199C

199D

 

Suppose I enter Jane Doe with social 609-65-9551 and the first class I chose was "199C" and second one "199B" on Semester (May 2000).

 

it's giving me the report this way now:

Semester "May 2001"

Name: Jane Doe

Social: 609-65-9551

Classes:

199A

-

199B

-

199C

x

199D

-

 

It's only showing the first class I chose. How do I change it back. I tried creating a portal with a relationship of "semester", but didn't work .

 

I can't thank you enough andygaunt

 

Bye

 

Becc

[andygaunt]

Rebecca,

 

Glad you can keep your job!

 

Anyhow, I tested here and didn't have any problems. Have sent you a private message, but in the meantime here is a sample file.

 

www.albion.co.uk/sample/classes.zip

 

It is a slight twist on what I said earlier, because after thinking about it, you (or someone else) may want to change what the option is again.

 

Maybe change the X to a 1 again. So in the sample I have put up two options.

 

1 option is two globals that are set via a startup script. These are then used for the checked, unchecked option.

This means if you do change your mind, you only have to change the startup script and re run it and then every field will update for you.

 

Another is a couple of graphics instead.

 

Let me know if these help.