Exporting to Excel

[DrewFM]

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 List....

I want to add the contents of Title to Title List.

Then with a button I want to export to excel and fill Virtual List with my Title contents.

I uploaded photos so you can see what I am working with...

any help is greatly appreciated... Thanks !

[jwilling]

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"

Then with a button I want to export to excel and fill Virtual List with my Title contents.

The reason I ask is because it's not clear (to me at least) what the end result should be. Also, Virtual List has strong idiomatic meaning in the FileMaker world and it's not 100% clear here whether it's being used "non-traditionally" in your system.

I apologize if you felt you were being very clear and I'm just not understanding.

[DrewFM]

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.

[DrewFM]

I want to export the data from filemaker to excel in a script with a button.

I posted my updated script.

The last photo.

[jwilling]

Thanks @DrewFM for the clarification.

You can likely accomplish this without VirtualList. Try:

1. Export Records script step.
2. 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.
   
   
3. Optionally define the export path and the worksheet name
   
   
   
   
   

Did you already try something like that and encounter some kind of roadblock?

[DrewFM]

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.

[jwilling]

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)

[steverichter]

@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?

[DrewFM]

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

[DrewFM]

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

[DrewFM]

Here is an example of the Excel sheet.

[DrewFM]

[DrewFM]

Solved with a coworker today !

[DrewFM]

Thank you everybody !