Purpose |
To update an Entry’s Booking > Check Out Date to be 24 hours (1 day) or 48 hours (2 days) after their Final Exam Date. The Final Exam Date data point being used is stored under the ROSI Final Exam Timeslot field (EntryCustomField[CustomFieldDefinitionID=464]) |
Subscription Type | Update a Record |
Trigger |
When data is updated in the selected table. Specifically, when the boolean field Booking > CustomBit4 is updated from FALSE to TRUE in the relevant Booking record |
Table | Booking |
Field Name | Custom Bit 4 |
Filter Records |
For 24 hour Data Sub ( ([Booking].CustomBit4 = 1) AND ([Booking].RoomLocationID IN (43, 42, 41, 27, 28, 94, 29, 68, 30, 31, 32, 33, 96, 34, 35, 36, 37, 38, 39, 40, 52)) AND ([Booking].EntryStatusEnum IN (2, 5)) )
For 48 hour Data Sub ( ([Booking].CustomBit4 = 1) AND ([Booking].RoomLocationID IN (7, 82, 91, 92, 67, 53, 59, 18, 16, 17, 19, 87, 88, 62, 61, 2, 3, 73, 5, 6)) AND ([Booking].EntryStatusEnum IN (2, 5)) ) |
On Data Updated | Update a field on the Booking record |
Field | Check Out Date |
Value |
For 24 hour data sub {NewData_EntryID.EntryCustomField[CustomFieldDefinitionID=464].ValueDate:1d,MM/dd/yyyy HH:mm:ss}
For 48 hour data sub {NewData_EntryID.EntryCustomField[CustomFieldDefinitionID=464].ValueDate:2d,MM/dd/yyyy HH:mm:ss} |