[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


filemaker pro 13 need to copy report results to a permanent table

Posted on 2014-08-30
Medium Priority
Last Modified: 2014-09-16
I Have a layout that runs sub-totals (using a summry field) of a number of account classes items

Bookeeping 100.00
Office 550.00
supplies 312.00

with the numeric being the summary field of the accounting_class

I want to use them in a spreadsheet and think I need to store them in a new Permanent table

so I made a table called - summaries with record, account and total

Not sure how to script this to take the class-figures from the first report (layout) and loop them into new records in the second table - I see google stuff on exporting - importing etc but it seems like there should be a simple scripting method to do this - need the summary field results written to a permanent record in a single table

Any help, simple examples etc? Filemaker pro adv 13
Question by:drdocb

Accepted Solution

Lieven Embrechts earned 1500 total points
ID: 40295518
no need to complicate matters.
exporting really is the easiest, quickest, most standard way to do it :
if you first run the report manually and export manually, filemaker will automatically use these settings in the new export script step.
you can directly export to filemaker and select the correct destination table and fields so it probably will be 1 scriptstep.

Author Closing Comment

ID: 40326786
Thanks - sorry for the delay - we used this methodology with summary files and got what we needed. Lost track of time and would like to accept this solution

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question