Clear All in Date Picker

[#1]

I have a date picker in my app which the user can select the to and from dates. This date picker is copied onto the 4 other tabs too so the user can change the dates if required in the different tabs.

I would like it when the user moves to another tab that the date picker dates clear.

I have a field called DATE and two variables VStartDate and vEndDate

The variables have just dates in them in variable overview. Well the date number e.g. 42375

The date picker start date has a min value of  =date(min({1}date),'dd/mm/yyyy') in it and the max value of =vEndDate

The date picker end date has a min value of =VStartDate and max value of =date(max({1}date),'dd/mm/yyyy')

I have tried an action to clear the fields but it isn't working

Does anyone have an idea of how to rest these fields

Thanks

[prat1507]

Change the variable values while switching to other tabs.

Regards

Pratyush

[sunny_talwar]

Not sure how all of this is setup... would you be able to share a sample where you are doing this?

[RonaldDoes]

You could have a trigger OnActivateSheet to set variable vStartDate to Null() and vEndDate to Null().

This would clear your datepickers. However, it appears to me to be counterintuitive, depending on dashboard design.

[#5]

How could I do this? Would it be through Select in Field option? How can I set this to null? Thanks

[sunny_talwar]

You can use Set Variable action within External action type to set variable value to null

[RonaldDoes]

Hi Sarah,

As usual, stalwar1‌ beat me to it

His suggestion below is the one I had in mind for you. Open the sheet properties by clicking CTRL+ALT+S and go to tab Triggers. Just add the variable names and =Null() to the respective fields.