Change color of a field by field content.

[Mark Jones]

I am working on a program where someone non experienced will be inputing data into a program and want to limit mistakes.

I have 2 fields that I need to work with

one is elk it contains either a x or blank and is a text field.

the other is elkscore it is a number field that keeps a score for that field.

In the program the person selects 2 of 3 choices for evaluation. The two choices will have a x in them. The one that isn't selected will be empty and I want to either put a 0 in the tally part of the number field

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

Application Layout Tally Layout

Field name Selection Score

Elk x 30

Wolverine x 29

Cougar ____ 0

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

All I need to do is after all the entries are in and the scoring is staring I need to go through these fields and put a 0 or change the color of the field that isn't selected for evaluation. I have almost 50 fields that can be evaluated and with those about 20 score fields...

I have a program that can be looked at to see what I am talking about at it's 13 meg and it is used to do a Ranger of the Year Evaluation. With 7 differing groups of boys. (Royal Rangers - Church Boyscouts)

http://readyrangers.tzo.com/rotyeval.exe

Thanks for any help or suggestion you might have for me.

sorry about the formating in this message. It reformated my nice neat colums.

Mark Jones

[Mark Jones]

Text field1 has a "x" in it.

Number field1 is blank until a scored number is input into it.

What I am wanting is a one time script that will evaluate up to 50 fields per record and if it finds no x in that text field1 it puts a 0 in the number1 field.

Can someone point me to a calculation that would work in this?

Appreciate the help.

[quillpro]

Do you want it to happen as the x's and scores are entered or is there gioing to be a button or something that say calculate score?

[steve_groves_007]

Use globle container fields that go under the data field and set in the background. Then, with a calculation, load the globle container field with gcontainer fields that have the color you want to display per the calculation.

Hope this helps

Steve

[Mark Jones]

This did the trick wonderfully and on the fly. I just made a global container field called shade sectiondistreghighlight and pasted some yeller in it and then this cal field puts the yeller in the regionevaluation if there is a x in it... works like a champ.

Highlight

Case( RegionEvaluation = "x"; GetRepetition ( shade SectionDistReghighlight ; 1 ))

[LaRetta]

Hi Mark,

If you think you may wish to also highlight other fields, there is an alternative to creating a separate calculation for each. A more resource- and time-efficient method might be The Field Factory vs. 7 only

It shows a way of controlling several field background highlights by only one calculation and the fields (and/or labels) will change on the fly, depending upon your needs. You need vs. 7 to take advantage of it. It also allows you to 'mass produce' these highlight fields and labels.

LaRetta