Is there a way to hide a Field on a Form when the Form is printed AND a formula criteria is met?
The fields I have should be visable in the Client at all times but they should not print if there is no data contained in them.
What I am trying to accomplish is to hide an entire row of table cells in a printout if there is no data in them.
Subject: Hide when printed AND formula met?
The hide-when tab, select PRINTED will not work? I thought this was what it was designed to do?
Subject: Hide when printed AND formula met?
This hide when formula does the job as a work around.
My scenario is an invoice where I want the items with no cost to not appear.
I created a radio field with edit and print as the choices, then put this formula into the rows I want to hide.
@If(Inv_Toggle=“Print”;@If(Inv_Amt1=“”);“”)
It works and is a little easier for me than having 2 forms. I hope this helps.
Subject: Hide when printed AND formula met?
Unfortunately not. I think the most common fudge is to create a second form which is basically a copy of the first, but with slightly different hide-whens to just hide the fields completely when empty. You can then create a print action which switches the form, prints it out, and then switches back to the original form. It’s pretty seamless, although does rely on the user using the print action and not hitting Ctrl-P or something.
hth
Dan