Hi,
I was hoping someone could help me with this little problem. (I am working with Lotus 6 designer).
I have a form that contains several subforms(with hide when formulas). If Request type = online, then the online subform will appear if request type = batch, then the batch subform will appear and so fourth. On my batch subform I have a field “UAT” that contains a default value.
I then have a view “view by request type”. I have a column “UAT” which contains the default value found in the batch subform. Here is my issue. Regardless of the request type, the default value for the “UAT” field on the batch subform appear in the "UAT " column for online request also.
You should not see the value for “UAT” under Online type. THe “UAT” field does not exist in the online subform just in the batch subform. I just want to see the value of that column in the request type = batch.
I’ve tried hide when formulas in the “UAT” Column @If( TYPE = “BATCH” ;0; 1) but that is not working…
I would greatly appreciate any suggestions.
Thanks,
Lina
Subject: Default values appearing in View
You talk about subforms with hide when formulas. I’m going to assume you mean exactly what you’re saying and so you are not talking about subform formulas on the containing form, which would conditionally include or remove the subforms, but hide formulas programmed into the subforms themselves.
Hide formulas only control whether a user sees the field when they are looking at the document on screen. Whether it’s visible or not, the field is still on the form, and its formulas are still executed, and if the field is of a type to be stored (i.e. not Computed for Display), the field value is stored.
You can make the field blank when it’s not wanted by using an input translation formula that clears out the value if it shouldn’t be there. Of course, this will not affect existing documents, which must either be re-edited to apply the formula or fixed with an agent.
Column hide formulas operate on the whole column – not on individual row entries. So, you can’t refer to field names in these formulas – you would usually be checking the user roles, profile document fields, environment variables and so on to decide whether this user should see the column. The column itself can contain an @If, however.