hello

i have two fields and i want to make one of it empty based on the other field. lets say if A is selected / filled [date type] then i want to make B blank and if B is filled, i want to make A blank.

for now i have this piece of code which only makes one field blank

Field A = Let(Trigger = Field B ; "")

if i put the same code in field B and change trigger = B to Trigger = A, it makes both fields blank and then you can't fill any of the fields as they both cancel each other out.

is there any way to make one field blank at a time. if A is filled, B is blank, if B is filled, A is blank.

thanx in advance.

NOTE i have come up with conditional-formating solution to make the text invisible based on a certain criteria and now everything is working as expected.

Edited June 2, 200817 yr by Guest

FYI it is possible to make this work, e.g. auto-enter this in Field A:

Case( 

Get ( ActiveFieldName ) = "field A" ; field A ; 

not IsEmpty( field B ) ; ""  )