I need help with applying filters to a portal records.
I have activities sheet with date and time. I was trying to search for portal records based on time range. The part I am struggling on is filter activities in "Last 7 days" or "Last 30 days".
I tried using case statements for example if "period selected = "Last 7 Days " than go to table and field, get current date and do - 7. But this case statement does not work.
So how we can apply if/else or case statements in portal to filter records.