Published on May 30, 2020.

One of my new NetSuite clients is also a big fan of Airtable, and I'm in the process of working on some interesting integrations between those two platforms. This client is also in the process of rolling out a new mobile application, and last week they asked if I knew of any quick, easy, and inexpensive ways for them to track that project's bugs and issues. There are plenty of good apps available for this type of thing, and I started to do some research for them.

I then realized that my client already had a great solution for this: Airtable. Their employees are familiar with it. It's easy to use. It's inexpensive. And best of all, Airtable has a nice Bug Tracker template that could be used to jumpstart the project.

Here's a screen shot of the Airtable Bug Tracker template.

It then occurred to me that I could easily embed the Airtable base within my client's NetSuite instance, making it convenient for their users to work with the base - even for users that don't have direct access to the base itself.

To embed the Airtable base in NetSuite, I simply created a Portlet SuiteScript and had it render an embedded view.

Here's a screen shot of an Airtable base embedded in NetSuite using a portlet.

Here's the script.

/**
* @NApiVersion 2.x
* @NScriptType Portlet
* @NModuleScope SameAccount
*/

define( [], main );

function main() {
	
    return {
        render: renderContent
    }

}

function renderContent( params ) {

	params.portlet.title = 'Bug Tracker';

	var content = '<iframe class="airtable-embed" src="https://airtable.com/embed/shrqbTw127Glq8Vkb?backgroundColor=yellow&viewControls=on" frameborder="0" onmousewheel="" width="100%" height="533" style="background: transparent; border: 1px solid #ccc;"></iframe>';
	
	params.portlet.html = content;

}

You can easily modify the script to embed your own Airtable view. Simply change the title and replace the "content" value with the embed code provided by Airtable.

This is one of those projects where the solution involved very little code, and we were able to go from "concept" to "live" in no time at all.