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