MULTISELECTADD

Adds elements to a multiselect XML (MLS-XML) definition.

MULTISELECTADD is typically used as a parameter of a Set Parameters action.

SeeAction types.

Syntax

The function requires a valid MLS-XML definition, and pairs of arguments that specify the type and unique name of each element to add to the definition.

Note: Currently, only the 'Member' element type is supported.

This is the syntax of the function:

=MULTISELECTADD("MLS-XML","Element Type","Element_unique_name"...,"Element Type","Element_unique_name")

The Element_unique_name argument can be a cell reference or a reference to a variable which contains a unique name.
Note: MULTISELECTADD does not validate element unique names. You must ensure that valid unique names are specified.

Example

This example is based on the Best Practices sample database.

The unique name of the Special Offers element is held in a report variable called rv_product.

The unique name of the Winter Tires element is held in cell C4.

This MULTISELECTADD function adds the Winter Tires and Special Offers elements to an MLS-XML variable called rv_multi:

=MULTISELECTADD(reportvariables.rv_multi.text,"Member",ReportVariables.rv_product.text,"Member",C4)

Note: If you specify a MULTISELECTADD function in a cell, the cell displays </MultiSelect>. Expand the height of the cell to display the full MLS-XML definition.
Related topics