I am trying to track some payroll information
I have used drop down menus: (supervisor, driver, parts employee, Crew Member 4, Crew member 5)
that, when selected, automatically input each employees wages (martha mae wages, marcia troyer wages etc)
by using formula of calculating the "Clean Time" field * whatever I input for each employee hourly rate.
For example, we input 1.25 in the "Clean Time" field, and drop down select "Marcia Troyer" under Supervisor field, the number 13.75 automatically shows up in the "Marcia Troyer Wages Field (time 1.25 times her hourly rate of $11/hr = $13.75).
I need to choose at least one name from each of these fields (supervisor, driver, parts employee, Crew Member 4, Crew member 5), and then in the "Total Wages" field add up the sum of each field for this particular jobs TOTAL WAGES
Please help.... IF POSSIBLE, I'd rather use the drop and drag free-flow scripting? Please help, and thank you