February 26, 200322 yr 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?
February 26, 200322 yr 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")
February 26, 200322 yr Author 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?
February 26, 200322 yr Author 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?
February 27, 200322 yr 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
Create an account or sign in to comment