John Chamberlain

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.

Of couse! As I said I have forgotten a lot, even basic stuff like this. Thanks so much

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.

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

Works perfectly...Thanks!

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?

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?

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

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.?

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

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.

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.

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?

Without stringing this out, your suggestion of using a global field solved my problem...Thanks!

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