The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

Go Back   The Omni Group Forums > Developer > AppleScripting Omni Apps
FAQ Members List Calendar Today's Posts

 
Plan: Data Calculations (custom column math) Thread Tools Search this Thread Display Modes
I agree that it's ugly, and I've already filed a bug to look into this. Sorry for making it sound like we don't care about this.
 
thank you for your reply
Data Entry
 
Hi Lizard,
Say I have a custom field which is float (1.25) and I want to roll up/sum up the values of this custom field to its parent group, how do i do that.
By the way your script worked nicely to update the calculated field in custom data. Thanks



Quote:
Originally Posted by Lizard View Post
Here's Apple's official AppleScript reference:

I actually find Matt Neuberg's book AppleScript:The Definitive Guide (O'Reilly) more helpful.

Here's an example of an AppleScript that does approximately what I described above:
Code:
tell application "OmniPlan"
	repeat with t in tasks of front document
		if task type of t is standard task then
			-- effort is in seconds
			set budgetHours to (effort of t) / 3600
			set budgetPrice to value of custom data entry "Budget Hour Price" of t
			if budgetHours is missing value or budgetPrice is missing value then
				set budgetTotal to 0
			else
				set budgetTotal to budgetHours * budgetPrice
			end if
			set value of custom data entry "Budget Total" of t to budgetTotal
		end if
	end repeat
end tell
 
 




Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom data didn't migrate to 2.0? workinprogress OmniPlan General 1 2011-07-27 02:08 PM
Due column disappears in custom perspective morpheusmorph OmniFocus 1 for Mac 4 2011-05-19 10:05 AM
Can't save custom column choices rogbar OmniFocus 1 for Mac 2 2010-04-09 05:01 PM
Plan: What is the value of blank Custom Data cdpatnoe AppleScripting Omni Apps 6 2008-03-07 01:43 PM
Custom column(s) RobTrew OmniFocus 1 for Mac 2 2007-08-23 05:26 AM


All times are GMT -8. The time now is 02:09 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.