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

 
How can I set the value of a cell for multiple rows? Thread Tools Search this Thread Display Modes
I'd like to set the value of a cell for multiple rows at once (in this case the cells are of the pop-up list type).
Any suggestions?

The only threads I could find where these:
Thanks
 
A rough outline of the kind of script that would do this for a document with just one popup column:

Code:
property pTitle : "Set popup value of selected rows"
property pClear : "[CLEAR]"

tell application id "OOut"
	tell front document
		-- LOOK FOR A POPUP COLUMN
		try
			set colPopup to first column where type = popup
		on error
			display alert "No Popup column found"
			return
		end try
		
		-- INVITE THE USER TO CHOOSE A POPUP VALUE (OR TO CLEAR THE VALUES)
		set lstOptions to (name of enumerations of colPopup) & pClear
		set varChoice to choose from list lstOptions with title pTitle default items item 1 of lstOptions
		if varChoice = false then
			return
		else
			set varChoice to first item of varChoice
		end if
		
		-- APPLY ANY CHOICE TO ALL THE SELECTED ROWS
		if varChoice = pClear then set varChoice to missing value
		set (value of cell id (id of colPopup) of selected rows) to (varChoice)
	end tell
end tell

Last edited by RobTrew; 2011-08-23 at 11:35 AM.. Reason: Amended to allow for clearing existing values
 
Amended (above) to add a [CLEAR] option.
 
Thanks Rob, I'm going to try that!
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Total cell at the end of the document hermann OmniOutliner for iPad 2 2011-05-12 12:20 PM
Trying to get URL in cell MarkHernandez AppleScripting Omni Apps 2 2010-02-23 08:23 AM
Feature requests - merge rows and icons for rows maish OmniOutliner 3 for Mac 0 2008-09-19 07:12 AM
change value on multiple rows? steve OmniOutliner 3 for Mac 1 2008-06-19 01:58 PM


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


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