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: relational database

June 12, 2022 Samantha Shain Spreadsheets, Uncategorized

volunteer management, civil rights style

A peak at several ways of organizing real data about volunteers in Mississippi during the Civil Rights Movement and how to embrace a civil-rights-movement-informed data culture in your work today!

November 3, 2021January 20, 2022 Samantha Shain Salesforce, Spreadsheets, Uncategorized

how to populate multi-select picklists in Google Sheets and Salesforce

Do you need to edit multi-select picklist values in a Google Sheet and then import them into Salesforce? I have a script to help you transcend the limitations of data validation!

August 13, 2021 Samantha Shain Uncategorized

exposition on building a civil rights outcomes tracking database

Reading about the SCLC's impact in their voter registration efforts leads to a fantasy about how to build a database for civil rights metrics. Hats off to my personal hero, Jack O'Dell.

February 4, 2021 Samantha Shain Dear Spreadsheet Whisperer

Dear Spreadsheet Whisperer: Tzedakah Tsuris

What to do when you outgrow your grassroots spreadsheet systems? Try Airtable! It's flexible, freemium, and fun to use. Oh, and this is #NotAnAd!

January 22, 2021 Samantha Shain Dear Spreadsheet Whisperer, Uncategorized

Dear Spreadsheet Whisperer: Gettin’ Schooled

In this edition of Dear Spreadsheet Whisperer, lessons about how to set up spreadsheets to ask hard questions about racial equity in schools.

January 19, 2021February 1, 2021 Samantha Shain Uncategorized

clipboard + megaphone: a new perspective on dr. king’s legacy

5 lessons from Dr. King and his entourage on movement building through problem solving and behind-the-scenes system crafting.

December 11, 2020August 29, 2021 Samantha Shain Salesforce, Uncategorized

beginner’s mind

Learning a bunch of new skills and platforms leads me to reflect on the Zen Buddhist practice of Beginner's Mind. Plus, 6 new tools I'm learning.

September 4, 2020 Samantha Shain Uncategorized

i’m learning CiviCRM!

What's out there in the land beyond Salesforce? Turns out, quite a lot! Keep reading for musings on open source technology and a PG-13 meme.

February 19, 2020 Samantha Shain Uncategorized

summary offense

What do pivot tables, the concatenate function, and Parks and Rec gifs have in common? You'll have to read this blog post to find out!

February 5, 2020February 6, 2020 Samantha Shain Salesforce, Spreadsheets, Uncategorized

facilitation/difficultation

Introducing two facilitation techniques for helping a group tackle difficult database questions, plus some personal reflection about how I'm showing up as a leader and co-conspirator.

Posts navigation

Older posts

Tags

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() forms Formulas fundraising google scripts Google Sheets if() ifna() importrange() Impostor Syndrome indirect() 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 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() xlookup() You Can Do It!
Powered by WordPress.com.
 

Loading Comments...