Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I need a small on how to create a logic to develop buttons for lastweek & Current week.
when user click on lastweek button whole lastweek start from monday to sunday all dates should get selected and data has to be updated as per those dates,
similry for currentweek button too.
Please convert expression--> ='>=$(=WeekStart(today()))<=$(=today())' to the format of the field on which you are going to apply filter. it is working as expected .
Try below, it should work
Current week Button--
Action-- Select Value Matching search Criteria
Field--Date field
Value-- ='>=$(=WeekStart(today()))<=$(=today())'
Last week Button--
Action-- Select Value Matching search Criteria
Field--Date field
='>=$(=WeekStart(today(),-1))<=$(=Weekend(today(),-1))'
Add one more action of clearing selection in field before select value action for each button
Hi Durgesh,
Thank you for helping me. I tried above result is getting in number format like37581of 38034.
and for we weekstart function in not working in front end
Please convert expression--> ='>=$(=WeekStart(today()))<=$(=today())' to the format of the field on which you are going to apply filter. it is working as expected .
Thank you so much for you help Durgesh. This logic worked for me a lot