All blog posts on the front page.
At times you may want to set a minimum height and/or a maximum height for an Lightning Web Component Datatable. The documentation may lead you to believe that you cannot accomplish this but with some CSS3 you definitely can. If you go to the LWC Datatable docs you will see Read more…
Did you know that you can pass a function as the second parameter to JSON.parse()? Doing this causes every key/value pair to be passed to this function for further processing. You can read all about how JSON.parse() and the reviver function works here on MDN’s site. Example Reviver We can Read more…
Last year I needed a way to be able to parse JSON with comments (also known as JSONC). With that in mind I wrote the following short solution which will essentially remove JavaScript-style comments and trailing commas from the specified JSONC string and then the native JSON.parse() function will parse Read more…
Every once in a while I just need to get the stack trace of an exception as a string so that I can log the error in a separate system. Here is a quick way to do that:
It is often handy to create downloadable content on the fly using JavaScript. Sometimes you may want to do so while also encoding the contents as base64. That is where the btoa() function comes in handy. Here is an example of doing just that: As you can see by clicking Read more…
There have been so many times when I wanted to have a datetime show in UTC. I am not talking about simply looking at the time and acting as if it is in UTC. For example let’s say that I want to express the current time in UTC. This is Read more…
Recently I had to write a custom integration which would sync customers found in QuickBooks with accounts found in Salesforce. We have been using Python to write all of our custom integrations so I have been using python-quickbooks and simple-salesforce. One thing that we noticed when syncing the two datasources Read more…
On a rare occasion you may need to convert a column name from Excel or Google Sheets to a number. For example you may be seeing references to a random column such as D, G, BV, etc. but you don’t know how to represent it as a number. Instead of Read more…
Have you ever wanted to display an Excel workbook or a Word document on your website? Of course, it is possible to save files as HTML but it just doesn’t have the same feel. Fortunately Microsoft can actually come to the rescue. For example I have this sample spreadsheet that Read more…
Let’s say that similar to what we did in yesterday’s post, today you want to disable downloads based on a file name. The difference is this time you want to target the user’s profile type instead of their role. Once again, using an Apex Salesforce class makes this possible. We Read more…