I have looked at the documentation on your site. But its from 2018 and it seems to have been updated since then.
So how do I do to add html Macro?
My objective is to embed a google chart.
One way would be to insert Iframe though the iframe macro.
But I wanted to try this code:
function drawChart() {
var queryString = encodeURIComponent('SELECT A, B LIMIT 3 OFFSET 0');
var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1xxxxxxxxxxxxxxxxedit?gid=0&headers=1&tq=' + queryString);
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new google.visualization.ColumnChart(document.getElementById('columnchart'));
chart.draw(data, { height: 400});
}
How can I do that?
Hi @Felix
In the new editor type /iframe and then click to edit the macro. A form appears and you have various options.
Whether your functions works is another story.
In the old editor, type {iframe - and choose between HTML/Iframe Macro or Iframe. Again you will need to play around with the form fields.
-Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Felix
No, I didn't think you could, as it is a very basic iFrame, I am guessing Atlassian don't want their website / cloud to broken by a rouge script.
-Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Mike Bowen
That makes totally sense :) Thanks again. There was a much easier way to do what I wanted from /iframe macro. It was possible to "publish" the google sheets graf itself and add that URL in the macro. Simple as that :D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Felix
Well good for finding a solution.
There are some clever plugins that allows Google Drive files or folders to be inserted within the page. It is called Google Drive and Docs for Confluence
-Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.