AnsweredAssumed Answered

Script for Field of Calculated Value

Question asked by Stereoinitials on Sep 8, 2009
Latest reply on Sep 17, 2009 by philmodjunk

Title

Script for Field of Calculated Value

Post

Hi 

 

If my project database are indexed such that every record has a Estimate/Quote no which is defined as a running serial number.

Only a confirmed/commissioned job is defined by a job number in running order. 

 

Since not every job quoted will be commissioned, I would like to have a script whereby it will calculate from Job No. of the last/latest record and add 1 to the numerical value.  I do wish to have the job no. to be a serial running number as it isn't applicable in this scenario.

 

Can anyone help me out with the script please?

 

Appreciate it lots.  Thank you. 

Outcomes