How to add a value from the web,
need to add the value of the conversion of € to $
numbers-OTHER, iOS 7.0.4
Numbers can only reference cells within the same document. It cannot take input (as a reference) from a URL
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.
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"
ok thanks a lot
have a nice rest of the week!!!
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
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
You can always copy real data from a web page and paste into a table
it is not the same
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
add a value from the cloud or internet in a cell
