I am trying to clear a field, 'Receipt_WeekStart' before populating with the maximum date. I have a 'OnOpen' trigger under document properties that clears the field and then sets the value. The clear is not working. See attached screenshots.
you can do this without macro.delete the clear field trigger and try to use date(max( {1} Receipt_WeekStart)), this will ignore any selections and set the max Weekstart. Also make sure you are giving the right date format.
Plz put the clear field action after all of the actions.put it in last then it will work.here you have after clear field u can select a field action is der so thats the problem
Putting the clear field after the other actions did not work. Now when I close and reopen the app, the date filter is blank. I need this field cleared and repopulated when I re-open the app or tab off and back onto the sheet. The only way I can get this to work is to manually clear the filter and tab off and back onto the sheet. Not what I need though.
you can do this without macro.delete the clear field trigger and try to use date(max( {1} Receipt_WeekStart)), this will ignore any selections and set the max Weekstart. Also make sure you are giving the right date format.
