Auto-enter field triggered by other field change

[stefwef]

I have two fields in same table: field1 and field2.

Field1 has auto enter calculation: if(mark_field2="field1", field2, if(mark_field1="field3", field3, ""))

Field 2 has auto enter calculation: if(mark_field1="field2", field1, if(mark_field2="field3", field3, ""))

In browse mode, when I set mark_field1 to "field2" and mark_field2 to "field3", then enter something into field 3, both field1 and field2 autoenter as field3.

When I set mark_field1 to "field3" and mark_field2 to "field1", then enter something into field 3, only field1 autoenters as field3 and field2 remains empty.

Why the different behavior? Someone tells me this may have to do with the creation order of field1 and field2. It seems I should be able to trigger the auto-entry of field2 with an evaluate but I can't seem to get it to work.

I tried:

evaluate(if(mark_field1="field2", field1, if(mark_field2="field3", field3, "")); [field2, field3]) but that returns a question mark, and does not seem to trigger when I change field1 or field3 anyway...

HELP!!!

Edited January 20, 2008 by Guest

[jteich]

Your evaluate function does not work because it does not expect a calculation as first argument but a string containing a calculation.

To achieve this you might use quote() or put the calculation in double quotes with escaping the double quotes inside the calculation as ".

-jens

[stefwef]

Thanks Jens,

It is calculating correctly now with quote() around the expression, but behaving as though I did not have the evaluate... ie the field2 is still not populating with field1 data when I input into field3.

Do you know why it's working for field1 and not field2? Is it really just the creation order? Is there any way to force a trigger?

Thanks!

- Stephanie

[comment]

When I set mark_field1 to "field3" and mark_field2 to "field1", then enter something into field 3, only field1 autoenters as field3 and field2 remains empty.

Looking at your formula for field2:

if(mark_field1="field2", field1, if(mark_field2="field3", field3, ""))

since none of the two conditions are true, the empty result is the correct result.

NOTES:

1. Do not use Evaluate() for its triggering mechanism alone;

2. Do use Case() instead of nested If()'s.

[Lee Smith]

Hi stefwef, and welcome to the Forum.

I would add to what has been said, by pointing out that you should use the real names of your fields, when asking questions, and the beauty of the Forum, is you can attach a copy of your file, or a mark up, so that we can tailor our responses to your needs.

BTW, I found the use of your generic fields confusing to follow what you were needing. Because you mixed the naming up:

"field1"

"field2"

"field3"

"field3"

Field 2

field1

Field1

field2

field3

mark_field1

mark_field2

Lee