A Linchpin's Journey

Have you ever had times when you were so passionate about something so you share it to the world, only to get rejected? You probably have. I know I have. Heck, this whole journey is about my response to a rejection. I know it's difficult to separate the emotions and self-doubt that comes with rejection. But doing so is essential to progress. In one of the podcasts I've seen, Seth Godin tells about how he was rejected over 800 times to publish one book. People literally took the effort to write a stamped letter and mail it, just to notify him of the rejection. His writing is his passion, and perhaps his book, his baby. So how does he separate himself from the rejection, and get things done? He gave an illustration on eighteen locks. Each lock has it's own key and if the locksmith is unable to open one with the first key, then he tries again with the next key. It doesn't make the locksmith feel bad whenever a key fails to open a lock. This is something I guess we can keep...

Using a Saved Search to get a week number of a date can be tricky. A day like January 5, 2022 could return week 1, but you expect it to be in week 2. So why could that be? There are a few TO_CHAR date formats to remember when getting the week number. Week of Year (WW) - Defines the first week as the first 7 days of the year. ISO Week of Year (IW) - Defines the first week as the first Monday, plus the next 6 days. Everything before the first Monday is considered either week 52 or 53 of the previous year. ISO Week of Year (IY) - Used in relation to 'IW', for better identification of what year the ISO week refers to. For most purposes, you would want to use the ISO week, plus the ISO year. If that is the case, you can use the following formula: to_char({custrecord12},'IW - IYYY') Be sure to replace '{custrecord12}' with the appropriate date value. Below are examples of how results of each date format differ. Results tab: Search Results: An Interesting Case I once ...

Below is a list of macros that I've created to help automate and/or manage tasks in the actual workplace. Looking back, I'm proud of the work I've done, as these projects have spared so many people, myself included, from unnecessary hours of labor. I will not make these macros available for download. Knowledge Management Tool (NetSuite) Consolidated drill down results from a NetSuite Solution Search across different teams. Made assigning and tracking solution reviews a lot easier. Had a feature that isolated solutions for each assignee into individual worksheets. This was especially useful since each team would have around 400-800 solutions to manage and distribute among so many knowledge management contributors. Also updated this tool so it could be compatible to reporting from a web tool. PL/SQL Query Generator (DXC) Allowed for generating long PL/SQL queries that could be used for manipulating data from SQL tables, then gathering summarized stats to compare old and ne...

Date Today in Freemarker If you want to add today's date in your NetSuite email templates, you can use the following freemarker tags: ${.now} - returns today's date in long format ${.now?date} - returns today's date in short format See more built-ins for date formats here . Arithmetic Functions If you want to perform arithmetic functions with dates, you will have to first use the long built-in to convert dates to milliseconds. Once converted you can add and multiply milliseconds, then convert the value back using any of the following built-ins: number_to_date number_to_datetime Example: Goal: To add 10 days to current date. Formula: ${((.now?date)?long + 10 * 1000 * 60 * 60 * 24)?number_to_datetime} Entering the following in the text editor will allow you to compare today's date and the formula's result. Result:

After reading some pages from Linchpin , I have opened my eyes to getting more engaged in looking for a job that will allow me to create and invent new ways to do things. Along with that inevitably came an update to my resume. Here is the updated version. Thank you  Canva . Resume (PDF) To the employers I am applying for: I've gone through a lot of interviews by now. Here's a quick FAQ on my resume. Why did you stop attending college? I was a Mormon missionary from 2009-2011. There I was given special assignments wherein I learned life skills at the early age of 19. Such skills included negotiation with property owners, event organization (logistics and preparation), and developing macros for automating office tasks. Why did you pursue a career in IT? I started programming HTML when I was 10 years old. I fell in love with coding. I had some different interests as I grew older, so perhaps my course would deviate from IT, but deep down I still really loved to make code. I eve...