I need more informations about your problem to help you.
Do you make an export with "Export Records.." or with "Save/Send Records as"?
There is a problem with blank cells if you use "Save/Send Records as".
To solve the problem you have to use "Export Records".
I hope this was helpful to you
We are testing filemaker to decide to buy it or not.
I am using Export Records.
This is what we do:
First we start filemaker and select 'Invoices' from the 'drop-down-list labeled with Layout:'
Then we choose File >> Export Records >> we pick 'Excel Workbooks', enter a 'File Name' and hit 'Save'
Then we hit 'Continue'
Then we pick 9 fields for our 'Field Export Order'
The option 'Apply current layout's data formatting to exported data' is not selected
Then we hit 'Export'
The blue cells are to be filled.
johnz, there are two kinds of exports when you have parent & child records:
A. from the parent. Typically this gives you the ONE parent column filled and all the children. This is OK, for some things, but does leave blank cells!!
B. from the child. This is what I believe you are doing when you go to related record. However, in your export, you must select parent columns/fields to also export to give you the values in every record.
parent::parent1 name, parent::parent1 id, child1 id, child 1 name, child1 qty, child 1 price, ...
as beverly said you have to export the child table, in your case the "Invoice Data".
Go to the table "Invoice Data", as example with "go to related record", sort the list by "Invoice ID" and then make the Export.
That shold do it.
beverly: good in theory, but that doesnt cut it
We found let's say related options:
- Menu View >> Go to Layout >> Desktop >> Invoice Details
- Sort >> Select related table 'Invoice Data' >> Sort order based on 'Invoice ID' >> Sort
All of this doesn't bring us closer to what we need.
@your remark 'go to the table Invoice Data': where do we do this?
try to make a button or a script with the step "Go to Related Record", set "Get related record from:" to "Invoice Data", then you should get the layouts with this table by "Show record using layout:". If you can't get a layout there, you have to create a new layout with "Invoice Data".
I hope this helps
here is an example using the starter solution "Invoices" from FMP14 (I created one customer, one invoice, and two products):
This is the export dialog from that form:
and the Excel that results (NOTE the blank cells!):
Now, if I go to the RELATED RECORDS (invoice items) and export:
I get this in the Excel (NO BLANK CELLS):
I believe this is what you need to do. Go to Related record (based on whatever relationship you have as your items) and then export from there. You can export as many invoices as you want, if they are in sort order, they will not have blank cells (from the child/item perspective).
p.s. you needed to post a screen shot of your export dialog to help solve this.
Yes, you need to go to related items, as ChrisS and I said. perhaps it was the lack of "button"? But on the "Invoices" starter solution, I had to go to the Print/Send Invoices layout (hidden from the layout menu). The "Print Invoice" button will take you to the layout, but will pause in Preview Mode. Rather than printing, you may wish to go to Browse mode, or simple choose File->Export Records from that layout.
This *may* only show you one invoice, in which case, you can:
1. navigate to this layout (with the button) and have a "found set" or more than one Invoice
2. go to Browse mode and find the invoices you wish to export.
Your advice in combination with the steps from beverly were awesome!