Description

If a Contact Attendance record is inserted or its Status field is changed, this trigger will update the booking status appropriately.

If any Contact Attendances for a booking are cancelled, then the related booking is cancelled. If all a booking's primary contacts (Contact Attendance records with the Primary Contact field set) are confirmed, then the booking is confirmed.

If the booking has no primary contacts, but all its related Contact Attendances are confirmed, then the booking is also confirmed.