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: automation

July 18, 2023July 18, 2023 Samantha Shain Dear Spreadsheet Whisperer, Uncategorized

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!

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.

December 3, 2019August 29, 2021 Samantha Shain Salesforce, Uncategorized

iterative installments

Solving database problems is kind of like cooking without a recipe! In this post ... how to send donation notifications (plus installment info from recurring donations) plus a cute koala meme!

April 23, 2019 Samantha Shain Salesforce, Uncategorized

with a little help from my friends

"If it ain't broke, don't fix it." But if you have a broken system, HOW do you fix it? With help from friends of course! Three vignettes about advice, mentorship, and being connected to a community of Salesforce practitioners.

Tags

=filter() accounting address() array automation Black Lives Matter change management 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() import range() importrange() Impostor Syndrome indirect() integration interviews Justice large() LEFT() LEN() life with goldie listicle loops Mailchimp mailing list Mail Merge master's tools match() membership mentorship Metrics mindsets nationbuilder 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 Spreadsheets sprints statistics SUBSTITUTE() sumif() systems testing thought piece TRIM() Tutorial unique() unofficial sf vlookup() xappex xlookup() You Can Do It! Zapier
Powered by WordPress.com.
 

Loading Comments...