how to, using conditional formatting,

[Jaime Perez]

using conditional formatting, how can I make a value color red for example, if it is not equal as another field on the database...

I'd tryed:

1) Folrmula is: DATA::sdomo1 ≠ DATA::sdomo2

2) On conditional Formating of the Field named "sdomo1", Value is not equal to DATA::sdomo2 (then the text color change).

How can I do this?

what i am doing is a comparison of two entrys... If Entry A is not equal to B, to display an error message, or the color change... but I have no idea how to..

Thanks!

Edited November 30, 2010 by Guest

[Matthew F]

Your approach #1, above should work, our you can use: Self ≠ DATA::sdomo1.

If you meant that sdomo1 should be equal to sdomo2, but not necessarily in the same record then you could generate an error message through a value list: Create a value list based on sdomo2. Then use this value list for validation in the field definition of sdomo1, with the 'member of value list' option.

[Jaime Perez]

Thanks, after a while, I successfully did the color change on not equal answers... But I liked your error idea, can you explain me how to?

thanks

[Matthew F]

Are you trying to validate sdomo1 against sdomo2 in the same record or across multiple records? If the latter, then see my prior answer.

[Jaime Perez]

in the same record...

let me explain the usage...

user 1 types value sdomo1

user 2 types value sdomo2

user 2 info has to be the same as user's 1, therefore the color red text is perfect, but if I could add an Error message, it will be best.

This info are on the same record

[Matthew F]

You'd think that you could do that by setting the validation in the field definition of sdomo2 to "sdomo2 = sdomo1". However, for some reason this gives an error no matter what is put in sdomo2. Maybe someone smarter than me knows how to do it.

[comment]

Not sure where is the difficulty.

ReEntry.zip