nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

SuiteCloud / Customization

Child Item

Home
Groups

Child Item

Creating Dynamically Generated Charts in Portlets

Arnold Willems

Hi all,

I hope somebody can help me with some simple sample data which I can text and start with.
What I already have is a script file for the portlet which is pulling the data from a HTML file (see Below)

Where I am looking for is to make this dynamically.
I asked some input from NetSuite support but unfortunately I am not experienced enough in programming
They came back with:

1. Use nlapiLoadFile to load the file 2371746 from the file cabinet. (Done)
2. Use nlobjFile.getValue() to get the whole html content file as a string.
3. You will have to modify the string that is returned by the getValue().
Note: HTML tags will also be included in the string returned
4. Use nlapiCreateFile to create the newly modified string as an HTML file
5. Use nlapiSubmitFile to overwrite file 2371746 with the new HTML.

And to make it dynamic I need to use the below 2 SuiteAnswers
1. File APIs - Answer ID 10255
2. Executing Existing Saved Searches - Answer ID 10648

I hope sombody have already some simple code running which I may use to build my own knowledge to create nice charts.

Thanks in advance [HR][/HR]
SCRIPT

function HTMLClientPortlet(portlet, column)
{
portlet.setTitle('Charts')
var content = nlapiLoadFile(2371742).getValue() //id is the internal ID of the HTML file on the file cabinet
portlet.setHtml( content );
}

[HR][/HR]
HTML

<html>
<head>

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">

// Load the Visualization API and the piechart package.
google.load('visualization', '1.0', {'packages':['corechart']});

// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawChart);

// Callback that creates and populates a data table,
// instantiates the pie chart, passes in the data and
// draws it.
function drawChart() {

// Create the data table.
var data = new google.visualization.DataTable();
data.addColumn('string', 'Topping');
data.addColumn('number', 'Slices');
data.addRows([
['Mushrooms', 3],
['Onions', 1],
['Olives', 1],
['Zucchini', 1],
['Pepperoni', 2]
]);

// Set chart options
var options = {'title':'How Much Pizza I Ate Last Night',
'width':400,
'height':300};

// Instantiate and draw our chart, passing in some options.
var chart = new google.visualization.PieChart(document.getElementB yId('chart_div'));
chart.draw(data, options);
}
</script>
</head>

<body>

<div id="chart_div"></div>
</body>
</html>

[HR][/HR]

Find more posts tagged with

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…
Learning Lab | Cincinnati
Drive better outcomes with AI built into NetSuite Next The Lytle Park Hotel, Autograph Collection,311 Pike St, Cincinnati, OH 45202 Join NetSuite experts for a free half-day event where you'll learn how to use Al, automation, and our latest product innovations to optimize NetSuite for your business. At this event, you’ll:…
Inside the Suite | Cincinnati
Take NetSuite Next for a hands-on test drive The Lytle Park Hotel, Autograph Collection, 311 Pike St, Cincinnati, OH 45202 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next—the next evolution of NetSuite that brings AI…

More events