Input Form Ribbon

The input form ribbon above the spreadsheet contains six different ribbon tabs: Home, Edit, View, Share, Trace, and Help.

Note: Depending on settings in the form, you might not see all the buttons described below.

The ribbon in the Home tab contains the following options:

Ribbon Button	Description
Save Values	Saves the values you entered in the form to the database. Note: Always remember to save your values before closing the form or logging out. This button will be visible in all ribbon tabs.
Lock Input	Locks the form for input by other users. This button will only be visible if the form has been configured to enable lock.
Refresh	Refreshes the form. Caution: All unsaved values will be lost.
Close	Closes the form. Caution: All unsaved values will be lost.
Selection Pane	Opens the selection pane when the form is connected to a selection pane. If not, this button will not be visible.
General Comment	Adds a general comment in the form.

In addition to the standard buttons listed above, the Home tab in the form can also have additional buttons in the ribbon that are form specific. For example, the New Row button is not a default button, but added by the template designer in order for you, as a user, to be able to add new rows in your form.

The ribbon in the Edit tab contains the following options:

Ribbon Button	Description
Save Values	Saves the values you entered in the form to the database. Note: Always remember to save your values before closing the form or logging out. This button will be visible in all ribbon tabs.
Lock Input	Locks the form for input by other users. This button will only be visible if the form has been configured to enable lock.
Undo	Allows you to cancel or reverse the last ten commands executed.
Redo	Allows you to redo commands you have undone.

The ribbon in the View tab contains the following options:

Ribbon Button	Description
Save Values	Saves the values you entered in the form to the database. Note: Always remember to save your values before closing the form or logging out. This button will be visible in all ribbon tabs.
Headings	Displays the row and column headings.
Formula Bar	Opens a formula bar to edit cells or view formulas in cells.
Gridlines	Shows the gridlines in the form.
Outline	Hides outline symbols (+/- if the report is designed with outline groups). By default, outline symbols are visible when opening the report.
Design area	Displays the section of the sheet dedicated to the column and row control variables.

The ribbon in the Share tab contains the following options:

Ribbon Button	Description
Save Values	Saves the values you entered in the form to the database. Note: Always remember to save your values before closing the form or logging out. This button will be visible in all ribbon tabs.
Lock Input	Locks the form for input by other users. This button will only be visible if the form has been configured to enable lock.
Print	Prints your form. Upon selecting this button, a new window opens where you can choose what you want to print.
Share	Select this button to copy the link to this form. Then, choose if you want to include Navigation and/or Header, and if you want URL or a link to embed the form.
Export to PDF	Exports the form to a .pdf file.
Export workbook	Exports the form to Excel, in three available options: Export to Excel: Exports the input form to Excel. If you use this menu item, the form cannot be imported back into Bizview. Export to Excel - clear formulas: Exports the input form to Excel. Before exporting, Bizview will convert all formulas to actual values. If you use this menu item, the form cannot be imported back into Bizview. Export for import: If you want to work offline in the form and be able to import your work into Bizview again, export the form using this menu item. Upon selecting Export for import, the book will be prepared for an import later on, and only input cells will be available to edit in Excel. The form cannot be altered in any way if an import should be done, therefore, the book is locked and only open for input in actual input cells. Note: Starting from version 25.3, the export function supports .xlsx format.
Import	Select the Excel book that you want to import. Note: Bizview will check the selected book and if it matches the open form in Bizview, it will continue processing the import. However, if any selection value does not match, or if the book does not match, the import will be aborted. Note: Starting from version 25.3, the export function supports .xlsx format.

The ribbon in the Trace tab contains the following options:

Ribbon Button

Description

Save Values

Saves the values you entered in the form to the database.

Note: Always remember to save your values before closing the form or logging out. This button will be visible in all ribbon tabs.

Lock Input

Locks the form for input by other users. This button will only be visible if the form has been configured to enable lock.

SQL Trace

Displays collection of events and data returned by the Bizview database engine.

The ribbon in the Help tab contains the following option: