Trigerring auto enter calculations

[Asda]

I'm sure this has been covered here earlier, just cant seem to find it.

I would like to know the techniques possible for triggering autoenter fields to evaluate.

Thanks!

[Genx]

Let(

[x = SomeTriggerField;

y = SomeTriggerField;

z = SomeTriggerField];

Your calc here

)

Evaluate( "Your Calc Here" ; [someTriggerFieldHere;SomeTriggerFieldHere;SomeTriggerField])

[Asda]

Tks GenX.

I'm already using Let in my calc, so this way I will end up nesting Let statements. (is that a no no ?)

[Genx]

No, there's nothing wrong with nesting but in this case (and there are few times when nesting a let statement is actually necessary)...

Just add the trigger fields to your list of variable definitions:

Let(

[

valueOne = 5;

valueTwo = 10;

x = SomeTriggerField;

y = SomeTriggerField;

z = SomeTriggerField

];

valueOne + valueTwo

)

[comment]

You can add them all together:

Let ( [

trigger = SomeField & AnotherField & YetAnotherField ;

yourVariable = ....

...

] ;

< calc result >

)

[Genx]

Oh right - didn't occur to me.

Cheers.