Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

calc for an optional last page

Featured Replies

I am developing a quote DB that needs an optional last page that will list terms.

The trick is the solution must have the terms on the same layout as the rest of the quote, that way the user can output a pdf to one file.

I'm having a hard time determining what your question is.

So I'm going to take a stab in the dark...

One way to do this is have a layout for printing/PDF that contains a calc field. The Calc field could be:

If( termsField = "Y", termsTextField , "")

On the layout set Sliding/Printing of the Calc field to slide up.

If the user checked "Y" to include the Terms, then they will show up, if they click "N" or leave it blank, then the Terms will not show up.

--If your terms are always the same, make it termsTextField a global field. If the Terms are compiled of many fields and selections, then make the termsTextField a calc that combines all the contents, inserting the proper spaces and paragraph returns, etc. as appropriate.

You should be able to accomplish this by placing a global Terms field on a Trailing Grand Summary part. Set the Terms field to slide and to reduce size of enclosing part. Just make sure that the field fits snugly within the part (no blank space above or below).

  • Author

sorry what I need is a dedicated last page for the terms only.

so if a two page quote is to be send with term there would be thee pages in total.

You can specify in the Trailing Grand Summary part's options to Page Break before each occurrence. This should do the trick.

I'd put the last page in a Subsummary part. If the sort order is correct, the subsummary will display, if not, it won't. You control this by sorting or not sorting.Set the subsummary to start on a new page.

-bd

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.