2 Replies Latest reply on Jul 1, 2019 8:29 AM by Patrik Backentoft

    Action with input from changing date part

    Patrik Backentoft

      I have an action set up so that when I select a value in a table on sheet 1, redirects me to another sheet and filters that sheet based on my selection on sheet 1.

      The thing is sheet 1 has a date as the column dimension and the action works fine with the filter set to a specific date part which is the same as the dimension for the table, e.g. DAY.

      I would like the user to be able to change the "level" of date for the date-field (e.g. from DAY to MONTH) and the action to take this into account when filtering the destination sheet.

      I found something similar by using parameters, but not for date parts however...

       

      I'd appreciate any input if someone has done something similar?!

       

      BR,

      Patrik