1 Reply Latest reply on May 10, 2016 10:33 AM by dsvail

    Trigger script on calculated field change

    trogt

      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!