Perhaps the easiest way to assign a default value to a variable is to append the || conditional after referencing the variable. For example, after looping through an array and mapping the values to properties within an object, I needed to test … [Read more...] about Google Apps Script: Set Value Of Blank Cell
Blog
Netsuite Aggregate CASE Values
If you want to show in your Saved Search results an aggregation of your results from a CASE statement then you will want to apply the Sum aggregation type in the Group section of your saved search field. Let's illustrate this through the use of an … [Read more...] about Netsuite Aggregate CASE Values
Where Is The “IF” Statement In A Saved Search Formula?
Saved searches are a powerful tool to fetch and display data in NetSuite. However, there may be times with the display of our saved search data where we want to transform the data into something else. To display data in a format based on a … [Read more...] about Where Is The “IF” Statement In A Saved Search Formula?
Netsuite Advanced PDF: Loop Through List
When working with NetSuite's Advanced PDF/HTML Templating system it's difficult in being able to find documentation on the syntax structure for working with logic in the templates. One of the requirements I had was being able to determine whether … [Read more...] about Netsuite Advanced PDF: Loop Through List
Create Weekly Cash Flow Model With Cube Sheets
An important aspect within any business to effectively plan is the ability to monitor cash flow. Everybody in business knows "cash is king" and that "cash flow is the life blood of any business". Without having cash you can't do … [Read more...] about Create Weekly Cash Flow Model With Cube Sheets
How To Add Attributes To Images In Markdown
Markdown is a popular way of writing content and converting it to HTML. Many popular web development sites use it including StackOverflow and GitHub. In fact these very pages that you see here on this sight have been created from source documents … [Read more...] about How To Add Attributes To Images In Markdown