1 Reply Latest reply: Apr 21, 2016 4:36 AM by Nitin Gupta RSS

    MULTI BOX - SELECT MULTIPLE FIELDS

    Luca V

      Hi,

      from my script i extract some data/time fields with different name because i don't want join them.

      YEAR - MONTH - DAY - HOUR

      and

      YEAR_RATE  - MONTH_RATE - DAY_RATE - HOUR_RATE

       

      In some sheets of my project i use a multibox with first row records but in other sheets i use the second row.

       

      When a change sheet i would like to have the same selection, is it possible ?

       

      Example:

      sheet 1 - i select YEAR = 2016

      then i go to sheet 2

      i would like that YEAR_RATE is set to 2016

       

      maybe YEAR_RATE doesn't contains 2016....

       

      Thanks

        • Re: MULTI BOX - SELECT MULTIPLE FIELDS
          Nitin Gupta

          You can use Select in Field trigger while traversing to different sheets...

           

          The syntax you can use is

           

          Suppose In sheet 1 You have selected  Year as 2016 and Month as Jan, Feb

           

          The in Sheet 2 , you should write an action on Sheet activate,

          1. Select In Field > Field Name> Year_Rate, Value> '('&concat(distinct Year,'|')&')'

          2. Select In Field > Field Name> Month_Rate, Value> '('&concat(distinct Month,'|')&')'



          Similar actions can be defined at sheet 1 also for traversing in reverse manner.


          Hope this help you out.



          Regards

          Nitin