1 Reply Latest reply: Aug 23, 2013 8:46 AM by Mihail Stoitsev RSS

    Store/ Capture particular selection in sheet objects

      Hi,

       

      I m having a list box and few sheet objects. Whenever i select a particular data from list box, i should be able to preserve it and use it in different expressions in the sheet object.

       

      Is this possible.

       

      Pls help me.

       

      Regards,

      Malathi

        • Re: Store/ Capture particular selection in sheet objects

          Hi,

          Yes, it is possible.

           

          1. In your QV Client you just go to Settings -> Document Properties -> Triggers -> Field Event Triggers, select the field for which you need to Capture the selected value and 'Add Action' under the 'OnSelect' condition.

           

          2. Click the 'Add' button in the new Actions window. Choose 'External' Action Type and 'Set Variable' Action.

          Set_Variable.png

               Click OK to configure Variable details. Of course you need to have the variable already created/existing via the Document Settings -> Variables -> Add or Settings -> Variable Overview -> Add.

           

          3. If you are not focused on the newly added 'Set Variable' Action you need to select it (click on it again). Because users may select more than one value in the target field you should actually 'concat' the selected values to make sure they are all captured correctly. Here is an example:

          Selection_Capture.png

               Click OK twice to get back to the dashboard.

           

          4. Make selection(s) in the target field and open Settings -> Variables Overview. Your variable should contain a comma separated list of selected values.

           

          Alternative approach is to use the GetCurrentSelections functions:

          GetCurrentSelections.png