Bienvenue! Welcome!
My goal is to help you work faster.
I must speak and teach until I hear 10 people say, "That thing you taught me? I used it! And it saved me time!"
(Ahem ... although maybe blogging slower than I'd hoped. Ugh, coders' repetitive stress injury.)
So check out the tutorials. Play with code. Tell me about your triumphs.
Jitterbit Hosted APIs: Hello World tutorials
02 Apr 2020
Jitterbit’s ETL (“Extract, Transform, Load”) platform allows you to “borrow” their web servers and use them to put URLs on the internet as small “API” endpoints where the back end of those “endpoints” is some sort of data-processing Jitterbit operation you’ve built.
Continue ReadingWhat is #FlattenTheCurve? Why is everything cancelled?
13 Mar 2020
If you work in technology, you can relate to the feeling of being invisible specifically because you go above and beyond the call of duty, right?
Continue ReadingNetlify CMS Jekyll Minimum Viable Build
21 Feb 2020
I’m trying to figure out if a friend currently on Wordpress could ever enjoy using a static page builder accompanied by a CMS, or if they just really need the comfort of knowing they can use Wordpress Visual Composer / Squarespace / Wix to move things around their web pages at will. Netlify’s free tier (thank you!!) is going to be really helpful in letting me set up a prototype for them to test drive.
Continue ReadingDoor Prize: Excel VBA code for turning your ex-PMI into principal payments
13 Feb 2020
Excited to see, with Excel, when your mortgage would be free of PMI? Let’s add a little more code showing how much you’d save if you kept paying your old “PMI bill” as “extra principal” payments every month for the rest of your loan.
Continue ReadingExcel VBA code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)
13 Feb 2020
A friend is trying to come up with a clever way to use Excel to figure out in what month a given mortgage’s principal would have dropped below 80% of the purchase price of the home (at which point they would know longer pay a supplemental fee known as private morgtage insurance, a.k.a. PMI). I didn’t think Excel could do it, but it can.
Continue ReadingPython NumPy code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)
12 Feb 2020
A friend is trying to come up with a clever way to use Excel CUMIPMT / CUMPRINC to figure out in what month a given mortgage’s principal would have dropped below 80% of the purchase price of the home (at which point they would know longer pay a supplemental fee known as private morgtage insurance, a.k.a. PMI).
Salesforce Classic slow in Chrome? Use Firefox until Spring '20
12 Feb 2020
Are your Salesforce “Classic” record pages loading slowly in Chrome, only to eventually load with broken content?
Continue ReadingTutorial: Flow External Services for Salesforce Admins
30 Jan 2020
Who remembers my #GIFSquad-friendly Salesforce Flow project from last summer, teaching Apex-Defined Data Types? I just learned that you can build the same project in Flow without writing any Apex code!
Continue ReadingSalesforce Spring '20 Community Guest User Apocalypse
08 Jan 2020
All right … a nuisance, not an apocalypse. Heads up: There are some things changing with Guest User access Salesforce Communities in the Spring ‘20 release that can break your business’s customer experience if you’re not on top of them.
Continue ReadingFlow Invocable Apex with Any Salesforce Object Type
02 Jan 2020
In case you missed it (hat tip to the “Salesforce Discord Abridged Release Notes” on my part), when working with a developer to build out snippets of “Invocable Apex” (kind of like sub-flows, but written in code) to run from your Salesforce flows, as of Spring ‘20 you can make them work on any Salesforce object.
Continue Reading