7 posts in this topic
I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:
Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded:
Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.
I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores). Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records The fields in the 4 Tables have different names and contain similar “core” content. Tables are added to each month with additional records (imported into FM 14 Pro Advanced from Excel). Unfortunately the same Products are named slightly differently in each of the 4 tables. Each store / table has a (text) Product-ID but (for the same product) it is different per store. I do want to rectify this “naming problem” (perhaps in a Table #5?) so I can produce a report showing sales for each of the 1000 products across all 4 stores (grouped by date etc.) I’m not sure how to structure/carry-out this in Filemaker most effectively. Any ideas? Ultimately, when the data is clean, I want to upload ALL the records (e.g. 100,000 records) in one export into one Excel spreadsheet so I can run a Pivot Table (Cross-Tab) report. Do I need to combine the 4 Tables into 1 Master Table before doing an Export on the Master Table? If so, how would I do this? Thanks for any ideas about this?
Is there any reason that my chart will only display up to a certain number of records? I'm trying to plot GPS tracks and I have 21,000 records that represent 8 surveys. When plotting only found sets by survey, the chart still seems to only display up to a certain number of records. When I export the records into Excel and plot, all records get plotted without a problem. I'm using Filemaker Pro 13 Advanced on a Windows machine.
I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK.
However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours.
I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout?
Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours
I recently imported records from an excel sheet into my filemaker solution. I just noticed that the dates in the excel sheet were entered in this format 1996-04-19
and as a result, all my date calculations are not working. For example, the Age and other functions. Manually changing the date to 4-19-1996 resolves it.
Is there a way i can do this without manually going to each record? because there are a lot of records to deal with..
Thanks for your anticipated response