tl;dr: can I create a snippet where a variable is used in the image feature?
I am looking to create a snipped which takes a excel / google spreadsheet result and uses it in an ai tool. For this I plan to copy the result in question into the clipboard (think big button on the spreadsheet) and then use it.
taken the excellent info in this thread
I have the lines of my copied cell and can work with them.
the ai can talk about an image but it needs to be pasted into the input box as if it was in the clipboard.
does not have examples so my question
can i use image with a variable and if so, how?
stripped down the example from the help is
{image: https://quickchart.io/chart?width=600&height=300&bkg=transparent&c=\}
so basically {image: url}
I tried {image: {=variablename}} but it did not paste the image. My guess is that it has to do with permissions because when I entered that command into the editor directly with a URL, it asked for permission to use it - why btw?
thanks in advance
side note: maybe add a few simple examples on the help page.
{image: https://quickchart.io/chart?width=600&height=300&bkg=transparent&c=\{"type": "bar","data": {"datasets": [{"label": "Investment Size ($)", "data": [{=join([investment * (1 + rate/100)^(i-1) for (y, i) in seq(0, 11)], ",")}]}], "labels": [{=join(seq({time:YYYY}, {time:YYYY} + 11), ",")}]}}}
may not be the best first example for it.