Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
isciberras
Creator
Creator

Creating a button with set analysis

Hi can anyone help me please

I am trying to create a button with (ActionsSelect in field).

I want the button to incorporate the following set analysis filter:

[day]={'Mon','Tue','Wed,''Thu','Fri'}, [time]={">06:45:00"}    as well as  [day]={'Sat','Sun'} without any time filter

Basically what I am trying to achieve is Monday to Friday only bringing back logs  greater than the following time: 06:45:00 as well as all logs on sat and Sunday irrelevant of a time filter.

Does anyone know if this is possible?

Thanks,

Isaac

1 Solution

Accepted Solutions
sunny_talwar

May be this

If((Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45)) or Match(day, 'Sun', 'Sat'), 1, 0) as Flag

View solution in original post

4 Replies
sunny_talwar

Why don't you create a flag in the script like this

If(Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45), 1, 0) as Flag

and now use this in your button action

Field

Flag

Search String

1

isciberras
Creator
Creator
Author

Thank you, that worked great however the part I'm struggling with is including Sat and Sun without any time filter, would you happen to have any ideas?

sunny_talwar

May be this

If((Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45)) or Match(day, 'Sun', 'Sat'), 1, 0) as Flag

isciberras
Creator
Creator
Author

You are a genius thank you so much for your help you always sole my problems when I'm completely stuck