Hyperlinking in an Excel file to images on ODK Aggregate server

Hi there,

I am having some difficulty with a particular set of data on my ODK
Aggregate server. We have the url links produced from the exported ODK raw
data spreadsheet in Excel. We also have another spreadsheet and want to
create a hyperlink to the link on the raw data sheet. However when I try to
create a link it only links to the first row image and does not allow me to
link to each corresponding image links for each subsequent row. Any idea
how to do this?

Raw data link:

https://lh3.googleusercontent.com/-i3VJrvQXN4E/VpzLbskoK-I/AAAAAAAAAJ4/fs6VTqwthuI/s1600/rawdata.JPG

Link showing in other spreadsheet in same workbook:

https://lh3.googleusercontent.com/-GAo0WedGbFg/VpzLp4CIwYI/AAAAAAAAAKA/u8st5AddoAo/s1600/otherspreadsheet.JPG

Any advice?

Thanks very much,
-Brett

Has anyone encountered this challenge in their Excel spreadsheets before?

Thank you for your support,
-Brett

··· On Monday, January 18, 2016 at 12:27:27 PM UTC+1, Brett Collins wrote: > > > > Hi there, > > > I am having some difficulty with a particular set of data on my ODK > Aggregate server. We have the url links produced from the exported ODK raw > data spreadsheet in Excel. We also have another spreadsheet and want to > create a hyperlink to the link on the raw data sheet. However when I try to > create a link it only links to the first row image and does not allow me to > link to each corresponding image links for each subsequent row. Any idea > how to do this? > > Raw data link: > > > > > > Link showing in other spreadsheet in same workbook: > > > > > > > Any advice? > > > > Thanks very much, > -Brett >

If nobody answers here, you might find more help on an Excel users group.

··· On Tue, Jan 19, 2016 at 2:50 AM, Brett Collins wrote:

Has anyone encountered this challenge in their Excel spreadsheets before?

Thank you for your support,
-Brett

On Monday, January 18, 2016 at 12:27:27 PM UTC+1, Brett Collins wrote:

Hi there,

I am having some difficulty with a particular set of data on my ODK
Aggregate server. We have the url links produced from the exported ODK raw
data spreadsheet in Excel. We also have another spreadsheet and want to
create a hyperlink to the link on the raw data sheet. However when I try to
create a link it only links to the first row image and does not allow me to
link to each corresponding image links for each subsequent row. Any idea
how to do this?

Raw data link:

https://lh3.googleusercontent.com/-i3VJrvQXN4E/VpzLbskoK-I/AAAAAAAAAJ4/fs6VTqwthuI/s1600/rawdata.JPG

Link showing in other spreadsheet in same workbook:

https://lh3.googleusercontent.com/-GAo0WedGbFg/VpzLp4CIwYI/AAAAAAAAAKA/u8st5AddoAo/s1600/otherspreadsheet.JPG

Any advice?

Thanks very much,
-Brett

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com