Is there a way to automatically empty fields when they are hidden by the hide-when formulas? I could program them all individually, or use QuerySave or something, but I was juts wondering if there’s a way to do it automatically.
My problem is that I want to have text fields which appear based on Radio buttons, and then when the radio button is changed to a value which hides the text field, clear the contents of the text field. It seemed like the sort of thing there would be a checkbox for or something, but I can’t find anything.
Subject: Removing field contents when hidden
It’s not something you’d normally want to have happen – fields are usually hidden not so much for user convenience, but to keep the users from playing with the values. So no, there is no simple setting.
Subject: RE: Removing field contents when hidden
I thought that might be the case. My alternative was to empty all hidden fields by way of a script, but is there a way to fin dout from the uidocument which fields are hidden? Or to somehow extract the hide-when formulas in LotusScript?
Subject: RE: Removing field contents when hidden
Not an easy one, no (at least not without using a third-party tool). Personally, I’d use formulas rather than LS. You still don’t get an “@IsHidden”, but at least you can replicate the conditions exactly without a lot of extra code.