Jump to content

John Chamberlain

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About John Chamberlain

  • Rank
  • Birthday 01/15/1930

Profile Information

  • Gender
  • Location
    L. A.

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

3,216 profile views
  1. As I get older (and believe me I am pretty old) I find that I have lost track of things that I thought I once knew how to do. This is one such case. I need a report that shows a ZIP code and the total number of records that share that ZIP. How do I do that?
  2. I decided to install the Mac Mojave OS (10.14)...BIG mistake! I found out too late that my FMP 14 files would no longer work. I reinstalled Mac OS 10.13.6, only to find that my FMP application files were no longer in my Applications folder. I dug out my FMP 11 Advanced, and my FMP 14 Advanced updater and reinstalled them. This seemed to go smoothly but, when I tried to open any of my FMP 14 files, I was met with two error messages as follows: "The document “11/14 MASTER copy.fmp.12 could not be opened. Filemaker Pro Advanced cannot open files in the “Filemaker Pro Advanced.app document” format." and "This application has been installed incorrectly or modified by another program. Please run the installer to get a fresh copy of the application after determining the cause." I have twice reinstalled FMP 11 Advanced, followed by FMP 14 Advanced updater, and FMP 14.0.6 updater... all to no avail. I find that I can open FMP 14, and then open my files from within the app, but this is inconvenient, and I am afraid that I may run into trouble sending files to my customer with a possible problem like this. Can anyone tell me what to do now?
  3. I have a FMP file that contains records that show eight metrics per entry (date, ethnicity, number of adults, children, etc.). This is data from a Food Bank, tracking types of food distributed, distribution dates, and family statistics for each distribution. I need to construct a yearly report that presents this data in Month by Month lines and sliced in several ways: Number of adults, children and seniors who did, or did not, make a scheduled pickup Breakout of the same data by Ethnicity Value of each pickup Etc. This could result in 10 data points times 12 months or 120 fields needed to make up the report (daunting for me at least). I know I can export the data into Excel and then manipulate it into the desired formats, but I need to automate it, and I can’t figure out how to do it in FMP. The attached file shows the data I am working with. (User name is John, with no password). Also attached is an Excel page that shows how they used to report this data (note that they simply used rough estimates and presented it as factual numbers with no hard data backup. Any help will be greatly appreciated. SAMPLE.fmp12.zip STATISTICS.xlsx.zip
  4. I have laid out a report that will display results on a month by month basis. I have the calculations done, and the report looks good. But I have to input a set of dates (1/1/...1/31, then 2/1...2/29, etc.) to get the report to display the full report. What function or script steps can I use to increment the search, and have a report showing a line of results for January, then February, etc.?
  5. A few years ago I created an FMP 11 app for my Wife. She is the calendar person for her Children's Hospital Auxiliary Thrift Shop. The app selects a monthly layout, which she fill in, than sends it to a print shop who provides her with copies to be distributed to members pf the Auxiliary. Yesterday, for no apparent reason, the app began printing multiple pages for what should be a single page document. Since my Mac has FMP 14, I had to convert the file is that I could attempt to fix the problem. No such luck. Please open at the attached file then click on the GO button. This will take you to the problem page You should see a single page. Checking in layout mode, you can see that all elements are inside the page boundaries. Back in Browse, issue a print command and save in PDF mode, the view it in Preview. You will see that, if the file had been sent to the printer, it would have printed six pages (three with the full calendar, and three with only the header. What could be causing this? SBACH NEW CALENDAR fp11.fmp12.zip
  6. How do you know you have duplicates? Why do you have duplicates? Records are created by inexperienced users, who sometimes forget and enter records twice. Moreover, records are created by placing checkmarks on a form (sometimes as many as 50 on a single form. The opening script looks at all records and deletes those that are double entered. Showing a data entry person that duplicates have been deleted makes them aware of the possibility that they may be doing something wrong. You capture the found count before and after this routine and show user the diff. This will work for me...thanks. when you add records, don't you know how many you're adding? The script already displays a message stating that a batch of records has been added (from the form mentioned above). What I would like to show the data entry person is how many records were added. This might catch her attention if the number was too low or too high. Thanks for your help.
  7. The file runs an opening script that scans a list of about 10,00 records and looks for duplicate records, then deletes them. There is a second script that is called from a script that is activated by a button push; this script adds several records to a different list. I wanted to know if there was a way to insert a step at the end of each of these scripts that would show how many records were deleted or added. I hesitate to send a copy of my file, as it is in rough shape, and needs much cleanup.
  8. I have a couple of scripts; one deletes redundant records, and the other adds new records under certain cirumstances. Is there a scripting way to show how many records were added (or deleted), when the script finishes?
  9. Without stringing this out, your suggestion of using a global field solved my problem...Thanks!
  10. I have a layout (CLIENT DATA) that has a fixed field (CLIENT STATUS). On a different layout (NEW SEARCH) there is a calculated field (DQ DATE RANGE) that is a based on an entry of a starting date (e.g. entry of June 7th generates a text field of 3/30…6/7). A third layout (LINE BY LINE DATA) contains a large number of records that are related to the first layout by an ID number. This layout has fields that show data for a transaction date, a Client Status field, and other fields related to the transaction, I am trying to construct a script that performs a find in the LINE BY LINE layout. This requires placing the layout in find mode, placing the date range (from NEW SEARCH layout) in the date field, and placing the Client Status (from the CLIENT DATA layout) in the Status field. I have tried everything I can think of, but I cannot get it to work. I seemed to be simple to use the following: Enter Find mode Set Field (LINE BY LINE::CLIENT STATUS::CLIENT DATA;;CLIENT STATUS Set Field (LINE BY LINE::PICKUP DATE; NEW SEARCH::DQ DATE RANGE Perform Find I tried a few other things (copy & paste. etc.) but nothing seems to work. What am I missing here? The attached file uses a sign on name of JC, with no password. TIA TEST_FILE.fmp12
  11. First, let me thank you for. I truly do appreciate your help. With regard to the file you sent yesterday, I must say that your script is way beyond my capacity to understand. Further, I feel that I somehow may have made this thing much more complicated that necessary. I note that your latest script displays messages that have the correct percentages, even though the percentages displayed in the sub-summary section, once the script has run, are not the same and indeed seem to be independent of the numbers in the records being evaluated (30.95% in both cases even though the number of pickups and the number of dates are not the same and 30.95% is the result of all of the records in both names). If it will help, I am attaching a copy of the complete FMP file (Name: John, P/W null), and a description of the things the file is supposed to do. The program is designed primarily to contain the names of persons who are recipients of food packages (Boxes and /or Bags of locally donated foodstuffs). The clients are classified as WEEKLY, EMERGENCY, HOME DELIVERY or WITHDRAWN. The problem I am trying to solve relates only to those clients who are classified as WEEKLY. Distributions are made to the WEEKLY clients on a singled day assignment (Monday through Saturday). Distribution Sheets are generated by going to the DAILY SHEET PREP page (Command 3), then choosing a date. Clicking on the PRINT A DAILY GRID SHEET) invokes a script that find the proper records, goes to the LINE BY LINE screen, and generates a percentage of pickups made figure for each person The object was to find a percentage of those who had not made their scheduled pickups. Any client who fell below the 50% line would then be removed from their Weekly distribution spot (classification changed from Weekly to Withdrawn). The criteria was based on there percentage generated by the number of pickups made over 9 (the number of pickup days between the selected DAILY GRID SHEET date and the previous 9 weeks). Those with a 55.5% (5 out of 9) rating would be warned if they picked up, while those who passed below that (4 out of 9) would be placed in the Withdrawn category. The script invoked by the PRINT A DAILY GRID SHEET script works, in that the proper records are selected, and the daily sheets are printed on time. The problem is in evaluating the pickup percentage. What I need here is a number representing the number of pickups divided by the number total entries for a person. This number will be used to insert a warning on the DAILY GRID SHEET whenever that person is in danger of falling below a 50% pickup mark. The message would also have to be adjusted so that new persons entering the program would not get a warning until they had been in the system for three or more weeks, None of this figures in the solution. Just having the number of pickup opportunities and the number of actual pickups is what I really need. Is it possible that FMP can generate the sub-summary numbers, but cannot allow the results to be used in an individual equation? HOY FIle 6-5 Copy.fmp12.zip
  12. Thanks. I tried this and while the sub-summary values are correct the GetSummary values are for the entire number of records. I have attached the modified file to show this. I know I am missing something here but my addled brain can't seem to figure this out. I truly am sad to be so stupid...this is what comes from being self-taught and 88 years old to boot. Again, any help will be greatly appreciated. TEST.fmp12.zip
  13. What I should have said is that there would always be 5 to 9 records to be evaluated. The date range is based on a calculation of the current date selected minus 63 days. Thus there could be as many as 9 weeks or as few as 5 to be evaluated. However, there could also be a record count of less than 5, Once I had the equation working, I had planned on setting a null field for any total of records of 1 to 4. Please accept my apology.
  14. OK. displaying my ignorance here... I have always thought that summary fields could not be used in equations. The whole object of my effort here is to establish a percentage of pickups mad for each individual in the Client Data table. So, in the sample file here the ultimate result for Jackie Batch would be 1 (the number of pickups missed) over 5 (the number of pickup dates in the sample (20%); while the result for Irma Cortez would be 4 over 5 (80%). I tried a calculation using the summary field, but the result is confusing (tied placing in in both the detail line and the summary line). Canou tell me how to get where I need to be? I have further stripped out the extraneous fields, and a copy of the file is attached. Again, Name is John, Password is null. TEST.fmp12.zip
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.