Re: Urgent - Clear Field values (123 Views)
Regular Advisor
Posts: 190
Registered: ‎07-20-2011
Message 1 of 2 (149 Views)

Urgent - Clear Field values



For a reason i have made a field value to capture a value "access" i.e. if affected.item="XYZ" then subcategoryMIT="access", so now i want to clear the value of subcategoryMIT when the selection is not equal to "XYZ", yes this can be done by using the condition affected.item~="XYZ" then subcategoryMIT=NULL, but everytime when I select different category say ABC and try to update the field subcategoryMIT with some value its getting cleared due to the condition written. which i dont want to happen, how to avoid this? please assist




Honored Contributor
Posts: 989
Registered: ‎02-22-2011
Message 2 of 2 (123 Views)

Re: Urgent - Clear Field values


if affected.item~="XYZ" then subcategoryMIT=NULL



if affected.item~="XYZ" and subcategoryMIT="access" then subcategoryMIT=NULL


If this doesn't meet your needs, please provide more information on how this is configured (Format Control, Link record, etc) and the various requirements.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.