Sorry, Work In Progress as stated is realy "In Production" in my db.
A description of your tables and relationships would help.
Being a noob as I am I don't have any relationships at this time. My table pic is attached...
When you say "sort by" do you really mean "find"?
Do you want a total ofsqft for all records where In Production is Yes?
If so, you can perform a find for all records with "yes" in the In production field and then a summary field can compute the total.
Yes, I meant "find".
Yes. I have this script to create the "yes" If (IsEmpty(Finish Date); "YES"; "")
That should work and I can divid that summary number of square feet in production by 150 which is what they are completing per day to give the owner a "Production Lead-Time" in number of days.
Can you help me create this?
You don't need the calculaiton you've specified.
Just enter find mode and type/select yes in the field and you can pull up a found set of all records with Yes in that field.
Is 150 a value that is simply entered in a field by the user? If so define a global number field for that purpose.
Then you can add a calculation field defined as
SummaryField / GlobalFIeld
First perform the find and then the calculation field will report the value you describe.
That's a simple Beginner level way to do this. there are ways to compute the same total using a relationship which then does not require performing a find each time.
And you might find this thread of examples of scripted finds useful: Scripted Find Examples
Most of the people accessing this data would be via FileMaker Go on the iPad or iPhone. I really want this "Current Lead-time" field to simply be in the template already calculated so they can just view it and let customers know. My vision was that they wouldn't have to actually perform the finds ect.
Yes to your question. The production manager would just go into the calculation and change it to say 175 or 200 if their efficiencies improve and then the lead-time would change accordingly.
Take a look at this thread on scripted finds: Scripted Find Examples
You should be able to script a find and the global field can be updated as needed by the production manager, but only directly on the host machine. If from a client, such as one of the ipads/iphones, any changes made will revert to the original value when you close the database file and the changes made won't be visible to the other users.
The production manager can load a non-global field and then a script that runs each time the file is opened can copy the value into the global field.
and you can also set up a relationship that matches to all records with "yes" in the field to compute the same result. This elminates the need for a scripted find.
That should do it. Thanks a bunch man!