Form counter
Form counter
(OP)
I have been looking for an easy way to give a new form a number each time a user enters one.
Like in a help desk where call 1000 would be the first call and the next form would have a call number 1001 (auto)
I guess this is not easy as some of the code to do it I have look at is a tad on the hard side.
So how can I have a field on a form that is added to each time a new form is opened.
Hope that is clear !
Like in a help desk where call 1000 would be the first call and the next form would have a call number 1001 (auto)
I guess this is not easy as some of the code to do it I have look at is a tad on the hard side.
So how can I have a field on a form that is added to each time a new form is opened.
Hope that is clear !
RE: Form counter
Leslie
landrews@metrocourt.state.nm.us
There are 10 types of people in the world -
those who understand binary
and
those who don't!
RE: Form counter
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
RE: Form counter
Thanks for your time
RE: Form counter
http://www-10.lotus.com/ldd/sandbox.nsf/e26da15be91bde91852566f0006941d9/7d425c5fa551055685256b560058219d?OpenDocument
It has an example database you can download and go into the design to see how it's done.
Hope this helps
RE: Form counter