OS X Technologies :: Accessing Cells In Numbers With Apple-script?

Mar 1, 2012

HiThe usual tale of an Applescript beginner getting lost but, I want to be able to search for a selected membership number within a Numbers spreadsheet, extract that member’s email address and send a message. I have managed to create a script that creates and sends the email but after several attempts I cannot work out how to start searching cells for a particular value and how to extract data from cells in the selected row.

Info:
iMac, Mac OS X (10.7.1)

View 3 Replies


ADVERTISEMENT

Applications :: Numbers - How To Rename Cells

Sep 26, 2009

In Excel, you can easily rename a cell to whatever you want. i.e from A1 to yaxis How do you do this in Numbers? I can't find it.

View 1 Replies View Related

Applications :: Merge Cells IWork 09 Numbers?

Oct 21, 2010

Is there a keyboard shortcut to merge selected cells?
Numbers '09, version 2.0.3 (332)

View 1 Replies View Related

Applications :: Numbers 08/09 Counting/not Empty Cells?

Jan 18, 2009

I just want to know if there is any way (formula) to count the numbers all the cells which are not empty in a column or row disregarding the content of the cell.

It may contain date, text or even number. I don't want to have the sum of those numbers, rather how many cells, have something in them.

View 2 Replies View Related

MacBook Pro :: Borders Around Individual Cells In A Row In Numbers?

Feb 16, 2012

How do you put a border around the whole cell in a row of cells, ie  Totals of several columns in the Numbers s/s.?

Info:
MacBook Pro, Mac OS X (10.6.8)

View 2 Replies View Related

Applications :: Numbers - Formula Not Let To Select Cells - Only Whole Column

Oct 17, 2009

I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)

However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).

View 2 Replies View Related

Applications :: Linking Cells / Columns Between Sheets In Numbers

Nov 21, 2009

In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?

View 1 Replies View Related

MacBook Pro :: Merge Multiple Cells Into One Cell In Numbers?

Apr 18, 2012

I'm trying to make a mailing list and take information from multiple cells in numbers and put into one cell to print.  Anyone know how this is done? 

Info:
MacBook Pro

View 1 Replies View Related

OS X V10.6 Snow Leopard :: Unable To Change The Format In Cells In Numbers?

Jan 31, 2012

Every time I change the cell format in numbers, it keeps going back to 12/30/11 when I want 2/1/12.  It is quite frustrating because I did what it said to do.

View 2 Replies View Related

OS X Technologies :: Enscript Cannot Add Line Numbers

Feb 29, 2012

I recently figured out which flags to use to keep the "over" script from being horribly bland and not much better than straight less.

enscript -E -p- --line-numbers --quiet --language=ansi --color --style=emacs "$*" 2>&1 | less

My only problem with this setup is that the line numbers are missing. I can pass in the -c flag, or --line-numbers, it doesn't matter: I never get line numbers. And I tried installing enscript on my linux box too and it also leaves out the line numbers. Does anyone have any ideas, or at least know the last working version of enscript?

Info:MacBook Pro (15-inch Mid 2009), Mac OS X (10.7.3), 3GHz, 8Gb RAM, 40GB SSD + 750GB HDD

View 2 Replies View Related

OS X Technologies :: Get A List Of All Inode Numbers On A Volume?

Mar 22, 2012

Is there any way to get a list of all inode numbers on a volume?  I have a "find -x /Volumes/thedisk/* -exec stat {} ;" going but requires lots of CPU time.  Seems like I should be able to look directly at the file allocation table...oh wait, that is DOS. This is on an HFS disk: /dev/disk0s2 on / (hfs, local, journaled) 

Info:
MacBook Pro, Mac OS X (10.6.8)

View 4 Replies View Related

OS X Technologies :: Applescript To Cut And Paste First Word Of Numbers Cell

May 19, 2012

I'm creating a Service in Automator, and would like incorporate an Apple script that will "cut" the first word in any Numbers cell that I select, and "paste" it into the cell directly to the left of the the cell I've selected. Let's assume the column I'm selecting from is Column C. As a very rough start, here is what I have (with some of things I'm trying to accomplish in brackets):on run {input, parameters}tryset MyText to input as stringset FirstWord to first word of MyText set [remove the first word and a single space from what I've selected]tell application "Numbers"tell table 1 of sheet 1 of document 1set theRow to [the row of the cell I've selected] set value of cell 3 of theRow to FirstWord end tellend tellend try return inputend run.

View 7 Replies View Related

OS X :: Accessing Actual Apple System Sounds Location?

Sep 30, 2009

Does anyone know where to find the actual sound files for Apple sound effects like Tink, Sosumi, Pop, Submarine, Purr, etc.?

View 4 Replies View Related

App Store :: Getting Numbers From Apple Mac?

Mar 18, 2012

I just cant get numbers form app store. Every time I want to get it, it shows "There was an error in the App Store. Please try again later. (100)". And no matter how i try, it is just not downloading...

Info:
Mac App Store, Mac OS X (10.7.3)

View 1 Replies View Related

Mac Pro :: Can We Use 12 Cells PRO Battery To Replace 6 Cells Battery

Apr 14, 2010

In order to get more run time out of door, the better way is using high capacity battery. Some ask me if we can use 12 cells Mac Pro battery to replace 6 cells battery.

View 1 Replies View Related

Applications :: How To Add Page Numbers In Apple Pages?

Aug 12, 2008

I feel like this should be a simple question, but I cannot seem to get it to work. i have a 31 page, Pages document that I made from scratch. i want to number all the pages somehow.

View 3 Replies View Related

OS X Technologies :: Apple Script For Mail Headers?

Mar 19, 2012

I am currently trying to generate a report using the headers from Apple Mail. The script I have works, but I would like to be able to pull out messages that are sent to a specific recipient ( a certain distribution group in this case...). 

[Code]...

View 1 Replies View Related

OS X Technologies :: Pinging IP Address Via Apple Script

Mar 27, 2012

this is my second script im trying to create. What i would like this script to do is have the user input and ip and ping that address my problem lies in getting ip address from the dialouge box into the "do shell script", this is my script so far  set Ip_address to ""set Dialog_1 to display dialog "Enter Ip Address" default answer "" with title "Ping"set the Ip_adress to the text returned of Dialog_1set ping to (do shell script "ping -c 2 & Ip_address & ")if ping contains "64 bytes" then display dialog "Connection Secessful"   

And also how do i make a variable so if it comes back i unresponsive  i can have a dialog box say "Connection Unsecessful" (I know i can do this maunally but i would like to create a script so its easier for the end user)

Info:
MacBook, Mac OS X (10.6.8)

View 10 Replies View Related

OS X Technologies :: Changing Background Via Apple Script

May 14, 2012

I manage a small deployment of different macintosh products and I currently have to run 5 different images so that the background images look right on all the various resolutions. I have been working on a piece of applescript to prompt the user on first startup to select their hardware type to apply the proper background image but I am running into a few issues. Firstly the method I am using limits me to three options and I cant seem to find any documentation on how the list function works..Second, I keep getting errors saying the files can't be found. [code]

View 2 Replies View Related

OS X Technologies :: Combine 2 PDF Files Into 1 Using Apple-script?

Jun 22, 2012

I am just starting out with applescript and could do with a pointer please. I have written a script which saves two pdf files from an active Illustrator document in the source folder of that document. The issue I am have now is that I cannot get the two files to combine into a single PDF file. The whole script is quite long and is works apart from the combine PDF part?

tell application "Finder" try open (every document file of container of file_path whose name contains ".pdf")  on error display dialog "no PDF file located"

[code]....

Both PDF documents open and are set as the variables docRefA and docRefb, but the acrobat command 'bring to front' and 'insert page' do not seem to be working. I get an error come up in an illustrator dialog box saying "Adobe Acrobat Pro got an error: document "84056_R1.pdf" doesn't understand the bring to front message".

Info:
Mac OS X (10.6.8)

View 14 Replies View Related

Applications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers

Jul 17, 2010

I've been ripping my hair out trying to find the answer to this.

In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.

For example:

Column A - 1 - 5

Column B - (value in Column A * 5)

I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.

The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"

View 1 Replies View Related

Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?

Mar 24, 2009

See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.

like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.

View 3 Replies View Related

MacBook Pro :: Change India Numbers To Arabic Numbers?

May 22, 2012

how to change india numbers to arabic numbers?

Info:
MacBook
Pro, Mac OS X (10.6.7)

View 3 Replies View Related

OS X Technologies :: Apple Script Address Book Calling?

Feb 4, 2012

I am trying to make a script that allows me to call a number in Address Book in my Avaya Softphone app. Everything works great except that all numbers need to have "9-1" or "91" before the phone number. This is needed to access the outside line and all calling requires the country code. how to add the 91 to the script so that all phone numbers in the script have this added. 

[code]....

Info:
15" Macbook Pro 2.4 Ghz, Mac OS X (10.6.2)

View 3 Replies View Related

OS X Technologies :: Follow My Link Or Whcih Is To Varify My Apple Id?

Mar 21, 2012

How can I follow my link or whcih link to varify my apple id?

Info:iPhone 3GS, iOS 5.0.1

View 1 Replies View Related

OS X Technologies :: Change Desktop Background In Apple-script In 10.7?

Mar 23, 2012

I'm just now upgrading from 10.6 to 10.7, and I'm having trouble with a script that I wrote that worked fine under 10.6.  In part, it executes the following command: osascript -e "tell application "Finder" to set destop picture to POSIX file "<path>"" to change the desktop background image to one of two different files based on other conditions. In 10.7, this command completes with no error code, but it only changes the background of one of my four desktops.  Is there a way to programmatically change the background image of all of my desktops simultaneously?  Failing that, is there a way to a) find out how many desktops I have and b) loop through them, setting each of their backgrounds in turn? osascript -e "tell application "System Events" to set picture of every desktop to "<path>"" Unfortunately, that also changes only the current desktop's picture. The larger script is in Perl, so I'd prefer a technology that works well with that language, but if I have to change to a different scripting language, that's not the end of the world. 

View 6 Replies View Related

OS X Technologies :: Apple-script - Use The Result Of A Library Return Value?

Apr 26, 2012

I'm using the following script below using an external libarary to query mysql database on external server.  works.  gives results.  How do I save them to do something with the. when I run it, the results of the call to the library show up in the results window.  that makes sense. ie {rows:1, cols:1, record_data:{{"85016 "}}} I want to assign the results to a variable to use it later, particularly the 85016. I try "set testVariable to tell db_link to do_select(theDBCommand)" no good. Not sure how to do this.Script follows:  -- links to the mysql tools -[URL]set library_path to "js_aux_scripts:mysql_objects.scptd" set app_support to (path to application support folder) as stringset DB_Library to (load script file (app_support & library_path)) set db_link to new_link("lala.yadayada.com", "user", "pass", "db") of DB_Library -- collect the job number you want to run-- Get the Numberset displayString to "Enter Job Number"set the theIcon to 1set theJobNumber to ""repeat  display dialog displayString default answer theJobNumber with icon

[code]...

Info:
applescript, Mac OS X (10.7.3)

View 2 Replies View Related

OS X Technologies :: Apple-script: Prepend A String With Folder Name?

May 23, 2012

I’ve found this script that copies the names of multiple selected files in the Finder to clipboard: try set theNames to {} tell application "Finder" repeat with i in (get selection) set end of theNames to name of i end repeat end tell set {TID, text item delimiters} to {text item delimiters, return} set the clipboard to theNames as text set text item delimiters to TIDend try I need to prepend to each result a string like [URL] where “folder” is the parent folder relative to the files. 

View 1 Replies View Related

OS X Technologies :: Listing Folders In Apple-script Popup?

May 30, 2012

im looking for a more elegant way to list of folders in a popup for users to select at the beginning of my script and use as a path variable.the path i need to filter through to make the list is similar to the following: /Volumes/Network Drive/A/Client Name(s) starting with A//Volumes/Network Drive/B/Client Name(s) starting with B/ other folders will be created in the folder they select.  The complications:  All the folders i want to list are divided into folders labelled with each letter of the alphabet.Also there could potentially be hundreds of these folders once consolidated to a list The current script lists the entire file path in the popup. I want the entire path to be set as the variable but just the folder name to be listed in the popup These are the scrips i have started with but would love a better way to combine and clean up.  

(*set mainList to {"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "XYZ"}choose from list mainList with prompt "Choose Client"set listchoice to result as text*)set the_folder to (path to desktop) as stringset with_subfolders to trueset inc_folders to true set the_files to get_folder_list(the_folder, with_subfolders, inc_folders)return the_files on get_folder_list(the_folder, with_subfolders, inc_folders)          set the_files to {}  

[code]....

Info:
Applescript, Mac OS X (10.7.4)

View 4 Replies View Related

OS X Technologies :: Finding An Apple-script To Detect If A Cd Is Inside The Mac?

Jun 13, 2012

I'm looking for an applescript to detect if a cd is inside my mac, if cd inside (possible to detect if empty?) do one thing.Otherwise do another thing. 

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved