Script for Field of Calculated Value
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.