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

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.

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?

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

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 ))

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