When Mr. Spreadsheet Whisperer is having trouble copying Google Files into folders for each camper, what should he do? Use automation to process repetitive, tedious tasks!
Everything I learned the hard way about setting up Conga Composer in a Salesforce Experience Site (fka Community Cloud).
How to create a "New Contact" form for staff and volunteers to fill out, while checking for duplicates!
I offer a post that's not about Salesforce, it's not about nonprofits, it's not even about spreadsheets (well, in a way it sort of is... but then again EVERYTHING is). It's about crafting, and coping, and playing, even in the worst of times.
I used formulas, text variables, collection variables, loops, and assignments in Salesforce Flow to compare lists of Contacts and Contact Roles and create new Contact Roles as needed. Read further for the first attempt that didn't work... and how I fixed it!
Some of observations and tips from my first few days trying Mastodon.
While analyzing survey data, I encountered 3 new spreadsheet capabilities in Excel and Google Sheets!
Wondering how to add some flair to your (Screen) Flows? I have just the recipes you need! Thanks to Sharad and the team at UnofficialSF for making Custom Header, the component that inspired this post!
A form-building "dead end" turns into a triumph thanks to community collaboration. PLUS (see what I did there?) learn how to build Rich Text Forms in Salesforce Flow with my handy tutorial.
What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!