Statement Form View on the Main SecureSheet Tab

This is referred to as a pass-thru view that maps the Unique ID in Column A to the statement tab. The logic on the statement tab then matches the values in the unique row as statements are exported individually or in a batch.


  1. From the main SecureSheet tab, select Views.
  2. Click Add Views.
  3. Select Standard-Form Layout from the View Type: dropdown.
  4. Turn on the Export Link: checkbox.
  5. Enter P#HideLS in the Export Options: checkbox.
  6. Turn on the Pass-Thru: checkbox.
  7. Select the Template Sheet Name Ref: that matches the tab name in SecureSheet with the statement layout/content.
  8. Enter the Template Row ID as the first row after the header row.
  9. Enter A=N2 in the Template Mapping: field.
  10. Set the header row on your main compensation tab to the Freeze at Row field.
  11. If there are any header rows on your main compensation tab, hide them on this view by entering them in the Hidden Header Rows: field, delimited by a semi-colon.
  12. Set Column A to Locked.
  13. Set every other column to Hidden.
  14. Click Save.


Note:        A view can only support one statement tab.  If you have multiple statements, you will have a 1:1 relationship between a statement tab and a statement form view on the main SecureSheet tab.



If you have not done so already, continue to setup the statement on main SecureSheet tab: