if changed?

[VICH]

is there any kinda of fucntion i can put in a calc feild that works by detecting if a feild's data changes like

if( Changes(field); result 1; Result 2)

[Raybaudi]

Hi VICH

you can start from this calculation field that checks if field is been modified (lets name it check):

Case(

check = "Modified";"Modified";

IsEmpty ( field );"";

not IsEmpty ( field ) and IsEmpty ( check );field;

check = field;field;

check ≠ field;"Modified"

)

BTW this calc is permanent; if someone (you too) modifies field, check will be set to "Modified".

To can set check to empty you can add, for example, as the first case condition, this:

field = "^^^";"";

so you (and all others who know) can type ^^^ in the field and check will become empty.

[VICH]

thanks i'll try to figure it out using that