Hopefully this is a simple issue that I am just missing.
I have a database I am creating in Filemaker Pro 8.5 Advanced. Users enter data about a product that has to be ground even every so often. At one point, the product cannot be ground any further.
I want Filemaker Pro to popup with a dialog box when the product is below a specified diameter. I have it working to where I have to run the script manually, it exports data to excel file and emails properly. The only thing not working is getting the script to run on its own when the first if statement is true.
This is my current script:
If [Mill Roll Tracking DB::Roll Face Diameter After Grind <= Mill Roll Tracking DB::Roll Reorder Diameter
Show Custom Dialog ["ROLL REORDER"; "The current roll cannot be ground again. Please hit SEND EMAIL so that a new roll can be ordered..."]
If [ Get(LastMessageChoice) = 1]
Go to Layout ["Mill Roll Tracking DB"]
Save Records as Excel [Restore;"Roll Reorder.xls"; Current record]
Send Mail [ No dialog; To: "email@example.com" CC: " firstname.lastname@example.org"; Subject: "Roll Reorder; Message: "Please open Excel file below to see which roll needs to be reordered.";
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…