Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

#ENTRY

In FORM templates, the program will evaluate which cells should be locked, or open, for entry when the document is generated.

Program rules for open cells in a FORM:

  • All cells with DATA in column A and CVAL in row 1.
  • All cells with DATA in column A and a data attribute in row 1.
  • All cells with DATA in column A and SPVAL, SPKEY, and/or SPLIM in row 1.

All other cells will be locked for editing when the FORM document is generated (in a REPORT document all cells will be locked at all times).

Note: If a cell meets one of the above rules but contains a formula, then that cell will also be locked. To override, enter #ENTRY in that cell. This enables the end-user to make changes to a cell that contains a formula.

Caution: If #ENTRY is used in many individual cells it will affect the performance of the book.

To override the rule that all other cells are locked, you can insert a cell comment or apply a cell command in the particular cell that should be open for entry. When the form is generated, this comment or command will make the cell open for entry, even though it does not meet the above rules. The cell comment will not be visible in the generated document.

Note: You can also configure ENTRY columns and rows in the right panel of Template Design. For more information, see Data Bindings (New Design).

Adding/Removing an #ENTRY Cell Comment

The cell L33 does not meet the above rules and will therefore automatically be locked when generating the form. To override the rule using a comment, right-click the cell and select Insert Comment...:

An Insert Comment dialog displays, as shown below. Enter the text #ENTRY and select Ok.

When the template is saved and opened in Template Design again, the cells containing a comment will be visible with an red triangle in the top-right corner. Hover over the cell with a red triangle and the following dialog displays:

When previewing the document, the expanded rows in column L is open for entry even though they do not meet the rules above. No comment is visible for the end-user.

To edit or remove the comment in Template Design, right-click the #ENTRY cell and select the appropriate option from the drop-down:

Adding/Removing an #ENTRY Cell Command

To override the rule using a cell command, right-click the cells and select Cell Commands > #ENTRY, as shown below:

When the template is saved and opened in Template Design again, the cells containing a command will be visible with an orange triangle in the bottom-right corner.

To remove the cell command, right-click in the #ENTRY cell in Template Design and select Cell Commands > #ENTRY:

For information about how to apply a rule or condition that must be satisfied for cell entry in a form, see #CONDITIONALENTRY.
Published:

#ENTRY

In FORM templates, the program will evaluate which cells should be locked, or open, for entry when the document is generated.

Program rules for open cells in a FORM:

  • All cells with DATA in column A and CVAL in row 1.
  • All cells with DATA in column A and a data attribute in row 1.
  • All cells with DATA in column A and SPVAL, SPKEY, and/or SPLIM in row 1.

All other cells will be locked for editing when the FORM document is generated (in a REPORT document all cells will be locked at all times).

Note: If a cell meets one of the above rules but contains a formula, then that cell will also be locked. To override, enter #ENTRY in that cell. This enables the end-user to make changes to a cell that contains a formula.

Caution: If #ENTRY is used in many individual cells it will affect the performance of the book.

To override the rule that all other cells are locked, you can insert a cell comment or apply a cell command in the particular cell that should be open for entry. When the form is generated, this comment or command will make the cell open for entry, even though it does not meet the above rules. The cell comment will not be visible in the generated document.

Note: You can also configure ENTRY columns and rows in the right panel of Template Design. For more information, see Data Bindings (New Design).

Adding/Removing an #ENTRY Cell Comment

The cell L33 does not meet the above rules and will therefore automatically be locked when generating the form. To override the rule using a comment, right-click the cell and select Insert Comment...:

An Insert Comment dialog displays, as shown below. Enter the text #ENTRY and select Ok.

When the template is saved and opened in Template Design again, the cells containing a comment will be visible with an red triangle in the top-right corner. Hover over the cell with a red triangle and the following dialog displays:

When previewing the document, the expanded rows in column L is open for entry even though they do not meet the rules above. No comment is visible for the end-user.

To edit or remove the comment in Template Design, right-click the #ENTRY cell and select the appropriate option from the drop-down:

Adding/Removing an #ENTRY Cell Command

To override the rule using a cell command, right-click the cells and select Cell Commands > #ENTRY, as shown below:

When the template is saved and opened in Template Design again, the cells containing a command will be visible with an orange triangle in the bottom-right corner.

To remove the cell command, right-click in the #ENTRY cell in Template Design and select Cell Commands > #ENTRY:

For information about how to apply a rule or condition that must be satisfied for cell entry in a form, see #CONDITIONALENTRY.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk