dannyg

Hi we have an in-house solution running our contracting business and I am too busy to work on a commission module. We are currently running FMP 13. We have a "Jobs" db where each record is part of a job. Some jobs have one record, some jobs have multiple records associated (change orders). We need to calculate commission based on the total gross profit of the entire job and provide monthly reports. I have been hung up on the jobs with multiple records and getting the correct calculation. Need to calculate based on the total job profit margin not the profit margins on each portion (record) of the job. I can provide more details if you are interested. Please private message for more information. Thanks in advance. Dan

We have a "Jobs" db that is keyed off of a "job number" field. There can be multiple records for one job if there are chage orders/additions to the job. Each record includes a "labor hours" field. I am looking to calculate how many field hours we have left for all the open jobs. I already have a report that does the subtotal of hours available, hours used, and hours remaining when sorted by "job number" and that works great. I am trying to create a calculation to find the total of hours remaining with the twist that i want to exclude any jobs that have a sub-total of "hours remaining" that is negative. I know I could do a simple calculation of available hours - hours used but it won't give me a true result because there may be a sub totaled job where the hours used is over the hours available ( job went badly) which would skew my actual backlog or hours to be expended. I have a dashboard set up and would like to drop this calculation on the dashboard to keep track of our current labor hour backlog. Is there a way to have a calculation or script or relation ship to sort first then omit negative records so I can calculate the hours remaining. I have tried a relationship to show only open jobs and that works but I can't get my head around how to sub sort them then calculate. Any help appreciated.

Yes by date. what does TO stand for?

I have a situation where I find many records and they are grouped by salesperson name. I want to copy information from the first record only of each salesperson to another table. I have set up a script to work through the fields and loop until all the records are processed but I can not figure out how to skip records in a script. I tried setting a variable based on the salesperson name and then compare that variable but the syntax of how to manage this is not connecting in my brain. Any pushes in the right direction are appreciated.

I have a Purchase Order table, each item ordered is a separate record. A unique PO number is used so some POs may have one item, some may have many. I have one search layout that includes PO Number, Vendor, Item, etc. When I search by a PO number it will return one or many records but since I am only searching in this instance by one PO number I would like the script to display the combined PO as a whole(Which I can do and have a script set up to do) If I search by Vendor it returns one or many records but I do not want those combined since they would be from multiple PO's so I want those to show up as a list(Again I have this working) My question is, Is there a way with a script to determine what field was used for the search and then based on that execute the appropriate script for the display I want.

Hi, I have a script to find records in a database. The layout for the find contains several fields. I would like the results to display differently based on which field was entered in the find. For instance if I search by PO number I would want certain script steps, if I search by a product description it would want different script steps. I have already set it up so that based on how many records it returns it can go to a different layout, I am now trying to figure out script steps that would capture what field was entered. Would I use several instances of IsEmpty to eliminate what fields were not entered? Dan

That did it. Thank you. I was trying to make more of it than I had to. Dan

Hi, I have a field called status which is set up as a radio button with the options Current, Pending, and Parts. If I have 50 total records for example, I would like to know how many there are of each Current, Pending, and Parts. I have tried the Count function but it is just not coming to me. Any help is welcome Thanks, Dan

I had a similar problem with a new install and a RAID drive. I searched the net and found a post that said to re-start the server, and delete and re-input the schedules. It worked for me. Dan

Still not sure what caused it, but since the db was fairly small and it was originally a FM5 db using CDML and web companion, I decided to start from scratch with a new FM8 db and just put in a couple of fields to test and it works ok. If I ever figure it out I will post the answer here. Thanks for your help, and the reply on the other board too. Dan

Garry, Yes I have used the names from mydb. Dan

I am testing with the example provided in the fx.php download. Test scenario works ok. Next I change to mydb, mylayout, username, password, and fields. Nothing displays in the web page. I see alternating color rows that match the number of results but no data. When I set debug to 'true' and click on the FM link the data shows up. It must be something simple I am missing. All help greatly appreciated. Dan Running FMSA 8 on OSX 10.3.9 server

This may not be relevant anymore but I did this in Ver 5.5. As I remember you just have to pass the variables through. I know both FM and PayPal have evolved since the time I did this, but I just wanted to pass along my experience. Dan

I have a customer db that has a status field in it. Currently a drop down value list of Warranty, Maintenance, and T&M. I also have a Warranty/Maintenance expiriation date field. I would like to have the status field automatically update based on the current date with the default value being T&M once the initial value has been entered via drop down I can do the basic calculation with the Case statement but is there a way to also allow the drop down so that when the customer is first entered you use the status field drop down and then at some time in the future base on the warranty expiraton date the field changes to T&M. Or is there a way to have a script run once a week to update this field. Thanks in advance Dan

Vaughan, Thank you very much, it saved me quite a few headaches . I had the same issue with the date & time. If you go to File Options/Text, there is a place to force the file to use System Settings for Date and Time. Works like a champ. Dan