Skip to content

The Data are Alright

  • Home
  • Blog
    • Spreadsheets
    • Civil Writes
    • Salesforce
    • Conga Composer
  • Dear Spreadsheet Whisperer
  • Consulting services
  • About
    • Testimonials
    • Link tree
    • Contact me

Tag: You Can Do It!

November 27, 2022November 27, 2022 Samantha Shain Uncategorized

i’m learning Mastodon!

Some of observations and tips from my first few days trying Mastodon.

October 25, 2022October 25, 2022 Samantha Shain Uncategorized

3 new-to-me spreadsheet capabilities (plus a bonus)

While analyzing survey data, I encountered 3 new spreadsheet capabilities in Excel and Google Sheets!

October 2, 2022October 3, 2022 Samantha Shain Salesforce, Uncategorized

UnofficialSF: 8 Recipes for Custom Header Screen Flow Component

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!

July 29, 2022July 29, 2022 Samantha Shain Uncategorized

Rendering Salesforce Flow-based forms with Rich Text: an open source collaboration triumph

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.

April 26, 2022April 26, 2022 Samantha Shain Dear Spreadsheet Whisperer, Spreadsheets

Dear Spreadsheet Whisperer: Or Else?

What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!

April 5, 2022April 5, 2022 Samantha Shain Uncategorized

nice to meet you, apsona 💃

Read on in this blog post to see key lessons I've learned in my first month of using Apsona, as illustrated by GIFs from Schitt's Creek.

March 1, 2022March 1, 2022 Samantha Shain Salesforce

case study: how to move a Process Builder to Flow [Salesforce]

During the month of February, I worked with a consultant to move just ONE process builder over to Flow, and it was an ADVENTURE! In this blog post, I will write about some of the challenges, avoided (!) pitfalls, learnings, and maybe even some advice as we, collectively, face this huge change in the Salesforce admin toolbox.

February 14, 2022February 14, 2022 Samantha Shain Salesforce

snowfakery progress!

Snowfakery has come a long way, and so have my skills! Here are some useful Snowfakery and CumulusCI commands/arguments and how to get started generating data.

February 6, 2022 Samantha Shain Uncategorized

prepping synagogue data – and – introducing Jenks natural breaks!

What is the best way to divide fundraising totals into categories and create charts and graphs? Enter, Jenks Natural Breaks and some spreadsheet magic!

January 17, 2022January 17, 2022 Samantha Shain Salesforce, Spreadsheets, Uncategorized

How to make Validation Rules into *Validating* Rules

The database world is replete with options for "validating" data, but there is a huge missing link in our field, which for me boils down to VALIDATING HUMANS.

Posts navigation

Older posts
Newer posts

Tags

=filter() accounting address() ai archives array automation Black Lives Matter change management civicrm civil rights movement Civil Writes code conditional formatting conferences Conga Composer consulting counta() countif() crafting CRM cumulusci Data database data cleaning data culture data validation Data visualization de-dupe Dear Spreadsheet Whisperer EQAT error messages Excel facilitation feedback feminism filter() form assembly forms Formulas fundraising Google Drive google scripts Google Sheets grantmaking if() ifna() importrange() import range() Impostor Syndrome indirect() integration interviews Justice large() LEFT() LEN() life with goldie listicle loops Mailchimp mailing list Mail Merge master's tools mastodon match() membership mentorship Metrics mindsets nationbuilder nonprofit npsp openrefine open source phonebanking Pivot Tables poem PROPER() Public Health puns queer query() racial equity recruitment relational database reporting reproductive justice REPT() resource roundup RIGHT() rows() Salesforce salesforce flow search() self care SEO Single Source of Truth snowfakery social justice spreadsheet Spreadsheets sprints statistics SUBSTITUTE() sumif() systems testing thought piece training TRIM() Tutorial unique() unofficial sf user adoption video games vlookup() xappex xlookup() You Can Do It! Zapier
Powered by WordPress.com.
Loading Comments...