Exporting Records to Existing Spreadsheet
Is there a way to export my filemaker records to an ready-formatted excel document? I would like to export record data from my FM layout to a spreadsheet we use for comparisons. I've tried using the "Save to Excel" and "Export Records to Excel" scripts... They work, but require a lot of formatting to get the field data to display in a way that I would like.
I have several portals displaying related records on my layout. I would like to export all the related records to a particular order number onto a spreadsheet, without having all the fields just export to the first line and have 100+ columns...
I can elaborate more on my situation if needed... Thanks :)