Second post here ! Lost my info to the old account... I am new to Filemaker, and have a question regarding exporting. I have a database centered around books. Title, Authors, Descriptions etc... I have a layout named Title Detail, with a Title Table. I have another Layout/Table labeled Virtual…

Hi, I'm sure you'll get some good help here. Can we take a step back and can you describe, in the most non-programmy/tabley/fieldy terms what you're trying to accomplish. For example, one end goal might be something like "I'd like to create a PDF that lists all the books that came out in the year x" …

I want to export the data from filemaker to excel in a script with a button. I posted my updated script. The last photo.

Thanks @DrewFM for the clarification. You can likely accomplish this without VirtualList. Try: Export Records script step. Select the fields you want to export selected in the "Specify Export Order" dialog, and drag them into the order you want. This can also include fields from related tables. […

I don't think this solution would work for my case. I have tried what you mentioned, and it doesn't accomplish what I am trying to do.

I think we'll need more information about why that doesn't work since that's the standard way of doing it. Is it because each title can have multiple contributors? If so can you make an example of your desired excel output? (make it in excel)

@DrewFM From what you describe, a single table and layout will be sufficient. Can you elaborate on why a second table and layout is required?

Exactly, a title can have multiple contributors, along with descriptions, & other things. I’m trying to make the export dynamic, so if I have more contributors the export will handle that.. Hope that makes sense

I will do this later today, thank you guys for your time

[Screen Shot 2022-01-07 at 10.48.37 AM] Here is an example of the Excel sheet.

Exporting to Excel

Questions

DrewFM January 5, 2022, 9:25pm 3

I understand, I am still learning, so I figured that would happen.

What I want to do is create records for books.
I want to have the author, description of the book, Title of the book, etc

I want to take those and export them into an Excel sheet.

Topic		Replies	Views
Is there a way to generate reports in an Excel sheet (specific format)? community	11	289	November 2, 2023
MBS @ FMTraining.TV - Exporting to Excel from FileMaker using MBS MBS Plugins excel-export , excel	0	41	December 20, 2024
MBS @ FMTraining.TV - Exporting FileMaker Settings into Excel Files using the MonkeyBread Plug-in with Christian Schmitz MBS Plugins import , plugin , excel-export , excel , mbs , export	0	83	June 8, 2024
One to Many Excel Export Questions excel-export	5	130	September 1, 2025
Assistance Needed to Recreate a Specific Excel Format mbs	10	367	October 29, 2024

Exporting to Excel

Related topics