I have built a chart that shows the US states.
I can populate it with data from a database.
So I can set the tooltip to show the name of the state and the representative for that state. I have an onclick event that allows me to get a pointer to the state.
Google Geochart.png
Selwyn has a video that shows how to pass the array to onDialogueInitalize
dim js as c
js = "{dialog.object}._data = " + txt + ";"
e.javascript = js
I want to run a second SQL statement to build a second array.
In the help it shows some help for building an array to populate multiple rows in the repeating section.
Here is the Javascript I would like to populate from the database.
var _d = {dialog.object}._data; this I have passed in but I would also like to pass in height, width and colour.
var wide = wide;
var high = high;
var colour = ['#FFA000', '#FFECB3', '#FFECB3', '#FFECB3', '#FFA000', '#607D8B', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#FFA000', '#607D8B', '#607D8B', '#607D8B', '#607D8B', '#607D8B', '#607D8B', '#FFECB3', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#607D8B', '#607D8B', '#FFECB3', '#FFECB3', '#607D8B', '#BDBDBD', '#607D8B', '#607D8B', '#BDBDBD', '#BDBDBD', '#FFECB3', '#FFA000', '#BDBDBD', '#607D8B', '#607D8B', '#FFA000', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#607D8B', '#607D8B', '#FFECB3', '#607D8B', '#BDBDBD', '#BDBDBD', '#FFA000', '#607D8B', '#607D8B', '#607D8B',];
I can populate it with data from a database.
So I can set the tooltip to show the name of the state and the representative for that state. I have an onclick event that allows me to get a pointer to the state.
Google Geochart.png
Selwyn has a video that shows how to pass the array to onDialogueInitalize
dim js as c
js = "{dialog.object}._data = " + txt + ";"
e.javascript = js
I want to run a second SQL statement to build a second array.
In the help it shows some help for building an array to populate multiple rows in the repeating section.
Here is the Javascript I would like to populate from the database.
var _d = {dialog.object}._data; this I have passed in but I would also like to pass in height, width and colour.
var wide = wide;
var high = high;
var colour = ['#FFA000', '#FFECB3', '#FFECB3', '#FFECB3', '#FFA000', '#607D8B', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#FFA000', '#607D8B', '#607D8B', '#607D8B', '#607D8B', '#607D8B', '#607D8B', '#FFECB3', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#607D8B', '#607D8B', '#FFECB3', '#FFECB3', '#607D8B', '#BDBDBD', '#607D8B', '#607D8B', '#BDBDBD', '#BDBDBD', '#FFECB3', '#FFA000', '#BDBDBD', '#607D8B', '#607D8B', '#FFA000', '#BDBDBD', '#BDBDBD', '#BDBDBD', '#607D8B', '#607D8B', '#FFECB3', '#607D8B', '#BDBDBD', '#BDBDBD', '#FFA000', '#607D8B', '#607D8B', '#607D8B',];
Comment