Forum Discussion

SallySally's avatar
SallySally
Qrew Member
11 years ago

How do I print a record with only certain fields showing?

Please can someone explain how I can print a record with only some of the fields appearing? I have created a different form to populate the fields I require but not sure where to go from here.

6 Replies

  • Make a formula URL button to redisplay the record on the Alternate Form and then print from there.

    Here s an example.


    URLRoot() & "db/" & Dbid() & "?a=dr&dfid=11&rid=" & [Record ID#]

    Change the 11 to whatever the form id# is for your form. If you preview your form it will tell you the form ID in the URL.
  • Settings
    Forms
      and then duplicate the form so now you have two forms.  Note that each form has a form ID#.

    Carefully edit the form to remove the field you want removed.  I say carefully, just to be sure you don't mess up your main form.  Be sure which form you are editing.

    You can also make a button to directly print on an alternate form.


    URLRoot() & "db/" & Dbid() & "?a=printr&dfid=11&rid=" & [Record ID#]


    Change the dfid=11 to the correct form ID#
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      The field properties of a formula URL field allow you to check a box that say open in New Window.