Hi Jörg, do you have an example of such formula? I don't get it (sorry, new to Ninox). I can create a new formula field, but don't know how to tell the field to show/hide. I'm using the desktop version on Ninox on Mac OS X.

I'm expecting the same behaviour as in the form editor: you can enter the field options and add a formula in the Show only option, but can't see the same options in the print form view.

You can create a formula field in the print editor and use a formula like this:

if [condition to show field] then [the same formula used in the form] end

This will show a blank field if the conditions are false.

For example if Price*Number then Price*Number end

This will only show the result if the Total is not zero.

Steven

Thanks for the reply, RoSoft_Steven Rooryck, but this will print an empty field. What I want is to use something like the form editor in Access or FileMaker Pro, where the fields that are not visible do not ocuppy any space in the page. For example, if I create an image field and the field is empty, there is still a white space in the page...

Maybe there is another way if I could use HTML to print the forms instead of generating a PDF?

Another approach could be. If there are few fields that need to be made invisible, you may want to opt for different print layouts. Via a button ninox will then choose the right layout to print depending on conditions of the empty fields.

Steven

thanks for the tip, RoSoft_Steven. It's not the ideal solution (because you will need to maintaing a bunch of different variants of the form) but at least it will behave as if the form editor allowed hiding empty fields.

I totally agree with you, Sebastian. Ninox is an absulte great software but with a second league printing options (of course, there are worse SaaS apps, but coming from complete desktop solutions like Filemaker or Access with such a great print output capabilities...)