First, if this is going to be a trigger I'd just simplify it to:
If [Inventory::Amount_In_Stock ≤ Inventory::Reorder_Level]
Send Email[Send via Client; No dialog
It makes sense to me to add this as an "OnObjectSave" trigger to the "Amount In Stock" field. So that the test is run and email sent after the Amount In Stock field is finished being modified.
Thanks very much Mike.
How can I genarate a report to show all the stock the is below the reorder limit?
I would setup a new unstored calculation field, IE "Inventory::Reorder Status" with the calculation:
If (Amount_In_Stock ≤ Reorder_Level ; 1 ; 0 )
Then I would script something that does a find for where Inventory::Reorder Status = 1, and display those records on a report layout.
THanks very much
Hi Mike I am very new to this is there a manual I can buy to help me with understanding scripting?
Mike can you help me with this script.
There are a few places to go for filemaker training:
Go To Layout (report layout)
Perform Find (Reorder Status = 1)
Sort Records (however you want)
Print (or save records as PDF)
Go To Layout (original layout)
If this type of basic scripting is still confusing, it might benefit you to get training, or to hire a consultant to assist you through setting up your solution. A lot of consultants would probably be ok with working remotely with you so you can learn. Elance.com and ODesk.com are two good sources for small project hiring.
Thanks very much Mike