0 Replies Latest reply: Oct 27, 2016 5:57 AM by Giorgia Michieli RSS

    How to pass the value of a field to another field?

    Giorgia Michieli

      Hello, my goal is to navigate selections by making sure that, if I select certain values from field1, they are reflected in the field2, erasing the selection from the field 1.

      Let me explain with an example:

      This is my table


       

      Dim1 Dim2 Dim3
      AaX
      AaY
      AaZ
      AbX
      AbY
      AbZ
      BcX
      BcY
      BcZ
      BdX
      BdY
      BdZ
      CeX
      CeY
      CeZ
      CfX
      CfY
      CfZ


      Now, I select value B from Dim1


       

      Dim1 Dim2 Dim3
      BcX
      BcY
      BcZ
      BdX
      BdY
      BdZ


      Now I want that Dim2 is filtered by the value I selected in Dim1, in this way:


       

      Dim1 Dim2 Dim3
      AbX
      AbY
      AbZ


      Up to here it works using a button and a variable.

      I created a variable: variabile1=GetFieldSelections( Dim1).

      The button has three actions:

      Select in field --> Dim2=variabile1

      Clear field --> Dim1

      Clear field --> Dim2

      You can see my example attached.


      1. Is there a way to do this without a button?

      2. If I select multiple value from Dim1, my button doesn't work. Any idea?


      Thanks!