All blog posts on the front page.
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…
Imagine that you want to disable downloads for certain users based on the name of the file uploaded to Salesforce. This is totally possible thanks to the power of Apex classes. We can use the following example code inside of a new Apex class called ContentDownloadHandlerFactoryImpl: The above code essentially Read more…
Sometimes you may want to know if the DOM is ready to be manipulated. Most of the time you want to run some code only after the DOM is ready to be modified. For that reason for years we used jQuery’s ready() function or some equivalent. Now many have moved Read more…
Have you ever needed to get any user’s GitHub avatar just based on their username? If you have then you are in luck because the process is quite simple. All you need to do is place the username in the following URL: https://github.com/<REPLACE_WITH_USERNAME>.png Simple Example For instance my username is Read more…
Have you ever wanted to concatenate multiple strings to make one string and felt like the code should be shorter? So have I. For instance you may have written something like this: Of course the above code will work fine to make the message but it would be great to Read more…
Let’s say that you want the following JavaScript to run directly in a WordPress post: To execute that you can write the following into your post: The resulting of running the above in a WordPress post is this: As you may have noticed, since I am using document.write(…) to write Read more…
Today I had to get the ISO year start and the ISO year end for a given date. For instance, according to ISO8601 the week number for January 30, 2020 is 5: Year Limits By Date In Year Let’s say that we want to determine the first date of the Read more…