BV_AddNewRow

In a FORM, a standard script can be used to create an "Add new row" button in the ribbon.

Note: This script is only applicable to forms with expanded rows (EXPAND in column A). If end-users should be able to add new records in the form, then this script should be used to create a button in the ribbon.

The standard script must be linked to a custom button in the template using the function and the function bv_AddNewRow. For more information about how to set up buttons and functions in the Scripts worksheet, see Ribbon scripts.

When using this standard script in a custom button, a template scrip does not need to be connected to the template. The template only needs to be connected to a script when using customized template scripts or events.

When using the Add New Row script in a generated report/form, the Add New Row script matches the rows in the generated form (each column with * as SOURCE) to the corresponding rows in the GETTABLE worksheets and returns any value that does not exist in the form. This means that every * column (each object) in the template needs to have a GETTABLE worksheet containing values and possible descriptions.

In addition to defining the bv_AddNewRow function as a custom button, the parameter ADDROW_FILTER can be defined in the PARAM worksheet to specify different intervals of values that should be available (depending on the section the active cell is in when pressing the New Row button).