How to handle forms with conditional content that are divided into different pages.
5 user onboarding tips from Animal Crossing
This is NOT sponsored by animal crossing (lol) but would I say no... ??? [absolutely, I would say no. This blog is 100% unsponsored and I plan to keep it that way!] For Chanukah, Mr. Spreadsheet Whisperer and I purchased a new videogame device (the kind that you play animal crossing on!!! they don't need my help … Continue reading 5 user onboarding tips from Animal Crossing
my internet habits are changing
I'm experimenting with Notion and Reddit and some new strategies for productivity management (ugh) ... and having a great time doing it!
demystifying the INSUFFICIENT ACCESS ON CROSS REFERENCE ENTITY error in salesforce
This Reddit commenter says it all: "Insufficient access rights on cross-reference id? Could mean a permissions issue, could mean the record is deleted, could mean the id was wrong. Big pain." In this post, I detail 3 scenarios that have caused the Insufficient Access error, and how I debugged them.
I’m learning text banking!
Playing with three vendors for mass social justice SMS texting!
How to view a Lightning Web Component (lwc) in VS Code for beginners
Follow these 7 steps to view the underlying code files for an LWC on your local computer! This took me about 2 hours the first time (including troubleshooting) but it really should be much faster! Remember, if I can do it, you can do it! I've written so so so so many blog posts for … Continue reading How to view a Lightning Web Component (lwc) in VS Code for beginners
did ella baker have a rolodex? pt 2
What can today's data managers and activists learn from how Ella Baker managed contact data for SCLC and SNCC?
How to calculate *conditional* Average, Median, and Mode in Google Sheets
Google Sheets offers an =AverageIF() formula, but what if you need =ModeIF() or =MedianIf()? Here's a post on how to solve this, and why it matters for social justice orgs.
Running a competitive application process in Salesforce, Google Sheets, and FormAssembly
What tech stack should we use for complex application forms for a flagship fellowship program? Here's one description of what I set up and what we learned!
DIY Google Classroom with Zapier for Mr. Spreadsheet Whisperer
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!