From: Jermaine Ruan

From: Jermaine Ruan To: james ce I personal genius <1 Cc: Richard Kah.ar r>, Daphne Wallace Bebe Avdiu , Lesley Groff Subject: Re: I sent an invite to Dropbox Date: Thu, 01 Oct 2015 18:40:04 +0000 Attachments: Screen Shot 2015-10-01_at_2.18.54_PM.png Hi James I am still getting an error 404 when I click on the hyperlink that is in the spreadsheet. If possible call me at the office 3405147647 Sent from my iPhone On Oct 1, 2015, at 2:21 PM, james ce I personal genius < wrote: Okay, what you need is to create URLs (Uniform Resource Locators) to the images, instead of relative file paths. Dropbox explains how to do this here: https://www.dropbox.corn/en/help/167 Show instructions for the platform used by the creator of the spreadsheet, then use the relevant method to copy the link, & paste it into the spreadsheet. (This means if Daphne doesn't have Dropbox installed already, you'll need to do that for her.) <Screen Shot 2015-10-01 at 2.18.54 PM.png> As long as it's a URL hyperlink, when the viewer clicks it, it will hurl to a web browser to view the contents of the file or folder. Folders of images in Dropbox create slick gallery allowing you to click through them (see my demo here: https://www.dropbox.corn/sh/4jumgmb9f7hb93i/AABnEJG2DqdWuIgvNQYyPUAba?d1=0 — yes, all my photos are of cats). This means • the boss doesn't have to install Dropbox to view the images, • you're not downloading images to his computer without him knowing • the folders don't need to be "shared" • the links will work on all platforms (windows, OS X, iPhone / iPad, Android, etc.) James Ce your Personal Genius Certified Support Professional 10.6 httpl/personalgenius.us EFTA00338647 On Oct 1, 2015, at 2:06 PM, Jermaine Ruan < > wrote: Good day James The project is to create a way that JE can view the punch list and click on a hyperlink that will bring up pictures for each line item ( one line item may have 30 pies to it). Daphne and Anna have an excel punch list and we are able to get hyperlink pointing to zip files which work well for PC, but not on the macs. Daphne says that we don't have to be limited to excel if there is something better and an easy user interface for everyone to input and view. Regards Jruan Sent from my iPhone On Oct 1, 2015, at 1:42 PM, james I personal genius < > wrote: I'm really confused, I'm getting messages from different people trying different things.... Can you take a step back and tell me what we're ultimately trying to accomplish? At the moment it looks like you're trying to link to images within a recipient's local Dropbox folder from within Excel, and that won't work — path structures are completely different across platforms; people don't always install Dropbox in the default locations — and fundamentally is a wrong-headed idea... You're essentially creating a path to put files onto the boss' computer without his explicit instructions to do so. James Ce your Personal Genius o Certified Support Professional 10.6 +I (347) 827-0622 http://personalgenius.us On Oct 1, 2015, at 1:15 PM, Jermaine Ruan < > wrote: Good day guys I sent the invite to the Dropbox folder. @ James: the macs are not responding to the hyperlink properly like the PC can you assist. Regards Jruan EFTA00338648 Sent front my iPhone EFTA00338649