Page 1 of 1

Sequential forms

Posted: Wed Jun 16, 2010 6:29 pm
by duncanpickard
OK, I have done some searching and found nothing helpful.

I have a form in writer. I need to print out say, 100 of these forms with a number on each one, starting with 1 and going to 100. The next time I print the forms they will have to go from 101 to 200, and so forth. Is there any way for me to do this?

Re: Sequential forms

Posted: Wed Jun 16, 2010 11:24 pm
by RPG
Hello

I think what you want is not easy possible, maybe with macros.
The question is do you realy need a form?

Romke

Re: Sequential forms

Posted: Wed Jun 16, 2010 11:33 pm
by RoryOF
Romke: I think he means a document, which he needs sequentially numbered, not a form as used in Base.

Re: Sequential forms

Posted: Thu Jun 17, 2010 1:47 am
by RPG
Hello

It was difficult for me to think he did not mean a database form, but after some time it comes clear to me.

Maybe the OP can make it more clear.

Romke

Re: Sequential forms

Posted: Thu Jun 17, 2010 2:15 am
by duncanpickard
This is a document in Writer, not a form in the database.

The document happens to contain a "form" that, once printed will be filled out by employees. These paper forms need to be sequentially numbered.

Re: Sequential forms

Posted: Thu Jun 17, 2010 3:04 am
by RPG
Hello

When it is not a database form and also not bind to a database I don't know a method for numbering. But when it is a bind to a database then you can put in a field with a number and then print it out. I think make a database based on a spreadsheet with numbers.
Open the database in the databrowser and drag the titel of the number in your form.

Maybe a person who knew writer better as me have an other solution.

I did now see it was in the writer forum and not in the database forum sorry.

Romke

Re: Sequential forms

Posted: Thu Jun 17, 2010 5:44 am
by RoryOF
A way to deal with this might be to Mail merge a number from a calc spreadsheet which contains a number from 0-99 in a column. The merge field in the Writer document would be preseeded with the hundreds/thousands digits before printing. So, to print the range (say) xy00-xy99, the mailmerge entry in the document would have the leading xy digits inserted, so the field would read xy<mergenumber>.

I don't use mailmerge so have no practical experience how to implement this.

With old-fashioned letterpress printing this was very simple, one just used a "numbering box" that changed the number on every impression of the platen.

Re: Sequential forms

Posted: Thu Jun 17, 2010 10:31 am
by Zizi64
My solution based on Document Info as storage device, and I used the Custom Field option as display device.
Controlled by Basic macros (API functions).

See the attached file:
Print_Numbered_Copies.odt
(15.51 KiB) Downloaded 170 times