A Linchpin's Journey

A customer asked for help on their opportunity search. The search should not contain duplicate rows of opportunities. But the search should also contain joint activity fields. The challenge comes with the fact that opportunities can have multiple activities attached to them. Therefore in this one-to-many relationship, there would naturally be duplicate rows of opportunities. That is unless of course we know how to use ns_concat . The below formula is an example of how to achieve the customer's goal: case when ns_concat({activity.title}) is not null then '<table border =1>'||REPLACE(ns_concat(distinct '<tr><td>'||{activity.title}||'</td><td>' ||{activity.date}||'</td></tr>'),',','')||'</table>' end To briefly explain, ns_concat converts an array into a string. So essentially, whatever is inside the ns_concat tags will be looped, until each of the elements in the array have been ex...

The first time I've used ChatGPT was around the last week of March. I asked it to make a hangman game that I could embed into PowerPoint. As I expected, it created a VBA code for me, and I knew that it was a template. Now that I got that done, I went ahead and created the objects on a PowerPoint presentation. I entered the code provided to me, and tweaked it a bit. I added variables, and after about an hour, I had a working hangman game, which I could modify. I imagine it would have taken me possibly six times as long to finish the game without ChatGPT's code. Overall, it was an enjoyable experience. The code was easy to read, and easy to modify. While you do need to know some basic coding knowledge to complete the code it provides, I can see how valuable it can be if you want to learn how to code. I tried having ChatGPT create SuiteScript code, which looked fairly decent. Getting a reservation to SuiteScript training is pretty difficult, even if you are a NetSuite employee. I...

If you missed part one, check it out here .   Strange I’m so sorry about you and your friends not getting into college. But if they rejected you, and you tried to convince them to reconsider, there’s nothing else you can do.   Peter When you say “convince them,” you mean like I could have called them?   Strange Yeah.   Peter I can do that?   Strange You haven’t called the--    Peter Well, I mean, I got their letter and I assumed that that was--    Strange I’m sorry, are you telling me that you didn’t even think to plead your case with them first before you asked me to brainwash the entire world?!  I have received A LOT of rejection throughout all the applications to other companies I've submitted. Perhaps I have somewhat become  lazy with how I apply. I mean I just submit my applications, then I forget that I ever even applied. I don't follow up if hiring managers don't email me back. Perhaps to me, it's just ...

I'm ready for a NetSuite Administrator role. After a recent interview, I was evaluated to have sufficient knowledge to become a NetSuite Administrator. Guess who interviewed me. It's none other than ChatGPT! It asked me the usual things interviewers have asked me before -- about my experience, about projects, about my knowledge in access, customization, and integration. So if you're looking for a NetSuite Administrator, you trust ChatGPT, and it trusts me to be fit for the role, I'm your guy! That aside, it was quite interesting to talk to a reasonable, sensible, and frame-able chatbot. Recently, I also watched a video on how to make the program more tailored to your needs. It's amazing how far technology has come. This is a game changer that is going to disrupt the industry. Learning how to code in any language has become exponentially easier than it was before, thanks to this technology. I could say hiring managers will eventually stop worrying about coding experi...