We have a layout for our bookings - on it is a calculated field which has the total cost to the client including tax (VAT). Another field indicates the status which should be as follows:
Open - a sample booking to send to clients - this status should not be changed when booking cost changes
Reserved - the Client has said go ahead but not yet paid -
Booked - The Client has said go ahead and the booking is fully paid
Finished - the booking is finished but not fully paid
Complete - the booking is finished and fully paid
Cancelled - this status should not be changed when booking cost changes (in reality this will not happen)
So for example when the date or time or daily cost on a booking changes the total cost (calculated) field updates. However if for example the booking had been fully paid (Booked) but now the total cost is more then the booking is now only partially paid and the status needs to be updated back to Reserved.
Can I trigger a script whenever the total cost (calculated) field changes? The cost will change whenever the date / time / rate of the booking is changed.
Your help appreciated!