Getting Started with the Interactive Data Entry Forms Extension in the Web Application

To get started with the extension, create a new or open a ready data entry form.

To create a new form in the object navigator Click the Create button in the main menu and select the Data Entry Form option on the New Object panel that opens.

To open a ready form for edit:

Select the Edit item in the form's context menu.
Select the form and press F4.

To open a ready form for view:

Select the Open item in the form's context menu.
Double-click the form.
Select the form and press the ENTER key.

NOTE. When the form is opened, it is required to determine form parameters values, if present.

Basic settings. They are used to rename a data entry form in the edit form.
Main menu. It contains a list of commands that are used to execute various operations with a form. Data entry form can also be saved in the edit mode.
Toolbar. It contains buttons to build a form in the edit mode and to work with data in the view mode.
Cell formatting panel. It contains boxes and buttons for quick cell formatting setup.
Tab panel. It contains buttons to select a group of settings displayed on the side panel in the edit mode.
Side panel. It is used to select table area data sources and to determine basic settings in the edit mode.
Parameters panel. It is used to set up formatting of cells and data entry form areas in the edit mode.
Formula bar. It is used to enter formulas to table cells and to display addresses of selected cells and algorithm formulas if cell values by them are not calculated.
Working area. It is used to create a form in the edit mode and to enter data in the view mode.
Sheet tabs. It is used to work with form sheets in the edit mode and to navigate between them in the view mode.
Controls. It is used to display controls that are required to manage data on working with a ready form.
Zoom. It is used to set up zoom for sheet on the working area.

Setting Up the Interactive Data Entry Forms Extension

To set up the Interactive Data Entry Forms extension, use the Settings dialog box.

NOTE. The Settings dialog box is available only when a data entry form is opened for edit.

In the main menu:

Click the Settings button in the main menu.
Select the General > Settings main menu item.

The General tab contains settings:

Refresh on Opening for Edit. Select the checkbox to automatically refresh data entry form on opening it for edit. The checkbox is deselected by default. When the checkbox is selected, data is taken from sources on opening data entry form for edit, the specified formatting is applied, connected algorithms are calculated. This setting does not affect automatic refresh settings during data entry form viewing.

Combine Queries on Calculation. Select the checkbox to:

Speed up data entry form work on displaying several attributes of one dictionary on the form sheet or on displaying indicators of one source if the indicator from another dictionary is placed between them.
Calculate algorithm for indicators added to the heading several times.
Run partial data recalculation in table areas. Recalculation is executed if modified data is input data for another table area, which data is calculated using the algorithm executed on modification.

NOTE. Work with calculation algorithms is available only if the Calculation Algorithms extension is installed.

Features of combining queries:

If the checkbox is deselected, data is recalculated only in one table area on the current data entry form sheet. Other table areas will not be recalculated.
If the checkbox is selected, and a data entry form contains several table areas based on a single data source, cell data may be recalculated even in the table areas, for which calculation algorithm is not connected. To avoid it, deselect the checkbox or use a cube view as a data source for such table areas.
If the checkbox is selected, and a data entry form contains a table area based on a cube with calculated elements, cube data will be unavailable for calculation. Element calculation can be set up:

In a standard cube on the pages: Cube Facts Binding, Relations, Calculated Facts, Manage Parameters, Controlling Dimensions, and Data Aggregation.
In a cube view on the pages: Fixing Dimensions, Manage Parameters, and Controlling Dimensions.
In a virtual cube on the pages: Manage Parameters and Controlling Dimensions.
In a calculated cube on the pages: Manage Formulas, Manage Parameters, Controlling Dimensions, and Formula Editor.
In an automatic cube on the pages: Controlling Dimensions, Data Aggregation, Manage Parameters, and Fixing Dimensions.

To calculate cube data, use calculation algorithms.

Before combining queries on calculation one can set a custom event using the IPrxReportUserEvents.EventOnBeforeExecuteCombined method in the development environment.
Query combination is unavailable during the work with global cache.

After the checkbox is selected, save and reopen the form to apply the setting. The checkbox is selected by default.

Load Only Active Sheet. Select the checkbox to load data of only active form sheet, data of inactive sheets will be loaded on requesting them. The checkbox is selected by default.