BuildPro
Qrew Captain
Joined 7 years ago
User Profile
User Widgets
Contributions
FORMULA ASSISTANCE NEEDED
This is my goal...getting error message tho. Have tried several other ways, but can't get it to work...thanks for your help. If( [Task - USE DEFAULT UNIT COUNT]=true,[Task - Default Unit Count], [Task]="CAULK HVAC VENTS", [Task - Default Unit Count], [Task]="HANG",[FIELD BOARD COUNT.TO PAY], [Task]="Drywall.Item",[Take/Off Calc - NON-STRUCTURAL ITEM COUNT], [Task]="SCRAP",[Job - Maximum FIELD BOARD COUNT.TO PAY], [Task]="FINISH" and [Job - Project - GARAGE.FINISH-TAPE ONLY]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-13), [Job - Maximum FIELD BOARD COUNT.TO PAY], ****GETTING ERROR MESSAGE-expecting boolean, but found number***** [Task]="SAND" and [Job - Project - GARAGE.NO SAND]=true, ([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], [Task]="PRIME P/U" and [Job - Project - GARAGE.NO PRIME PT/UP]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], [Task]="PRIME", [Job Specific Take/Off - Take/Off - Total CEILING CALC HSF], [Task]="2nd COAT",[Job - Maximum Take/Off - BASE HOUSE.CALCULATED HSF], [Task]="FINAL T/U",[Job - Total Take/Off Calc - CEILING CALC HSF], [Task - Task Phase]="Paint.Interior.Item", [Take/Off Calc - NON-STRUCTURAL ITEM COUNT], [Task - Task Phase]="Paint.Exterior.Item", [Take/Off Calc - NON-STRUCTURAL ITEM COUNT])Formula Assistance
Can't get this to work: [Job - Project - GARAGE.NO SAND]=true and [Task]="SAND",([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], [Job - Project - GARAGE.NO PRIME PT/UP]=true and [Task]="PRIME P/U",([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], thank youDuplicate Record & Add new/different data PIPELINE
parent table - TAKE/OFFs child table - TAKE/OFF CALCULATIONS Take/Offs create record in Take/Off Calculations using a pipeline Take/Offs FIELD [PLAN OR OPTION NAME] contains MASTER is the only field "pipelined" into the TAKE/OFF CALCULATIONS table Now, I need a PIPELINE to add 5 additional records duplicating same [PLAN OR OPTION NAME]......New records will then contain selections from multiple choice field [CALCULATION TYPE] In summary, starts with this record: TEST.PLAN.MASTER - no data in CALCULATION TYPE field Need: TEST.PLAN.MASTER with selection from Calculation Type field - WALLS.INTERIOR and TEST.PLAN.MASTER with selection from Calculation Type field - CEILING.INTERIOR and TEST.PLAN.MASTER with selection from Calculation Type field - WALLS EXTERIOR and ETC thank youRelationship - Forms
Hi, I have 2 tables PROJECTS related to JOBS When I add a JOB to the PROJECT (using the Add Job URL) I would like for a specific form to open In the JOBS Table. Currently "Main Form" opens. I would like for the "Job Start Form" to open. I prefer not to create a role to use this form. Thoughts? Thank you
