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

BV_RecallFormula

If formulas are used in data cells in a form, and #ENTRY is used in order for the user to be able to change the proposed value, then this standard script should be used to make it possible to apply new proposal based on the previous formula in the cells. Cells with formulas in combination with #ENTRY will result in the following behaviour in input cells:

  • If no data values exist, then the formula will be used in input cells.
  • If data values exist, then the values are inserted in the form and the formula will be overwritten.

If the user wants to recall the formulas that existed in input cells, then the ribbon script with the bv_RecallFormula must be created in the template.

When selecting the button connected to this script, the following occurs:

  1. The application will recall the formula that is defined in the template, in the marked input cells.
  2. Thereafter, the new value(s) using the formula will be calculated in the selected cells.

If the formulas should be removed after the new value(s) in the input cells are calculated, then the standard script bv_ApplyProposal must be used instead.
Published:

BV_RecallFormula

If formulas are used in data cells in a form, and #ENTRY is used in order for the user to be able to change the proposed value, then this standard script should be used to make it possible to apply new proposal based on the previous formula in the cells. Cells with formulas in combination with #ENTRY will result in the following behaviour in input cells:

  • If no data values exist, then the formula will be used in input cells.
  • If data values exist, then the values are inserted in the form and the formula will be overwritten.

If the user wants to recall the formulas that existed in input cells, then the ribbon script with the bv_RecallFormula must be created in the template.

When selecting the button connected to this script, the following occurs:

  1. The application will recall the formula that is defined in the template, in the marked input cells.
  2. Thereafter, the new value(s) using the formula will be calculated in the selected cells.

If the formulas should be removed after the new value(s) in the input cells are calculated, then the standard script bv_ApplyProposal must be used instead.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk