Auto Assigning a record number
I am using CRM Deals module. I have a Quote Number field in my Deals form. I would like to assign the Quote Number to be 1 number higher than the last record added, so similar to an AutoNumber field.
example I have 10 records already in my Deals with a sequential Quote Number and the next record I add I would like to assign a Quote number the value of 11.
The reason why I am not using the Zoho CRM Autonumber field is I have imported previous deal records with already assigned quote numbers. If I use the Zoho CRM Autonumber CRM wants to assign a new number to each imported record. My numbers will never match my historical Quote Numbers.
I am trying to figure out how to accomplish this using a Function but am struggling and not sure I am on the right track.