This topic is 2601 days old. Please don't post here. Open a new topic instead.
Greets, and a happy, holiday season to all.
This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command:
"cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" )
...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, " Command is unavailable (for example, wrong operating system or mode)".
So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix?
I would kindly appreciate your help!
I need a report for my employees uniforms. I have the employee table where I have these variables:
employeCat, shirt size, shirt amount , pants size, pants amount, shoe size, shoe amount (employeCat can be administrative, designer, reception)
So, I made 3 summary fields to add up the amounts and thus obtain the totals of each item.
Soo, I'm having problems when creating the report, can't get it to work.
For example, I need to see the shirt size L and see how much shirts I need for that size and the amount for the category the employee is in.
I. E Shirt size L, 11 required for category Administrative
Pants size XL, 7 required for category Designer
Same for shoes....
And of course eould also need a grand total at the bottom
Thanks for your help!
I have a set of order forms, in which each order form has X amounts of orders from X amounts of clients. I can summarize with a Summary field the number of orders each client has ordered on one order form (weekly order form) and now I want to make a report that tells me the breakdown from week to week, and quarter to quarter. I can get the report to break apart the weeks by quarter, and it displays each week's correct total, but it won't do a total sum of each quarter, let alone for the entire database.
I've tried summarizing the weekly summary field to get the quarterly amount, either in a new field, or on a trailing sub-summary part. The new field just copies the number from the weekly summary field from the record that is active, and the other way just shows the last above record. Wanna pull my hair out!
I have a feeling that the problem is in how I set up the original weekly summary field, but I just can't see how, or how to make it work.
Good morning everyone
I'm creating a database where I have to print a report. I created the whole structure but I'm at a block. The report is on several pages and I do not find the solution to be able to have at the bottom of each page the subtotal. The section is inserted, in fact at the end of the list I find the result. But if the list is longer than a page, I do not have the data of the subtotal but I find it on the second page at the end of the list. I tried to change the field settings by setting total progressive in the options and inserting it in the footer section but I always find the total integer, while if I look at the data in the table format the field has progressive values Could someone help me on this? I have been reading manuals and internet for two days but I do not find the solution (hoping there is) Thank you all
Who Viewed the Topic