AnsweredAssumed Answered

Trigger script on calculated field change

Question asked by trogt on May 10, 2016
Latest reply on May 10, 2016 by dsvail

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!

Attachments

Outcomes