Form counter 2

see thread245-184386 for more information on autonumbering


Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

One way I've done this in previous projects is to generate a number based on the date and time the form was created. This would create a new number every minute. The only drawback would be if two documents where created in the one minute.

The following code generates a number like 14073-1706 if the form was created on July 14 03 at 1706. Just use it as the default value of a Computed When Composed field.

YearString := @Right(@Text(@Year(@Now)); 1);
MonthString := @If(@Month(@Now) >= 10; @Text(@Month(@Now)); "0" + @Text(@Month(@Now)));
DayString := @If(@Day(@Now) >= 10; @Text(@Day(@Now)); "0" + @Text(@Day(@Now)));
HourString := @If(@Hour(@Now) >= 10; @Text(@Hour(@Now)); "0" + @Text(@Hour(@Now)));
MinuteString := @If(@Minute(@Now) >= 10; @Text(@Minute(@Now)); "0" + @Text(@Minute(@Now)));
@If(@IsNewDoc;DayString + MonthString + YearString + "-" + HourString + MinuteString;fieldname)

Hope this helps

Thanks guys. Helped me some but still not got it to work !!

Thanks for your time

Try this link


It has an example database you can download and go into the design to see how it's done.

Hope this helps

Thanks for the help folks got it working now.