Clear hidden fields on keyword change

I have a field in a form that controls the display of two other fields. In this case, the field is for alternate locations. If it is yes, a City and State field appear. If it is null, or no, the City and State fields do not appear.

But what if you select "Yes" for the other location field, enter data into the City and State fields, and then change the other location field back to no? Well, having set the field property to refresh fields on keyword change, the City and State fields become hidden, but the data remains stored. If those hidden fields controlled the display of other fields, or some back-end workflow, this would be a big problem. By plugging an appropriate input translation formula into the two ensuing fields, they are cleared each time the other location field is changed from "yes" to "no."

In the City field input translation formula, for example, check the otherLocations field for data. If it is does not evaluate to "yes," clear the City field. If otherLocations evaluates to yes, leave it alone. The refresh is handled by the property setting of the other locations field.

@If(otherLocations =
 "No" | otherLocations = "";"";City)

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip exchange by member Andrew Young. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT QuickTips View hidden fields on Lotus Notes/Domino forms A bevy of Notes/Domino development tips How to protect your Lotus Notes application design Merging views Stop an agent without shutting down the Amgr task Collapsing outlines How to make Notes view icons run code Find all databases associated with a template Verifying user's date setting and time zone on local PC Load design for a single database Lotus Notes Domino Coding and Development Tutorial: 30 LotusScript tips A bevy of Notes/Domino development tips A Formula language for Lotus Notes introduction -- 7 tips in 7 minutes Top 10 Notes/Domino developer tips of 2006 Sending and logging faxes from Lotus Notes and Domino Accessing documents in a Lotus Notes database A smorgasbord of Notes/Domino development tips Creating a Lotus Notes view column categorized by month A project-tracking application for Lotus Notes Domino What the new Office means for developers RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.