Cannot find what you need? - Click here to contact us

Close




Custom Rules - DESKTOP VERSION

Resource rule tags:


ForInheritOnly = Resource rule is just used by other resources and never run by itself

Inherit(123) = Always load the rules from another resource (e.g. ID=123)

InheritIfSelected(123) = Load the rules from another resource (e.g. ID=123) but only if its selected in the event.


All rules are run when an event is saved unless rules start with...

% they are run when a NEW event is saved

* they are run when a resource is selected

! they are run when a resource is deselect


0 = no user message, just a rule/formula

1 = show message and ask user for confirmation of action

2 = cancel action and show user message

3 = simply show user message


*0|clear
*1|get|...

!0|clear
!1|get|...

%0|clear
%1|get|...

0|clear
3|get|=|0|...



Clear register = 0|clear
Get the register value and check if its > -1, if so show a message = 3|get|>|-1|Hello




Clear register = 0|clear
Add the number of selected resources to register = 0|+val_res_count
Get the register value and check if its > 0, if so show a message = 3|get|>|0|This event is linked to {1} resources





If event is linked to more than zero resources show a message:

0|clear
0|+val_res_count
3|get|>|0|This event is linked to {1} resources



If event more than 99% complete then change background to green:

0|clear
0|+val|{eCompleted}
0|get|>|99|backcolour:green





If event is linked to resource with id 189, or any sub resource of 189, then change background to red:

0|clear
0|+val_res_count|187
0|get|>|0|backcolour:red





If event is linked to resource with id 189, or any sub resource of 189, then change background to red, but only if the event is new:

ifold will clear the count if the event is old (if old). ifnew will clear the count if the event is new.

0|clear
0|+val_res_count|187
0|clear|ifold
0|get|>|0|backcolour:red





Colour the event based on the number of linked resource, divided by the number in resource data field 4 (e.g. spaces available), multiplied by 100

0|clear
0|+val_res_count
0|/val|{resData4}
0|*val|100
0|get|>|0|backcolour:lightgreen
0|get|>|20|backcolour:darkgreen
0|get|>|49|backcolour:orange
0|get|>|80|backcolour:red





Get percent of booked places and put the value in custom field 7 of the event.

0|clear
0|+val_res_count
0|/val|{resData4}
0|*val|100
0|get|||add_to_frm:{1}|txtcustom7





Compare the event start against a due date in the title field

0|clear
0|is_field_date|txtTitle
2|get|!|1|The title field is not a valid due date ({eTitle})

0|clear
0|+min_diff|{sdate}|{eTitle}
0|/val|1440
3|get|!|0|Due date is {1} days away
3|get|=|0|Due today





Append resource data fields to the event custom field 4

0|get|||add_to_frm:{eCustom4}Room2 : {resData2}nRoom3 : {resData3}nRoom4 : {resData4}n|txtcustom4





Split event duration into standard hours and overtime hours

Part 1...

0|clear
0|get|<|1|add_to_frm:0|txtcustom1
0|get|<|1|add_to_frm:0|txtcustom2
0|clear
0|+val_current_duration
0|/val|60
0|-val|10
0|get|>|0|add_to_frm:{1}|txtcustom2

Part 2... (Add after resource rules as event details change mid rules)

0|clear
0|+val_current_duration
0|/val|60
0|-val|{eCustom2}
0|get|>|0|add_to_frm:{1}|txtcustom1





Add selected resource names to title from group with ID 10 (vesrion>7.7.200)

0|clear
0|+val|10
0|get|>|1|add_to_frm:{namesFromGroup}|txttitle





When a resource is selected copy a field from the resource to the event. E.g. Copy resource details field 6 custom1 in event, for use in later event rules.

*0|clear
*0|get|||add_to_frm:{resData6}|txtcustom1
*3|get|||Just put value{resData6} in custom1





When a resource is selected copy the resource ID to the events custom1 field, for use in later event rules.

*0|clear
*0|get|||add_to_frm:{resID}|txtcustom1
*3|get|||Just put value{resID} in custom1





Add to a resource to make it check if another is selected, or any sub resource selected, or resource from group 189, before a save it allowed.

0|clear
0|+val_res_count|189
2|get|<|1|Resource with ID 189 is not selected.









**************************************** Below are notes only...


Pre resource rules, to put resources IDs from specific group into event.

0|clear
0|+ids_resInGroup|804
0|get|||add_to_frm: |txtcustom1
0|get|||add_to_frm:{2}|txtcustom1

2|get|>|1|Event is link to too many resources in group 804, {1} resources found.




Trainee rule to count how many other events are linked to the same resources in custom 1. Checking for a repeated course.

0|clear
0|+len_of_field|txtcustom1
1|get|<|2|Quiet1
0|clear
0|+val_sql_count||select ID from Events WHERE ID<>{eID} AND ID IN (select EventID from Event_Resource where ResourceID IN ({eCustom1})) AND ID IN (select EventID from Event_Resource where ResourceID IN ({resID}))
2|get|>|0|{resName} is already linked to this course in another event. {1}




*********************************

Trainee Resource rule, Add resource ID to events custom 1

*0|clear
*0|get|||add_to_frm: |txtcustom1
*0|clear
*0|get|||add_to_frm:{resID}|txtcustom1
*3|get|||Just put resource ID {resID} in custom1

// show message about number entered 3|get|||Just put value{resID} in custom1


Course resource rule to Check if event is already link to ID in events custom 1

0|clear
0|+len_of_field|txtcustom1
1|get|<|2|Quiet1
0|clear
0|+val_sql_count||select ID from events WHERE ID<>{eID} AND Owner LIKE '%,{eCustom1},%' AND Owner LIKE '%,{resID},%'
1|get|>|-1|{1} events found.
0|Quiet0




***** Add resource details to event notes for any with this rule

(clear custom 4 with event pre rule first)

0|clear
0|clearS
0|get|||add_to_frm:n|txtcustom4

...then in each resource...

0|get|||add_to_frm:{eCustom4}My Details : {resData2}n|txtcustom4



***** Copy a resource string to and event field

0|clearS
0|+valS|{resData2}
0|get|||add_to_frm:{2}|txtcustom4


0|clearS
0|get|||add_to_frm:{resData2}|txtcustom4

Prefixing rule lines with a * indicates only to be read on select.

*0|clear
*1|get|=|0|Some message to show on click


Prefixing rule lines with a ! indicates only to be read on deselect.


!0|clear
!1|get|=|0|Some message to show on click


***** Add some custom fields to event field 4

0|clear
0|get|<|1|add_to_frm: Resource Details : {resData2},{resData3}, {resData4},n,{resData10}|txtcustom4


***** Add resource data field 2 to event custom field 1

0|clear
0|get|<|1|add_to_frm:{resData2}|txtcustom1


***** Maths ((((5+5)*4)-2)/2) + value in resource data field 2

0|clear
0|+val|5
0|+val|5
0|*val|4
0|-val|2
0|/val|2
0|+val|{resData2}
1|get|>|0|Answer {1}



***** room/resource capacity check

0|clear
0|+val_res_count
1|get|>|{resData6}|Too many resources are assigned with '{resName}'.nnUsed {1}, Available {resData6}nnDo you want to continue and save the event ?



************




0|clear
0|+len_of_field|txtcustom1
1|get|>|0|Quiet1

0|clear
0|+val_current_duration
2|get|>|720|WARNING (RULE A): The planned event duration is more than 12 hours for {resName}.
1|get|>|-1|Save as planned event and copy planned dates to details ?

0|Quiet0

0|clear
0|+len_of_field|txtcustom1
0|get|<|1|add_to_frm:{sdate}|txtcustom1
0|get|<|1|add_to_frm:{edate}|txtcustom2

0|clear
0|+len_of_field|txtcustom7
0|get|<|1|add_to_frm:0|txtcustom7

0|clear
0|+len_of_field|txtcustom8
0|get|<|1|add_to_frm:0|txtcustom8

0|clear
0|+val_sql_count|10080|select ID from events WHERE ID<>{current_ID} AND DateStart>=#{current_end}# AND DateStart<#{current_end_calc}# AND Owner LIKE '%,{resID},%'
0|add_sql_count|-10080|select ID from events WHERE ID<>{current_ID} AND DateEnd<=#{current_start}# AND DateEnd>#{current_end_calc}# AND Owner LIKE '%,{resID},%'
1|get|>|13|WARNING (Rule D1): {1} events has been found within 14 days around this event for {resName}.

0|clear
0|+val_sql_count|-719|select ID from events WHERE ID<>{current_ID} AND DateStart<#{current_start}# AND DateEnd>#{current_start_calc}# AND Owner LIKE '%,{resID},%'
2|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of the start of this event for {resName}.

0|clear
0|+val_sql_count|719|select ID from events WHERE ID<>{current_ID} AND DateEnd>#{current_end}# AND DateStart<#{current_end_calc}# AND Owner LIKE '%,{resID},%'
1|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of this end of this event for {resName}.

0|clear
0|is_field_num|txtcustom7
2|get|<|1|'Travel To' field must be a number containing the number of minutes

0|clear
0|is_field_num|txtcustom8
2|get|<|1|'Travel From' field must be a number containing the number of minutes

0|clear
0|+val_current_duration
1|get|>|720|WARNING (RULE A): The actual worked duration for '{resName}' exceeds the 12 hours allowed.nnIf you continue and save the event it will be marked 'Breach A', and you MUST complete the risk assessment form.nnContinue with save ?
0|get|>|720|add_to_res:,2283,
0|get|>|720|add_to_log:'Breach A' Accepted
0|get|>|720|change_tab:2

0|clear
0|+val_current_duration
0|+val_of_field|txtcustom7
0|+val_of_field|txtcustom8
1|get|>|840|WARNING (Rule E): The event duration including any travel time is more than 14 hours for {resName}.nnIf you continue and save the event it will be marked 'Breach E', and you MUST enter a reason.nnContinue with save ?
0|get|>|840|add_to_res:,2325,
0|get|>|840|add_to_log:'Breach E' Accepted

0|clear
0|+val_current_duration
0|+val_sql_duration||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd<#{next_sunday}# AND DateStart>#{last_monday}# AND Owner LIKE '%,{resID},%'
1|get|>|4320|WARNING (RULE B): The actual minutes worked this week for '{resName}' is '{1}'. This exceeds the 72 hours allowed.nnIf you continue and save the event it will be marked 'Breach B', and you MUST supply a reason.nnContinue with save ?
0|get|>|4320|add_to_res:,2284,
0|get|>|4320|add_to_log:'Breach B' Accepted






-------------------------------







0|clear
0|+len_of_field|txtcustom1
1|get|>|0|Quiet1

0|clear
0|+val_current_duration
2|get|>|720|WARNING (RULE A): The planned event duration is more than 12 hours for {resName}.
1|get|>|-1|Save as planned event and copy planned dates to details ?

0|Quiet0

0|clear
0|+len_of_field|txtcustom1
0|get|<|1|add_to_frm:{sdate} - {edate}|txtcustom1

0|clear
0|+len_of_field|txtcustom2
0|get|<|1|add_to_frm:0|txtcustom2

0|clear
0|+len_of_field|txtcustom3
0|get|<|1|add_to_frm:0|txtcustom3

0|clear
0|+val_sql_count|10080|select ID from events WHERE ID<>{current_ID} AND DateStart>=#{current_end}# AND DateStart<#{current_end_calc}# AND Owner LIKE '%,{resID},%'
0|add_sql_count|-10080|select ID from events WHERE ID<>{current_ID} AND DateEnd<=#{current_start}# AND DateEnd>#{current_end_calc}# AND Owner LIKE '%,{resID},%'
1|get|>|13|WARNING (Rule D1): {1} events has been found within 14 days around this event for {resName}.

0|clear
0|+val_sql_count|-720|select ID from events WHERE ID<>{current_ID} AND DateStart<#{current_start}# AND DateEnd>#{current_start_calc}# AND Owner LIKE '%,{resID},%'
2|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of the start of this event for {resName}.

0|clear
0|+val_sql_count|720|select ID from events WHERE ID<>{current_ID} AND DateEnd>#{current_end}# AND DateStart<#{current_end_calc}# AND Owner LIKE '%,{resID},%'
1|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of this end of this event for {resName}.

0|clear
0|is_field_num|txtcustom2
2|get|<|1|'Travel To' field must be a number containing the number of minutes

0|clear
0|is_field_num|txtcustom3
2|get|<|1|'Travel From' field must be a number containing the number of minutes

0|clear
0|+val_current_duration
1|get|>|720|WARNING (RULE A): The actual worked duration for '{resName}' exceeds the 12 hours allowed.nnIf you continue and save the event it will be marked 'Breach A', and you MUST complete the risk assessment form.nnContinue with save ?
0|get|>|720|add_to_res:,2283,
0|get|>|720|add_to_log:'Breach A' Accepted
0|get|>|720|change_tab:2

0|clear
0|+val_current_duration
0|+val_of_field|txtcustom2
0|+val_of_field|txtcustom3
1|get|>|840|WARNING (Rule E): The event duration including any travel time is more than 14 hours for {resName}.nnIf you continue and save the event it will be marked 'Breach E', and you MUST enter a reason.nnContinue with save ?
0|get|>|840|add_to_res:,2325,
0|get|>|840|add_to_log:'Breach E' Accepted

0|clear
0|+val_current_duration
0|+val_sql_duration||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd<#{next_sunday}# AND DateStart>#{last_monday}# AND Owner LIKE '%,{resID},%'
1|get|>|4320|WARNING (RULE B): The actual minutes worked this week for '{resName}' is '{1}'. This exceeds the 72 hours allowed.nnIf you continue and save the event it will be marked 'Breach B', and you MUST supply a reason.nnContinue with save ?
0|get|>|4320|add_to_res:,2284,
0|get|>|4320|add_to_log:'Breach B' Accepted



---------------

remove seconds

if start at midnight

0|seti2|1


0|clear
0|+len|txtcustom1
1|get|>|-1| reg value is {1}, len

0|clear
0|+val|txtcustom1
1|get|>|-1| reg value is {1}, val

0|clear
0|is_num|txtcustom1
1|get|>|-1| reg value is {1}, is num

0|clear
0|+val_current_duration
1|get|>|-1| reg value is {1}, is current duration


0|clear
0|+val_current_duration
1|get|>|-1| reg value is {1}, is current duration


0|clear
0|+val_current_duration
1|get|>|-1| reg value is {1}, is current duration




ForInheritOnly



0|clear
0|add_len|txtcustom7
1|get|>|0|Quiet1

0|clear
0|add_new_durationM
2|get|>|720|WARNING (RULE A): The planned event duration is more than 12 hours for {resName}.
1|get|>|-1|Save as planned event ?
0|Quiet0

0|clear
0|add_len|txtcustom7
0|get|<|1|Add_To_Cu7:{sdate}
0|get|<|1|Add_To_Cu8:{edate}

0|clear
0|add_new_durationM
2|get|<|0|ALERT: The actual worked duration is less than 0!
1|get|>|720|WARNING (RULE A): The actual worked duration for '{resName}' exceeds the 12 hours allowed.nnIf you continue and save the event it will be marked 'Breach A', and you MUST complete the risk assessment form.nnContinue with save ?
0|get|>|720|Add_To_Res:,2283,
0|get|>|720|Add_To_Log:'Breach A' Accepted
0|get|>|720|Change_Tab:2






0|clear
0|add_sql_count|10080|select ID from events WHERE ID<>{current_ID} AND DateStart>=#{current_end}# AND DateStart<#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
0|add_sql_count|-10080|select ID from events WHERE ID<>{current_ID} AND DateEnd<=#{current_start}# AND DateEnd>#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
1|get|>|13|WARNING (Rule D1): {1} events has been found within 14 days around this event for {resName}.

0|clear
0|add_sql_count|-720|select ID from events WHERE ID<>{current_ID} AND DateStart<#{current_start}# AND DateEnd>#{current_start_calcM}# AND Owner LIKE '%,{resID},%'
2|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of the start of this event for {resName}.

0|clear
0|add_sql_count|720|select ID from events WHERE ID<>{current_ID} AND DateEnd>#{current_end}# AND DateStart<#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
1|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of this end of this event for {resName}.

0|clear
0|add_new_durationM
0|add_new_custom2
0|add_new_custom3
1|get|>|840|WARNING (Rule E): The event duration including any travel time is more than 14 hours for {resName}.nnIf you continue and save the event it will be marked 'Breach E', and you MUST enter a reason.nnContinue with save ?
0|get|>|840|Add_To_Res:,2325,
0|get|>|840|Add_To_Log:'Breach E' Accepted


0|clear
0|get|>|-1|Add_To_Cu7:{sdate}
0|get|>|-1|Add_To_Cu8:{edate}
0|add_cust78_diffM
2|get|<|0|ALERT: The actual worked duration is less than 0!
1|get|>|720|WARNING (RULE A): The actual worked duration for '{resName}' exceeds the 12 hours allowed.nnIf you continue and save the event it will be marked 'Breach A', and you MUST complete the risk assessment form.nnContinue with save ?
0|get|>|720|Add_To_Res:,2283,
0|get|>|720|Add_To_Log:'Breach A' Accepted
0|get|>|720|Change_Tab:2
0|get|>|720|Add_To_Cu7:{sdate}
0|get|>|720|Add_To_Cu8:{edate}

0|clear
0|add_new_durationM
0|add_sql_durationM||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd<#{next_sunday}# AND DateStart>#{last_monday}# AND Owner LIKE '%,{resID},%'
1|get|>|4320|WARNING (RULE B): The actual minutes worked this week for '{resName}' is '{1}'. This exceeds the 72 hours allowed.nnIf you continue and save the event it will be marked 'Breach B', and you MUST supply a reason.nnContinue with save ?
0|get|>|4320|Add_To_Res:,2284,
0|get|>|4320|Add_To_Log:'Breach B' Accepted
0|get|>|4320|Change_Tab:4







-----------------


0|clear
0|add_new_durationM
2|get|>|720|WARNING: The planned event duration is more than 12 hours for {resName}.

0|clear
0|add_new_durationM
0|add_new_custom2
0|add_new_custom3
1|get|>|840|(Rule E) The event duration including any travel time is more than 14 hours ({1} mins) for {resName}.

0|clear
0|get|>|-1|Add_To_Cu7:{sdate}
0|get|>|-1|Add_To_Cu8:{edate}
0|add_cust78_diffM
2|get|<|0|ALERT: The actual worked duration is less than 0!
1|get|>|720|WARNING: The actual worked duration for '{resName}' exceeds the 12 hours allowed.nnIf you continue and save the event it will be marked 'Breach A', and you MUST complete the risk assessment form.nnContinue with save ?
0|get|>|720|Add_To_Res:,2283,
0|get|>|720|Add_To_Log:'Breach A' Accepted
0|get|>|720|Change_Tab:2
0|get|>|720|Add_To_Cu7:{sdate}
0|get|>|720|Add_To_Cu8:{edate}

0|clear
0|add_new_durationM
0|add_sql_durationM||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd<#{next_sunday}# AND DateStart>#{last_monday}# AND Owner LIKE '%,{resID},%'
1|get|>|4320|WARNING: The actual minutes worked this week for '{resName}' is '{1}'. This exceeds the 72 hours allowed.nnIf you continue and save the event it will be marked 'Breach B', and you MUST supply a reason.nnContinue with save ?
0|get|>|4320|Add_To_Res:,2284,
0|get|>|4320|Add_To_Log:'Breach B' Accepted
0|get|>|4320|Change_Tab:4





maybe-----------



ForInheritOnly

0|clear
0|add_new_durationM
2|get|>|720|WARNING (RULE A): The planned event duration is more than 12 hours for {resName}.


0|clear
0|add_sql_count|10080|select ID from events WHERE ID<>{current_ID} AND DateStart>=#{current_end}# AND DateStart<#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
0|add_sql_count|-10080|select ID from events WHERE ID<>{current_ID} AND DateEnd<=#{current_start}# AND DateEnd>#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
1|get|>|13|WARNING (Rule D1): {1} events has been found within 14 days around this event for {resName}.

0|clear
0|add_sql_count|-720|select ID from events WHERE ID<>{current_ID} AND DateStart<#{current_start}# AND DateEnd>#{current_start_calcM}# AND Owner LIKE '%,{resID},%'
2|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of the start of this event for {resName}.

0|clear
0|add_sql_count|10080|select ID from events WHERE ID<>{current_ID} AND DateEnd>#{current_start_calcM}# AND DateStart<#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
1|get|>|0|WARNING (Rule D1): {1} events has been found within 14 days around this event for {resName}.

0|clear
0|add_sql_count|720|select ID from events WHERE ID<>{current_ID} AND DateEnd>#{current_end}# AND DateStart<#{current_end_calcM}# AND Owner LIKE '%,{resID},%'
1|get|>|0|WARNING (Rule C1): The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of this end of this event for {resName}.

0|clear
0|add_new_durationM
0|add_new_custom2
0|add_new_custom3
1|get|>|840|WARNING (Rule E): The event duration including any travel time is more than 14 hours for {resName}.

0|clear
0|get|>|-1|Add_To_Cu7:{sdate}
0|get|>|-1|Add_To_Cu8:{edate}
0|add_cust78_diffM
2|get|<|0|ALERT: The actual worked duration is less than 0!
1|get|>|720|WARNING (RULE A): The actual worked duration for '{resName}' exceeds the 12 hours allowed.nnIf you continue and save the event it will be marked 'Breach A', and you MUST complete the risk assessment form.nnContinue with save ?
0|get|>|720|Add_To_Res:,2283,
0|get|>|720|Add_To_Log:'Breach A' Accepted
0|get|>|720|Change_Tab:2
0|get|>|720|Add_To_Cu7:{sdate}
0|get|>|720|Add_To_Cu8:{edate}

0|clear
0|add_new_durationM
0|add_sql_durationM||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd<#{next_sunday}# AND DateStart>#{last_monday}# AND Owner LIKE '%,{resID},%'
1|get|>|4320|WARNING (RULE B): The actual minutes worked this week for '{resName}' is '{1}'. This exceeds the 72 hours allowed.nnIf you continue and save the event it will be marked 'Breach B', and you MUST supply a reason.nnContinue with save ?
0|get|>|4320|Add_To_Res:,2284,
0|get|>|4320|Add_To_Log:'Breach B' Accepted
0|get|>|4320|Change_Tab:4






before-----------


0|clear
0|add_new_duration
1|get|>|12|(Rule A) The event duration is more than 12 hours ({1}) for {resName}.

0|clear
0|add_new_duration
0|add_new_custom2
0|add_new_custom3
1|get|>|14|(Rule E) The event duration including any travel time is more than 14 hours ({1}) for {resName}.

0|clear
0|add_sql_count|-12|select ID from events WHERE ID<>{current_ID} AND DateStart<#{current_start}# AND DateEnd>#{current_start_calc}# AND Owner LIKE '%,{resID},%'
1|get|>|0|(Rule C1) The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of the start of this event for {resName}.



0|clear
0|add_sql_count|12|select ID from events WHERE ID<>{current_ID} AND DateEnd>#{current_end}# AND DateStart<#{current_end_calc}# AND Owner LIKE '%,{resID},%'
1|get|>|0|(Rule C1) The minimum rest period of 12 hours is not met. {1} events has been found within 12 hours of this end of this event for {resName}.




**************************************

0|clear
0|is_field_num|txtcustom7
2|get|<|1|'Travel To' field must be a number containing the number of minutes

0|clear
0|is_field_num|txtcustom8
2|get|<|1|'Travel From' field must be a number containing the number of minutes

0|clear
0|+val_of_field|txtcustom7
1|get|>|180|The event travel time to time is more than 3 hours for {resName}.nnConfirm Risk Assessment 'SF007 Driving and Travel Time Risk Assessment' has been completed and continue with save ?
0|get|>|180|add_to_res:,2325,
0|get|>180|add_to_log:'More than 3 hours travel to' Accepted

0|clear
0|+val_of_field|txtcustom8
1|get|>|180|The event travel time from time is more than 3 hours for {resName}.nnConfirm Risk Assessment 'SF007 Driving and Travel Time Risk Assessment' has been completed and continue with save ?
0|get|>|180|add_to_res:,2325,
0|get|>|180|add_to_log:'More than 3 hours travel from' Accepted

0|clear
0|+val_of_field|txtcustom7
0|+val_of_field|txtcustom8
1|get|>|360|The event travel time is more than 6 hours for {resName}.nnConfirm Risk Assessment 'SF007 Driving and Travel Time Risk Assessment' has been completed and continue with save ?
0|get|>|360|add_to_res:,2325,
0|get|>|360|add_to_log:'More than 6 hours travel' Accepted


0|clear
0|+val_current_duration
0|+val_of_field|txtcustom7
0|+val_of_field|txtcustom8
1|get|>|840|The event duration including any travel time is more than 14 hours for {resName}.nnConfirm Risk Assessment 'SF007 Driving and Travel Time Risk Assessment' has been completed and continue with save ?
0|get|>|840|add_to_res:,2325,
0|get|>|840|add_to_log:'More than 14 hours with Travel' Accepted


0|clear
0|+val_duration_between||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd>#{current_start+input4}# AND DateStart<#{current_end+input4}# AND Owner LIKE '%,{resID},%'|1440
0|/val|60
1|get|>|12|'{resName}' will have more than 12 hours in any 24 hour period ({1}).nnConfirm Risk Assessment 'SF008 Working Hours Risk Assessment' has been completed and continue with save ?
0|get|>|12|add_to_res:,203,
0|get|>|12|add_to_log:'More than 12 hours in any 24 hour period' Accepted

0|clear
0|+val_duration_between||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd>#{current_start+input4}# AND DateStart<#{current_end+input4}# AND Owner LIKE '%,{resID},%'|10080
0|/val|60
1|get|>|72|'{resName}' will have more than 72 hours in any 7 day period ({1}).nnConfirm Risk Assessment 'SF008 Working Hours Risk Assessment' has been completed and continue with save ?
0|get|>|72|add_to_res:,203,
0|get|>|72|add_to_log:'More than 72 hours in any 7 day period' Accepted

0|clear
0|+val_count_between||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd>#{current_start+input4}# AND DateStart<#{current_end+input4}# AND Owner LIKE '%,{resID},%'|20160
1|get|>|13|'{resName}' will have more than 13 events in any 14 day period ({1}).nnConfirm Risk Assessment 'SF008 Working Hours Risk Assessment' has been completed and continue with save ?
0|get|>|13|add_to_res:,203,
0|get|>|13|add_to_log:'More than 13 events in any 14 day period' Accepted

0|clear
0|+val_duration_between||select ID,DateStart,dateEnd from events WHERE ID<>{current_ID} AND DateEnd>#{current_start+input4}# AND DateStart<#{current_end+input4}# AND Owner LIKE '%,{resID},%'|10080
0|/val|60
3|get|>|60|'{resName}' will have more than 60 hours in any 7 day period ({1}).nnContinue with save ?

Last updated, 13 August 2014, 17:38




Leave a reply (Login required)




Schedule it Ltd
/faq/10410/custom-rules---desktop-version

Subscribe to our newsletter and receive our free scheduling tips and articles to help you improve the planning in your business. Unsubscribe anytime.

GET STARTED RESOURCES
Login Support and Help
Register Blog
Features Privacy Policy
Online Pricing Terms and Conditions
On-Prem Pricing Industry Sectors
Latest Version Reviews and Feedback
Live Webinar Status
APPS POPULAR SEARCHES
Web App Team Scheduling
iOS App Employee Planning
Android App Customer Scheduling
Zapier App Engineer Scheduling


Start Your Free Trial Today



Copyright © 2003-2022 Schedule it Ltd. All rights reserved.
Schedule it on LinkedIn   Schedule it on Twitter   Schedule it on YouTube   Schedule it on Facebook
Join Us - Live Webinar
...
 
Help Topics
Contact Us