
Print only visible fields automatically
I've created a form in which some fields are only visible if they meet certain criteria. If I print the records with the automatic layout, it automatically prints all the fields even though they are not visible in the form. This makes the printing process annoying since I/ my clients would need to always delete all the unnecessary fields.
Would appreciate any help in this regard :)
-
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?