Need a few things done to filemaker project.
Need a Value eg Labour Rate, to be able to be used in multiple tables to calculate a Price. Want it so that it will automatically update the value if i update the value at any stage.
Also need a Value to be set depending on three check boxes sample below
Check box 1 Front
Check box 2 Side
Checkbox 3 Rear
if checkbox 1 select then baseprice value is 25
if only 2 is select then baseprice value is 25
if 1 + 2 are selected then baseprice value is 30
If 1+2+3 is selected then baseprice value is35
If 2+3 then baseprice value is30
If only 3 then baseprice value is 25
To Further Explain Requirements.
Base Price Calculator Works out the Base Price as per below
Area = front, side, rear, verge.
If one are then $25
If two Areas then $30
If Three or more Areas then $35
And if Remove Clippings is selected then Add an additional $5 to Base Price
This is Automatic from the properties layout using the checkboxes on the layout.
Package Prices Not Stored causing price varies between devices. - This is due to none stored Values - To Correct need to be able to Select the default Lawn Spray Chemical and have it’s value set for the calculations ( in the chemical Spray table need dropdown box that selects the correct chemical cost price , these are from the Herbicide Table.)
Labour Rate Needs to be Global so is the same on every table in every field and also every Device, Can be changed at Pricing Table.
^ is the Same for Centspermeter2, Markup Rate, Poisonlicencefees.
This is what needs to be Fixed.
Please update bid as will not adjust projects after you have made an offer. I will chat before awarding.