AnsweredAssumed Answered

Hey brothers I just started building this data base like 3 months ago and I have never use filmmaker...

Question asked by MUSTAF on Jul 17, 2014
Latest reply on Jul 17, 2014 by philmodjunk

Post

     Hey brothers I just started building this data base like 3 months ago and I have never use filmmaker pro 12 before or build a database in mu life, but I have picked it up pretty well. My only problem is that I am stuck on the conditional formatting section: I have phase1, 2 & 3 and each phase is 90days after the end day and I have that populating from the date the phase one start date is entered. But their vacation time don’t start until phase 2 that's 90days after phase one and the same for the rest of the phase. In phase 2 they accrue 4 vacation days, 2 for phase 3 and 2 for phase 2. i want phase 2vacation accrue to be the only one green until the next phase and if the client don’t use the vacation day in a certain phase, I want it to auto add to the next phase day and the next phase to turn green as soon as the current phase is past 90days. And I want only the active vacation hours to show in total hours remaining and vacation use to just keep track of the total vacation used. And I want all those changes to take place as i input information in the used vacation time portal and I want  this to happen by phases. But my phase field is a drop down list.. I am stuck bro ...if there's any way you can help me with the calculation  I will really appreciate your help.Thanks’ in the advance.

Screen_Shot_2014-07-15_at_1.10.57_PM.png

Outcomes