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