17 practical guides and examples.
How do you stop a long running map/reduce script in SuiteScript? There are two ways to stop the running of a map/reduce script: cancel the script in the Map/Reduce Script Status area, or make the running Map/Reduce script inactive . Here’s how each method works. Cancel Map/Reduce Script You might be able to stop a map/reduce script running in SuiteScript if there are other scripts running currently and your newly…
Read guideI recently had an exercise where I needed to extract all the text from an OmniGraffle document. The task at hand was to check a beautifully designed organisation chart against a spreadsheet list of staff. Doing this task manually was going to take far too long. There had to be a better way of extracting the information I needed from the document: and thankfully there was! OmniGraffle have a new…
Read guideIf you want to know how many words your WordPress articles have you can open up each post individually and by clicking on the top left-hand corner’s information icon it will display the number of words. For example, when I completed this post I was curious as to the quantity of words I wrote and upon clicking the information icon within that post was informed of the following data: Wordpress…
Read guideWARNING – The content contained in this article no longer works per Bitnami’s deprecation of modules – their announcement is here if you want to find out more. I found it tedious trying to change all of my websites (6 in total) to Amazon’s Lightsail Bitnami WordPress box. There are many instructions on how to do this using the WordPress Multisite feature, but not if you actually need individual WordPress…
Read guideI was once connecting my Dropbox account to a Windows VPS to try and sync files from the server to my computer. While I ran into a few problems initially with probably the biggest problem being NOT selecting which folders TO sync and as a result I fried a few Windows boxes. And the software doing the pushing needs to be lightweight. Store your images on Amazon’s S3 It is…
Read guideIf you have a custom domain and want to be able to send email through your personal Gmail account without having to register for a Business Gmail account then here’s how you can do it using Amazon’s SES. Prerequisite If you haven’t done so already you will need to set up your custom domain in Amazon’s SES. Here is a detailed step-by-step guide on how to create your email accounts…
Read guideIf you’ve created your own custom domain and want to be able to create custom email accounts, but don’t want to register for a Gmail Business account due to cost then there’s an easy way to manage an email server within Amazon called Simple Email Service (SES). In this article you will learn how to register a domain within SES ready for receiving email, then you will see how we…
Read guideIf you’ve created a static site using the wonderful Hugo package and need to create some simple redirect HTML web pages then you’ll need to do the following: Create your HTML template and place it in your main layout folder. Create an archetype template file. Create a file using the archetype and fill in all the meta header information. Publish your page. Creating a simple redirect layout in Hugo is…
Read guideIn our previous post on clasp and Google App Script code we discovered how we can pull code down locally, do our edits and then push it back to Google Apps. This is great when we’re working on code on the back-end of Google Sheets, or Google Forms, or any of the other great Google Apps. However, what do you do when you want to write code, but you don’t…
Read guideWhen working with Advanced Templates, and the FreeMarker syntax in NetSuite there can be some oblique errors which make it difficult to diagnose. To help diagnose any such errors, I highly recommend writing your templates in a code editor. I personally prefer the editors from JetBrains as they package everything you need in one nice editor. To effectively write FreeMarker templates with syntax highlighting and auto-completion you will need the…
Read guideIf 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 example. For example, let us assume I want to find out the BALANCE of an Account on what has been charged for our customers…
Read guideSaved 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 condition we need to use the Formula fields in the Result tab. Within the Formula field for us to apply a condition we can use…
Read guideWhen 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 the quantity ordered on an item has the same quantity ordered as the previous item. This required the ability to determine that the item being iterated through with the list function…
Read guideAn 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 anything. Being able to monitor a weekly cash flow statement in Adaptive Planning is a little cumbersome, due to its standard monthly time-frame structure, however, creating a cash flow statement…
Read guideWhen working with formulas in your model sheets in Adaptive Planning you may come across an oblique error which doesn’t initially appear to make sense, but once you understand what it is, it becomes fairly obvious what it means (like most errors!). Problem So what is the error and how do you fix it? Have you been writing an if statement or two in your formula? The reason for the…
Read guideWhen working with Adaptive Planning, especially for the first time as I have recently done, it is a little difficult understanding the time functions and what they return when they are used within time-series sheets (such as the Standard, Cube or Calculated Accounts in Modelled Sheets). If you’re looking for a brief understanding on what each of these functions return here’s a little sample on what they return. Assumptions about…
Read guideIf you open up certain types of Microsoft Word documents you will find you’re unable to insert an equation as the icon used to insert equations into your document cannot be clicked and looks greyed out. Something that looks a little like this: Equation Editor icon in Microsoft Word 2011 for Mac greyed out Thankfully the solution is quite simple. To get around this problem simply save the Word document…
Read guide