Auto Enter another field value.

[mehronx]

How would I calculate a field so that it enters another field value if it is empty?

I know this is simple, but I have never done this. Is it under auto enter or validation?

[macguys]

So what you want is a second field that has it's value set depending on whether or not the first field is empty? That's not too difficult. Just have the 2nd field be a calculation with an if statement in it. A double set of quotes equals empty.

field2=if(field1="", "it's empty", "it's full")

[mehronx]

Actually, I want the second field to display what is in the first field if nothing has been entered into the second.

How about this: If a certain checkbox is clicked, then the second field displays what is in the first field?

[mehronx]

Or to make it more complicated:

there are three fields with a checkbox over them.

If the checkbox is checked over one, it sets a fourth field to that value and removes any other checks.

And if none are checked, then the fourth field uses the first value.

Does that make any sense?

[Ugo DI LUCA]

And if none are checked, then the fourth field uses the first value.

Does that make any sense?

If none are checked, there is no value in the first field.

If you want to get the first value of a value list if none is checked, here is one solution.

Create a concanated field for value 1,2 and 3 c_concanate = Field1 & " " &Field2 & " " &Field3

With value list checkbox Yes No

c_field4 = Case(IsEmpty(c_concanate), Left(ValueListItem(Status(CurrentFile), "yourvaluelistname"), 3*), Case( not IsEmpty(Field 1),Field 1, Case( not IsEmpty(Field 2), Field 2, Case( not IsEmpty(Field 3), Field 3))))

*3 for Yes