Français
Presentations About Resources

Salesforce, Python, SQL, & other ways to put your data where you need it -- a bilingual blog in English & French

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.

Excel VBA code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)

13 Feb 2020 🔖 excel 💬 EN

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 Reading

Python NumPy code to compute when a mortgage will be free of PMI (Private Mortgage Insurance)

12 Feb 2020 🔖 python 💬 EN

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).

Continue Reading

Salesforce Classic slow in Chrome? Use Firefox until Spring '20

12 Feb 2020 🔖 salesforce tips 💬 EN

Are your Salesforce “Classic” record pages loading slowly in Chrome, only to eventually load with broken content?

Continue Reading

Tutorial: Flow External Services for Salesforce Admins

30 Jan 2020 🔖 tutorials api salesforce flow integration architecture 💬 EN

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 Reading

Salesforce Spring '20 Community Guest User Apocalypse

08 Jan 2020 🔖 salesforce security architecture 💬 EN

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 Reading