Ryan

I had recently had to use a FORMULA type in a SuiteScript 2.0 search and found it as a very useful filter for list values. To use FORMULA types in …

In Microsoft Word you can control whether or not you want to see the white space characters in your document. This helps to check you haven’t incorrectly inserted a tab …

Very similar to our previous article on how to make a header row in Google Sheets, in this article we’ll show how you can lock a column in Google Sheets. …

I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I …

If 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 …

In a previous post, I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from …

A recent project hit a roadblock when I changed some code depending on the N/search module and refactored it to use N/query module. While I had some initial hassles with …

If you’re trying to debug a SuiteScript using the debug window within NetSuite and get the oblique error message: ReferenceError: Unable to find bridge [xmlApi], with parent [N/error]: ReferenceError: xmlApi …

Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real quick!

How many ways can you skin a string? In this article we will look at several ways to remove a character from a string using Python.

After moving my blog to Hugo and then back to WordPress, I knew there would be a few broken links on my website. The question I asked myself was: How …

Do you want to install multiple Wordpress blogs on the one Bitnami Wordpress instance without using the Multisite instance? Step by step instructions show you how.

How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets there is a handy little function called DATEDIF (date dif) which can do more than just find the difference in days between two dates.

If you use Dropbox to sync your forex screenshots for later viewing you might want to use a more lightweight outfit for the task. Dropbox can bloat your Windows VPS and can also cause unintended consequences if you create more folders. Why not try a better, cheaper alternative with S3.

How do you send email through Amazon SES using SMTP? If you want to see how to send email using your custom domain registered with Amazon SES this article will show how you can by configuring your SMTP settings in Gmail.

If 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 …

How do you create a secure website using a static site? In this step-by-step guide using screenshots we provide a detailed description of how you can get an S3 site served through AWS Certificate Manager and Cloudfront.

Do you want to create a simple HTML redirect page in Hugo? Here’s three simple steps showing how to do so easily in your Hugo website folder.

How do you write code in Google App Script which prevents others from being able to edit? By creating a library which is attached to a Google App Script project you can circumvent the issue of having others accidentally edit your code.

The only limitation with the ARRAY_CONSTRAIN function is it fetches from the upper-leftmost corner of the range. Here we combine the QUERY and TRANSPOSE functions to flip a range, so the ARRAY_CONSTRAIN formula can fetch from the lower-rightmost corner of a range.