I have a layout that shows 36/93 records displayed as 3 summary records as shown in the picture below. Now I want to copy just these 3 records to another table. I will appreciate any solution as how to solve this problem. Thanks
Thank you for your post!
This might be possible by using SetVariable, GoToLayout, SetField, and a Loop.
Also, I am going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more advice!
Summary fields (as sorted) can be exported. My 'easiest' recommendation is to export (using summarize) and then import back into another table. You will get only those 3 records. Other methods are doable, but not as easy.
I tried the export import. It worked but it is not ideal for my situation. Is there any other work around in the fom of a script?
ExecuteSQL() - the function - may help here. But even with that, there is no 'native' way to push the results into new records without a few hoops. See this thread for ideas:
SQL Insert statement on a FM table (from filemaker)
GetSummary() built in function is a calculation requiring data to be sorted (it will do this for you) and may take time. So it is possible to use calculations to get the data and push to the other table, but as in the above linked thread, you still have to script the push. Export and Import are probably going to be the fasted!
As TSPigeon suggested, you can loop the found set and put the values into variables, these can then be pushed into new records (wherever needed).
Are you dealing with variable data (columns/fields) and need something other than Export/Import? or any other details that may require scripting?
You tried the simplest and most straightforward method.
You didn't like it.
What are you looking for?
There are lots of ways to get things done in FileMaker.
I am doing a school database solution. The numeric values you see are averages for the first assessment. Now I want to push those values into a new table so I can run a rank script to get results like 1st, 2nd and 3rd. The script works best when the records are only those present in the table. The export import is fastest and sure but it will be difficult to execute by those who will be using my solution
You can SCRIPT the export and import (automated) so that your users don't know it is happening. The "path" to the exported file may be the key. Search for FilePath
Creating file paths
this may be the best "location" for the file:
Thanks for you help Beverly
I imported the found set to my new table with the Get summary calculation to pull the averages in the old table. I did a found and delete duplicates to remain with unique records in the new table.
Retrieving data ...