Salesforce and other SMB Solutions are coming soon. ×

# replacing results with custom text

## Recommended Posts

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

##### Share on other sites

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.

Present in Class 199A = Calculation [text]

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

Repeat for each class.

HTH

##### Share on other sites

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

##### Share on other sites

Rebecca,

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.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Images

• By Soliant Consulting,
• By Soliant Consulting,
• By Soliant Consulting,
• ### Forum Statistics

• Total Topics
33.7k
• Total Posts
141.5k
×
×
• Create New...