JPDSG
Level 1 (0 points)

Q: add a value from the cloud or internet in a cell

How to add a value from the web,

need to add the value of the conversion of € to $

numbers, iOS 7.0.4

Posted on Dec 10, 2013 10:16 AM

by Wayne Contello,Solvedanswer
Wayne Contello Wayne Contello
Level 6 (19,416 points)
iWork
A:

Numbers can only reference cells within the same document.  It cannot take input (as a reference) from a URL

Posted on Dec 10, 2013 12:16 PM

Close
JPDSG

Q: add a value from the cloud or internet in a cell

  • All replies
  • Helpful answers

  • by Wayne Contello,Solvedanswer

    Wayne Contello Wayne Contello Dec 10, 2013 12:16 PM in response to JPDSG
    Level 6 (19,416 points)
    iWork
    Dec 10, 2013 12:16 PM in response to JPDSG

    Numbers can only reference cells within the same document.  It cannot take input (as a reference) from a URL

  • by JPDSG,Helpful

    JPDSG JPDSG Dec 10, 2013 1:03 PM in response to Wayne Contello
    Level 1 (0 points)
    Dec 10, 2013 1:03 PM in response to Wayne Contello

    Thanks a lot for your input.

    Will Apple fix this in the future?
    Or is there another way to have this cell live depending on the value of the currency.

  • by Wayne Contello,Helpful

    Wayne Contello Wayne Contello Dec 10, 2013 1:07 PM in response to JPDSG
    Level 6 (19,416 points)
    iWork
    Dec 10, 2013 1:07 PM in response to JPDSG

    I am a user like you so cannot speculate on possible features.  You can make suggestions to Apple using the menu item "Numbers > Provide Numbers Feedback"

  • by JPDSG,

    JPDSG JPDSG Dec 10, 2013 1:08 PM in response to Wayne Contello
    Level 1 (0 points)
    Dec 10, 2013 1:08 PM in response to Wayne Contello

    ok thanks a lot

    have a nice rest of the week!!!

  • by SGIII,

    SGIII SGIII Dec 10, 2013 1:14 PM in response to JPDSG
    Level 6 (10,796 points)
    Mac OS X
    Dec 10, 2013 1:14 PM in response to JPDSG

    I'm just a user too.  But based on Apple's support document, I think it can be said with some confidence that fetching data from the web will be possible to a greater degree in the future, via the use of AppleScript.  It is already possible to have AppleScript fetch values from a website and put it in a form that can be pasted into Numbers 3.0.  The pasting step probably can be automated when Apple reintroduces support for AppleScript beyond the very basic "GUI scripting" that is possible now.

     

    SG

  • by JPDSG,

    JPDSG JPDSG Dec 10, 2013 1:17 PM in response to SGIII
    Level 1 (0 points)
    Dec 10, 2013 1:17 PM in response to SGIII

    SGIII, 

     

    Thanks for your input!!!!

    It will be really good, to have this option really soon. Like that you will be able to modelate diferent secnarios with actual data.

    Is it possible to do it now?

    Best

     

    JP

  • by Wayne Contello,

    Wayne Contello Wayne Contello Dec 10, 2013 1:19 PM in response to JPDSG
    Level 6 (19,416 points)
    iWork
    Dec 10, 2013 1:19 PM in response to JPDSG

    You can always copy real data from a web page and paste into a table

  • by JPDSG,

    JPDSG JPDSG Dec 10, 2013 1:27 PM in response to Wayne Contello
    Level 1 (0 points)
    Dec 10, 2013 1:27 PM in response to Wayne Contello

    it is not the same

  • by SGIII,

    SGIII SGIII Dec 10, 2013 1:36 PM in response to JPDSG
    Level 6 (10,796 points)
    Mac OS X
    Dec 10, 2013 1:36 PM in response to JPDSG

     

    Is it possible to do it now?

     

    That depends on what the "it" is.   You can automate the data "scraping" part but you can't (until AppleScript support is restored) automate the "pushing" of the retrieved data to designated cells in Numbers 3. 

     

    Right now the best you can do is have AppleScript arrange the data in a specific format (the tab-separated flavor of "csv" character-separated-values currently works best) on the system clipboard and then you manually paste that where you want it in a Numbers 3.0 table. 

     

    If the data is already in table form on a website you can often (but not always) just copy-paste. Where AppleScript can be useful, even now, is where the data you want to retrieve is not already in tabular form.

     

    SG