June 15, 200916 yr Newbies Hi, I would like to say that I only have 2 days playing around with FM, and this is my situation. I want to know if there is a way that i can type in a field a formula like this =(8*2)+2+2.5+10 and get the result either in the same field or another field to be used in a "Qty total field" for a Square Feet count. Te reason for this is that we walk the site with a notebook taking notes of how many SqFt the workers did on a week to generate their payroll, I have this table setup in Excel with VLOOKUP for Price per Unit and everything, thanks to this forum i already have tat part of my payroll working (using an invoice based solution), but the part that I want to avoid is taking the notebook doing all the math in a calculator and then type it in File Maker, i would prefer to type directly in file maker and get a result, I know file maker is not a Spreadsheet solution but any guidance would be helpful. Thanks in advance for any tips or suggestions
Create an account or sign in to comment