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,290 profile views
  1. Just getting back to this and I am having difficulty. To clarify, I need a script that will place an Asterisk "*" in a field (if the filed is empty), or will change the field to empty (if is an Asterisk). II tried your suggestion, but just can't seem to get it to work. Thanks again for your interest.
  2. Of couse! As I said I have forgotten a lot, even basic stuff like this. Thanks so much
  3. I have multiple fields that need to be either empty or have a "Yes" entered. When the field is empty the script should enter the "Yes"...if the filed has "Yes" entered (isvalid) it should delete the field contents.
  4. I have been away from FMP for quite awhile, and have forgotten a LOT. I need a script (using a script trigger) that upon field entry will enter an 1 if the field is empty, or a blank if the field is valid. Thanks in advance
  5. 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?
  6. 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 docume
  7. 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 ne
  8. 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.?
  9. 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
  10. 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
  11. 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.
  12. 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?
  13. Without stringing this out, your suggestion of using a global field solved my problem...Thanks!
  14. 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 LI
  • Create New...

Important Information

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