Welcome to iPadForums.net Guest - Click Here to Register

Numbers and Hyperlinks

This is a discussion on Numbers and Hyperlinks within the iWork Forum forums, part of the iPad App Store category; Hi, completely new to this and struggling! All help greatly appreciated. Basically it's an iPad 3 question and the iWorks Numbers App. I'm pretty good ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 28
Like Tree2Likes

Thread: Numbers and Hyperlinks

  1. #1
    iPF Novice
    Member #
    211517
    Liked
    7 times
    Join Date
    May 2012
    Location
    UK
    Posts
    82

    Numbers and Hyperlinks

    Hi, completely new to this and struggling! All help greatly appreciated.

    Basically it's an iPad 3 question and the iWorks Numbers App. I'm pretty good with MS Excel but Numbers is new to me.

    I'm putting on a set of Flight Reference Cards for the helicopter I fly commercially. This consists of about 200 worksheets. On worksheet 7'ish is the index, on that worksheet I've created a table of every warning indication you could possibly get and placed them in single cells of the table, next to each one is a cell that gives you which page (Worksheet) you would need to go to, to get the actions that are required to sort out the problem - these worksheets are just jpegs inserted onto the worksheet. (Just like an index really - ie engine stops - goto page/drill 27).

    I guess I have to add a table to each sheet (easy) so I can link the index to the sheet and I guess this is by HYPERLINK? - I hope this makes some sense.

    Basically I'm trying to select the warning cell and get it to go to the worksheet to deal with the problem.

    I know how to enter the code I just don't know what the code is or how to get the HYPERLINK to work ....... All help greatly appreciated.

    Best wishes in anticipation

    Steve

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    You might be able to cobble something like this together in Keynote using tables and links, but Numbers only allows web links (no links to other worksheets), and they have to be entered as text inside a shape. You can't put a links in cells.

    I put together a quick Keynote presentation with an index table slide with links to other slides. It's doable, but since it only works when you are in play mode, I doubt it is what you want.

  4. #3
    iPF Novice
    Member #
    211517
    Liked
    7 times
    Join Date
    May 2012
    Location
    UK
    Posts
    82
    Thank you so much for your answer and though; certainly not your fault I have to say I'm more than a bit disappointed with the
    functionality of the Numbers App. Sadly, you are right it's not workable in a play mode.

    This is so basic in MS Excel. Why on earth can we not put in a simple VBA command into a formula to take us to another
    worksheet. If anybody from iWork's reads this perhaps they'd like to comment.

    But thanks very much again for replying and who knows somebody might know a work around.

    Steve

  5. #4
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    No problem.

    I doubt you are going to find VBA supported in any of the iPad's spreadsheet apps.

    Good luck finding the app you need. It is probably out three.

  6. #5
    iPF Novice
    Member #
    211517
    Liked
    7 times
    Join Date
    May 2012
    Location
    UK
    Posts
    82
    Still playing with this in my mind and I'm wondering?

    A part of the Numbers prog (probably nothing to do with Numbers, but running all the time) is "Find", in the settings. Now, if I put something unique on each worksheet (thats easy most are Jpegs of the real things) say 01 to 200 in a text box. If i then Go to find; it takes me to the page I'm after!!!! So how does that work then?

    Problem is this reduces the sizing of the jpeg and you have to expand it again to read it - I'm still fishing for help here if anybody is reading

    Steve

  7. #6
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    I've played with this too, and have only come up with one solution, so far.

    Since most of your notes are jpg anyway, you could probably use Evernote.

    It has several view modes and lots of search and tagging ability. This might eliminate the need for a table of contents.

    If it does not, then there is a feature called a Note Link. It's a link inside a note that takes you directly to another note. Essentially your notes can be wiki-like, linking to each other. It would be fairly easy to set up a table of contents note, and even include a link back to the table of contents in each note.

    Note Links are not the same as Shared Links. They are internal to your Evernote account, not a URL that you email other people. That makes them quick and private.

    The desktop app also allows a fair amount of RTF editing, including tables.

    There are two downsides.

    1) As far as I can tell you can only create Note Link using the computer app. Neither the website nor the iPad can create them. They do however work on the iPad and the website. They are very nice on the iPad, as they linked note shows up in a window instead of just jumping to the other note.

    2) The free Evernote account only works online. It sounds like you'll be using this in the helo, and therefore off line. To keep your Evernote notes stored locally (beyond what is buffered) you'll need to pay the $5/mo or $45/yr.


    I'll keep an eye out for a better solution, and let you know if I run across one.

  8. #7
    iPad Fan
    Member #
    31439
    Liked
    10 times
    Join Date
    Jan 2011
    Posts
    153
    twerppoet likes this.

  9. #8
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    Quote Originally Posted by dougrogers View Post
    VoodooPad for IOS?

    VoodooPad: VoodooPad for iOS
    I knew I'd seen this kind of wiki-like note app before, but couldn't remember the name. Thanks.

  10. #9
    iPF Novice
    Member #
    211517
    Liked
    7 times
    Join Date
    May 2012
    Location
    UK
    Posts
    82
    Thanks all but company has already in to far in with numbers it's just a shame because the spreadsheet works a treat less the damn inability to link pages which I actually think is pretty basic from a spreadsheet.

    My own fault I suppose but its so basic.

    Yes we use them in the aircraft and in flight for many functions and online is not always an option I work 300nm off shore daily, Thanks again.
    Last edited by pilgrimav8r; 06-03-2012 at 03:10 PM.

  11. #10
    iPF Legend
    Member #
    28530
    Liked
    1526 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,436
    In my experience everyone thinks that the features they use are 'basic'. Just human nature. I seriously doubt that the average user uses hyperlinks in a spreadsheet, let alone scripting languages. iWorks is advertised (or was) as a consumer product, not a business solution.

    That said, the Max OSX version is considerably more powerful, and many people have confused descriptions of it with the iOS version.

    Where are you seeing this hyperlink claim? It's not in the iTunes Store description, or I'm missing it.
    Last edited by twerppoet; 06-03-2012 at 03:10 PM.


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. PDF hyperlinks vs. Outline
    By Bimjo in forum iPad Apps
    Replies: 1
    Last Post: 06-15-2011, 08:03 AM
  2. Executable Hyperlinks
    By Psunate77 in forum iPad Apps
    Replies: 1
    Last Post: 06-05-2011, 12:06 AM
  3. PDF Hyperlinks?
    By raurky in forum iPad App Announcements
    Replies: 0
    Last Post: 06-02-2011, 10:50 PM
  4. Hyperlinks in quickoffice
    By savagescience in forum iPad General Discussions
    Replies: 0
    Last Post: 05-29-2011, 03:25 PM
  5. Hyperlinks IN Pages
    By buzzkill in forum iPad General Discussions
    Replies: 4
    Last Post: 04-13-2011, 12:41 AM

Search tags for this page

how to remove hyperlinks in numbers

,

hyperlink in numbers

,

hyperlinks in iwork numbers

,

hyperlinks in numbers

,

hypertext in numbers on ipad

,

ipad numbers hyperlinks

,
mac numbers edit remove hyperlink
,

numbers hyperlink to sheet

Click on a term to search for related topics.