Harsha - Thursday, August 2, 2012 2:12 AM:
Hi,
I am Facing a problem while assigning the sequence numbers to an 'Item type' property. In my case I have to assign sequence numbers in the format Of 'AUD-Q1-2012-001'.
Where Q1 should increment its value up to Q4 after that it should again start from Q1.
And the Year Should be the current year, if the current year is 2013 the format should be 'AUD-Q1-2013-001', even the value '001' should also increment by 1.
Is it Possible to create this format, help me with your answers.
Thank You
Harsha
asha_gholve - Monday, August 13, 2012 8:17 AM:
Hi Harsha,
To Create this kind of sequence plz create two sequences, first one will start from 1 and second will start from 001. Keep both the sequences hidden.
Create another property with data type as string, now in OnAfterSave event add a method to concatenate above sequences in required format, and calculate the current year and join all the strings, and set the final result to the property.
Regards,
Asha
Harsha - Tuesday, August 14, 2012 5:53 AM:
Hi Asha,
Thank you for your reply. I will try this.
But In which way I can add loop to my sequence? Can I add under form event on OnLoad event?
Thank you,
Harsha
