To: Jermaine Rua Cc: Richard Kah ce ; Bebe Avdiu ; Lesley Gro From: james ce I personal genius Sent Thur 10/1/2015 6:41:19 PM Subject Re: I sent an Invite to Dropbox Can't call. Send me the spreadsheet, please. James Ce your Personal Genius Certified Support Professional 10.6 http://personalgenius.us On Oct I, 2015, at 2:40 PM, Jermaine Ruan wrote: 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 - Sent from my iPhone On Oct I, 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.comien/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 EFTA_R1_00634750 EFTA02072130 my demo here: futps;//www.dropbox.com/sh/4jumgmb9f7hb93i/AABnEJG2Dg dWulgvNQYyPUAba?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 httofipersonakienius.us On Oct I 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 I, 2015, at 1:42 PM, 'ames ersonalgenius wrote: EFTA_R1_00634751 EFTA02072131 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 Certified Support Professional 10.6 http://Dersona loran i us. u On Oct 1, 2015, at 1:15 PM, Jennaine Ruan 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 Sent from my iPhone <Screen Shot 2015-10-01 at 2.18.54 PM.png> wrote: EFTA_R1_00034752 EFTA02072132