hyper link in the data table.

[Brian Flieck]

does anyone know if you can add hyperlinks in the data-table. my data is referencing folder names and i'd like to make the folder names hyperlinks to the actual folder location.

 ['folder', 'ready', 'not sent off shore', 'not ready', 'freelanced', 'ready to QA' , 'placeholder' ],
['Christopher_Banks/post/CB_instock/0' , 0,  1, 0, 0, 0, 0],
['Christopher_Banks/post/CB_instock/6' , 0,  1, 0, 0, 0, 0],
['Christopher_Banks/post/CB_instock/9' , 0,  1, 0, 0, 0, 0],
['Aeropostale/post/instock/0' , 0,  0, 0, 43, 0, 0],
['Aeropostale/post/instock/8' , 0,  0, 0, 103, 0, 0],
['Tumi/post/instock/' , 14,  115, 0, 0, 0, 0],
['Maurices/Post/instock/RUSH' , 72,  0, 1, 0, 0, 0],
['Maurices/Post/instock/0' , 2,  0, 0, 0, 0, 0],
['Maurices/Post/instock/3' , 10,  0, 0, 0, 0, 0],
['Maurices/Post/instock/5' , 17,  0, 0, 0, 0, 0],
['Maurices/Post/instock/6' , 17,  0, 0, 0, 0, 0],
['Maurices/Post/instock/7' , 23,  0, 0, 0, 0, 0],
['Maurices/Post/instock/8' , 10,  0, 0, 0, 0, 0],
['Maurices/Post/instock/LIGHTBOXCALLOUTS' , 0,  4, 0, 0, 0, 0],
['Dress_Barn/Post/instock/RUSH' , 22,  0, 0, 0, 0, 0],
['Dress_Barn/Post/instock/0' , 24,  0, 0, 0, 0, 0],
['Dress_Barn/Post/instock/1' , 46,  0, 0, 0, 0, 0],
['Dress_Barn/Post/instock/2' , 86,  0, 0, 0, 0, 0],
['Dress_Barn/Post/instock/3' , 23,  0, 0, 0, 0, 0],
['Dress_Barn/Post/instock/5' , 14,  0, 1, 0, 0, 0],
['Dress_Barn/Post/instock/6' , 20,  0, 0, 0, 0, 0],
['Dress_Barn/Post/instock/7' , 8,  0, 0, 0, 0, 0],
['NYCompany/post/instock/RUSH' , 1,  0, 0, 5, 0, 0],
['NYCompany/post/instock/0' , 1,  0, 0, 0, 0, 0],
['NYCompany/post/instock/2' , 39,  0, 0, 0, 0, 0],
['NYCompany/post/instock/3' , 37,  0, 0, 35, 0, 0],
['NYCompany/post/instock/4' , 81,  0, 1, 0, 0, 0],
['NYCompany/post/instock/5' , 8,  2, 96, 0, 0, 0],
['LTBrands/post/Instock/8' , 31,  0, 0, 0, 0, 0],
['HenriBendel/post/instock/4' , 8,  0, 0, 0, 0, 0],
['LuckyBrand/Post/Instock/2' , 97,  0, 0, 0, 0, 0],
['LuckyBrand/Post/Instock/4' , 115,  0, 3, 0, 0, 0],
['LuckyBrand/Post/Instock/6' , 0,  0, 2, 0, 0, 0],
['LuckyBrand/Post/Instock/7' , 3,  0, 0, 0, 0, 0],
['LuLuLemon/Post/instock/PRIORITY' , 0,  0, 0, 135, 0, 0],
['LuLuLemon/Post/instock/1' , 0,  0, 0, 238, 0, 0],
['LuLuLemon/Post/instock/3' , 0,  0, 0, 82, 0, 0],
['LuLuLemon/Post/instock/4' , 0,  0, 0, 56, 0, 0],
['LuLuLemon/Post/instock/5' , 217,  0, 0, 0, 0, 0],
['Uniqlo/Post/instock/6' , 3,  0, 0, 0, 0, 0],
['Uniqlo/Post/instock/7' , 199,  0, 46, 0, 0, 0],
['Uniqlo/Post/instock/8' , 5,  0, 204, 0, 0, 0],
['CliqueMedia/instock/2' , 12,  0, 0, 0, 0, 0],
]);

[Ray Thomas]

Yes you can. Once I've got the table I use .getNumberOfRows() to get the number of rows, then loop through the table getting the values I need from it using .getValue and use .setCell to change the formatted value.

Those methods are described on https://developers.google.com/chart/interactive/docs/reference

I have a JSFiddle at https://jsfiddle.net/brisray/3002utsd/ that shows the code and the spreadsheet used is at https://docs.google.com/spreadsheets/d/1cfoyhsGIvicksLVxz3kZIaf_N4xkgVMV_PFvUxlBgU0/edit#gid=0

I have used the method on several live sites and it is robust:

http://www.indstate.edu/business/facstaff/conferences with the table at https://docs.google.com/spreadsheets/d/1HjYG_w7Pw6K3kJbXhDoz-m4D4PPkhMusRBfhWgPY5vc/edit#gid=0

http://www.indstate.edu/business/social-media/all with the table at https://docs.google.com/spreadsheets/d/1cfoyhsGIvicksLVxz3kZIaf_N4xkgVMV_PFvUxlBgU0/edit#gid=0

http://hmsgambia.org/crewlist.htm with the table at https://docs.google.com/spreadsheets/d/1kjOTQMAlWc-j6G_XfFUJIzAxuvmyxygQh0q1Dpn4oRU/edit#gid=0

As the links are completely different to the cell values I put the URLs in the spreadsheet, but there's no reason the links cannot be constructed in the script from the information already in the cell.

Ray

[Ray Thomas]

Hello Brian,

I think I may have misled you. I had a look through your earlier posts and tried to recreate what you are trying to do.

Adding links to the data only appears to work if the the chart type is a table. I also had a look at the huge gap between the control and the chart. I have no idea what is happening. It's nothing to do with the padding or margin on either div. I tried changing both to negative values and all it does is move the chart div up to cover the control div.

http://brisray.com/test/flieck.htm 

Ray

[Brian Flieck]

Thanks Ray! yea i was playing with your info eariler and thought i could set a cell to be a URL, and it doesn't seem to work. I haven't tried in table form yet, but i'm guessing your correct that i won't work. I have to update my other post, i found the answer to the spacing issue.

it seems that the chart wrapper had to come at the bottom of the var.

        var barChart = new google.visualization.ChartWrapper({
          'chartType': 'BarChart',
          'containerId': 'chart_div',
          'options': {
//                      width: 1200,
                  'height': 900,
                  'colors': ['#00a591', '#ECDB54', '808080', '#6B5B95', '3645b5', '000000'],
                  'isStacked': true,
                  'fontSize': 11,
                  'chartArea': {'left': 450, 'top': 20, 'right': 250, 'bottom': 50},
                  'fontSize': 11,
                  'title': 'Folder Count 04-26-18 05:10:01'
          }
        });