Tutorial:Simple To Do List Enhancements: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
Line 118: Line 118:
==== Add Over/Under Calculation ====
==== Add Over/Under Calculation ====


Edit the Library again, and this time add a JavaScript field called Over or Under.
Edit the Library again, and this time add a JavaScript field called Over or Under. An edit card will be displayed for the JavaScript field.
 
In the script area, where the watermark JavaScript is filled in, press the + Field button and select the Actual field. You'll see, inserted for you "field('Actual')" (the double-errors are mine). Type a minis sign ("-"), then press + Field again and this time select the Estimate field.
 
That's it for the script; now just display in the list as Entry Status, and your done. Tasks that are under budget well show a negative number, on budget a zero, and over budget a positive number. I suggest setting the field to One row with prev to keep all estimates on the left and actuals on the right.
 
Of course, with grouping, you can see the variance by phase or by contractor and overall st the bottom.


[[Category:Tutorial]]
[[Category:Tutorial]]

Navigation menu