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 > OmniOutliner > OmniOutliner 3 for Mac
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
Checkbox summary Thread Tools Search this Thread Display Modes
I am just starting to use OO. I am using it to track household chores, with rows representing chores and columns representing days of the week. I use checkboxes to indicate that a chore was completed. When I turned the column summary on, I can see that if any box in a column was checked, I get an indication to that effect. Ideally, I would like to see not only the fact that there was at least one check, but how many there were. I assume that if I make the column a number column and put 1 instead of a check, the summary will give me the right result, but I was wondering if I could accomplish this with the checkboxes.

Thanks!

Daniel.
 
Quote:
Originally Posted by imlad View Post
I would like to see not only the fact that there was at least one check, but how many there were
It would be worth requesting a 'numeric' summary type for checkbox columns through Help > Send Feedback in the OO3 menu.

In the meanwhile, as you suggest, only a numeric column (using digits in lieu of checkboxes) will give you an automatic numeric summary.

If you really want to use check-boxes you could install a script on your 003 toolbar to update numeric counts of checkboxes in an adjacent numeric column, but you would have to click the script every time you wanted to update the numbers - probably not ideal ...

(Such a script might look something like the following)

Code:
property pstrSummaryCol : "CheckSums"

tell application "OmniOutliner Professional"
	set oDoc to front document
	tell oDoc
		-- Get a reference to the first checkbox column
		set colCheck to first column whose type is checkbox
		if colCheck is missing value then return
		set idCheck to id of colCheck
		
		-- Get a reference to a CheckSums column (creating it if necessary)
		set refCols to a reference to columns
		if not (name of (refCols) contains pstrSummaryCol) then ¬
			set oCol to make new column at end of columns with properties {name:pstrSummaryCol, type:number}
		set oCol to first column whose name is pstrSummaryCol
		set format string of oCol to "0"
		set idSum to id of oCol
		
		-- Count checked boxes and update the sums for each parent row
		set lstTopParents to (rows of oDoc where (level is 1) and has subtopics is true)
		repeat with oRow in lstTopParents
			my CountChecks(oRow, idCheck, idSum)
		end repeat
	end tell
end tell

-- Count the checks, and write (sub)totals to the CheckSums column of any parent rows
on CountChecks(oRow, idCheck, idSum)
	using terms from application "OmniOutliner Professional"
		tell oRow
			if has subtopics then
				set lngChecks to 0
				repeat with oSubTopic in children
					set lngChecks to lngChecks + (my CountChecks(oSubTopic, idCheck, idSum))
				end repeat
				set value of (cell id idSum) to lngChecks
				lngChecks
			else
				if (value of cell id idCheck) is "checked" then
					1
				else
					0
				end if
			end if
		end tell
	end using terms from
end CountChecks

Last edited by RobTrew; 2010-06-26 at 03:02 PM..
 
RobTrew, thank you very much!
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to keep a summary window on top kencohen OmniFocus 1 for Mac 0 2011-05-24 06:00 AM
Thumbnails or graphic summary danield1 OmniGraffle General 2 2009-05-05 09:38 AM
Summary of tasks for today? ianpiper OmniFocus 1 for Mac 14 2009-04-12 04:01 PM
Executive Summary Janice OmniFocus 1 for Mac 10 2007-07-10 05:15 PM


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


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