Hi, good afternoon.
How to print in a printer BROTHER QL-800, a invoice as large as needed?
It means if I sell 2 items, or if I sell 40 items, how to use space needed?
Click the button with the printer icon. It uses a new layout set up for printing purposes and illustrates what several of us have recommended.
Most receipt printers stop printing after the last dot.
Therefore all you have to do is build your layout from the line items table, add a header for the top, and most importantly, use a trailing grand summary instead of a footer for the bottom.
What is confused tome, is how to use the sliding tool.
Sliding is a setting for the objects on the layout: Removing blank spaces in printouts
What do you need to sort out on that? Can you post a screen shot of your layout (Layout Mode) so we may help you better?
(click the Use advanced editor on the reply box to attach pdfs, or click the "Insert Image" icon to post jpg/png inline)
Beverly, here is a small folder with contains 3 files
In the first invoice there is a larga quantity of items,
while in the second invoice only 4
What i Want to do is reproduce the PRINTING only AS NEEDED
Like a invoice of McDonals, if you buy one muffin, the invoice is small,
but if you buy too many items, the invoice is large as needed
A typical invoicing system has at least two tables, often three:
Invoice---<Lineitems>-----Products/Services (---< denote a "one to many" relationship)
And for data entry, a portal to line items is often used to list the items sold for a given invoice (receipt).
But for printing, if you pull up a found set of the line items records for a given invoice on a layout based on LineItems instead of Invoices, you can set up a "list view" receipt where the fields from Invoice are included in either a header, footer, grand summary or some combination of them. The individual items would be fields in the body from lineItems and possibly products.
This then becomes a layout that can be as long or as short as needed.
A List View of records is most often where we apply the sliding. And then only if the Height of the field in the body part can a varying number of lines.
An "invoice with line items" is typically a related set of records and the printing is done from the context of (the layout based on) the items.
So if you are in a Layout that is Form View and show a portal of these items, trying to print that to 'slide nicely', you will run into issues.
Any relationship you have on an invoice to show a portal of items is reciprocal. So you can also see the "parent invoice fields" from a list view of just the found items for that invoice. Use the header, footer, subsummary(-ies), etc. to supply the parent or other fields on the 'child layout'.
Can you supply more information on what you are using to create your Invoices? Again some screen shots might help. Or check how some of the starter solutions do this. There is a "Invoices" sample that you might study. The layout "Print/Send invoices", for example doesn't use "sliding" but does use the items ("Invoice Data" layout/context) to print the invoices.
Carlos E. Rodas G
Nuevas Tecnologías en Construcción, S.A.
18 AV. "A", 20-78 ZONA 10 (01010)
Pho = 502 - 2366-9615 and 16
Fax = 502 - 2367-3429
e-mail = email@example.com
Thank you! So you have a file "minipli" with a table "minipli" and a layout "minipli"
Your relationship graph is great here!
Factura::facturaNo = minipli::FacturaNo
minipli::ProductID = miniInventoraio::ProductID
I see that you have separate FILES/databases for each of these, when you could have put all tables into one file/database. But we'll address that later.
So, in this file/database, you need a layout and have the correct fields showing (enclosed "receipt_layout.jpg":
The fields in the header are from Factura, along with the labels for the columns. You can adjust as needed to make the "receipt". It will print as tall as there are records. So find a particular Factura::FacturaNo and only those items will print.
This is very basic, but perhaps gets you going? I really advise that you check out the starter sample file for more ideas.
I don't know id Filemaker has the future to reproduce labels on a label printer as BROTHER QL-800
Yesterday I went to supermarket, and make 2 purchases. In first one I bought several products, in second I bought just one product.
The invoice for many products was printed including all products and automatically the printer cut the dirs one when finish to show all products purchased, and then the second one, cuts when finish the just one product purchased.
The attached image show what we would like to produce in filemaker, Is this possible? and how to do it?
Did you look at the copy of your file that I attached to my last reply?
It demonstrates a simple way to do exactly what you request.
(If you are reading this from email or the forum "in box" you won't see the download link for the attached file. If you are click the link at the head of this discussion that takes you to the main part of the forum and you'll then be able to find and click that link.)
Sorry Phil, but i don't find it, can you resend it to me?
Script from Phil is working good. It shows only real;ated record, marvelous.
But how to print and cut invoice as large as needed?
It's there. If I resend it, it will be in the same place as the first time so I don't think that will help.
Here's a screen shot of my reply with the links:
To repeat from what I said previously. These links are not visible if you are using an email program or if you are using the forum "in box" to read these replies. You need to click the link at the top of the discussion thread to open the discussion in the main section of the forum. Then you will see these links.
I only modified two of the three files in your original zip so you can combine them with your copy of the third file.
PS. there is also no real reason to put each table in its own file.
Retrieving data ...