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!
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.
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.
When using the QUERY function in Google Sheets how can we ignore certain rows based on the criteria of some cells being blank?
How do you merge multiple columns into one column in Google Sheets using the QUERY function? In this 4 simple step-by-step process we share the formula, and teach you along the way on how component within the function works by providing commentary and photos at each change.
Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.
How do you calculate the sum of values across columns when the length of the range of those columns is dynamic? Use the INDEX function, as demonstrated in this post.
If you’ve done work from the Google App Script Editor, but need that extra development environment to help you code, then there’s a great module you can install from npm that will help you edit and push your edits from your computer to your Google App Script code in the cloud. This has the added benefit of also being able to apply git to your code if you need to push your code to your organisation’s repository.
If you use the excellent WebStorm (or any of the other great IDE’s from JetBrains) to code your SuiteScript, then you’ll want to add the SuiteScript plugin to be able to deploy your code into your NetSuite instance.
There are several excellent coding editors for SuiteScript programmers to choose from, especially if you’re not too fond of the Eclipse IDE which is the recommended tool of choice within the SuiteScript help documents. In this article I explore other editors and share my personal preference.
What happens when you get the oblique error from Excel VBA that there has been an invalid property assignment (Error 450)? Here’s how I was able to find the solution.
The Advanced Template in NetSuite throws an error on a line that contains no data in my text editor – what’s going on?
How do you force a page break in your Advanced PDF/HTML template to print content on another page?
How can you easily check if a Google Sheet cell has a value, and if it doesn’t to set a default value when assigning it to a variable in Google App Script?
