BV_ApplyProposal

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 the bv_ApplyProposal standard script should be used to make it possible to apply new proposals 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 apply a new proposal using the previous formula that existed in input cells, then a custom button linked to the standard script bv_applyproposal 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.
3. Finally the formula will be removed from the cell(s) again, and the new values will be shown.

If the formulas should be recalled and preserved in the selected cells, then the standard script bv_RecallFormula must be used instead.