The Day After Christmas 2015 – Part 2

This post is the second in a series I’m writing about our tornado experience. You can read the first post here.

It sounds like a freight train. I’ve heard it described like that on TV, but really never thought too hard about it. But they are all right. It sounds EXACTLY like a freight train bearing down on you at over 200 mph.

The noise built quickly into a roar accompanying the sound of the tornado sirens outside.

Within a matter of seconds, multiple things happened:

  • The power went out
  • The window in our kitchen shattered sending pieces of broken glass under the door into the bathroom
  • The sound became something of an explosion – like a bomb going off
  • The house shuddered and seemed to sway
  • As quickly as the wind threw shattered glass under the door, the wind was gone, almost an absence of air, throwing off the air pressure and forcing me to pop my ears

And then there was silence.

This all literally happened in a matter of seconds from the time we first heard the freight train roar.

I cracked open the bathroom door and closed it again. I turned to my husband and said, “Do you think we are in the eye?” (I laugh at that now – not like this was a hurricane or anything!)

I called my sister (at this point we could still get through) and told her that we were ok, but that we definitely had a window broken but not sure what other damage. I said where we were just in case so they would know.

My kids are all crying and Don and I are working on pure adrenaline. We told them to stay put and I opened the bathroom door. It was pitch black in the house but I could see the window was blown in and the kitchen table had been moved, but couldn’t make much else out.

Don went toward the back of the house and I went to the front door.

The whole time I’m thinking, ok, things aren’t bad – a broken window and a bit of a scare. Maybe we’ll be without power for a while, but we are good.

Then I opened the front door.

This part is still a little surreal to me. In a glance I can see that all is not ok. There is debris piled up in our yard and I can see my mattress. My mattress from our upstairs bedroom. My mattress from our upstairs bedroom in the front yard.

According to my children I exclaimed, “Our house is gone!” I don’t really remember that part. I remember hearing my husband say the kids rooms are not there anymore. My daughter is crying hysterically and the boys are kind of in shock. I have to yell at them to stay in the bathroom.

I gaze out the front door and see my neighbors slowly emerging from their damaged homes as well. It is pitch black and eerily quiet and the landscape looks like a war zone. We are yelling to each other, “Are you guys ok? Is everyone ok?” But I can’t get past the debris in the front safely since there are walls hanging over the eaves to the porch.

I tried calling my sister back. After several failed calls, I finally got through. I told her we’d been hit and the second floor was gone. She told me that my brother-in-law was on his way toward us, and to gather up what we need. She even reminded me to grab our medication! So I run through the house, grab my work laptop, my purse, and dump everything important I can think of into it. I hand it in to my daughter and head back to peer out the front door.

The next door neighbor is in her front yard and says her house is ok (she lives in a one-story and appeared to only sustain some roof damage) and if I wanted to bring the kids over I could.

So we gathered the kids up and walked them out the back, where there is no longer a fenced in yard, and around the side of the house to the house next door where they could sit safely with the neighbors.

As we are leaving the house my daughter asks about Spike, our dog, who we had put up in the laundry room. Not knowing how the laundry room fared, I wasn’t about to open that door and check with the kids there. I told her he was safer in there since there was glass everywhere outside and that we’d come back for him.

We got the kids settled and went back outside. To do what, I wasn’t sure. At this point we are all kind of just milling around – there is so much debris it is difficult to navigate outside, but luckily everyone in our immediate block is accounted for and safe.House that night

Don and a neighbor shut off the gas to the house (it was hissing pretty loudly), he helps neighbors do the same and checks on others, then he goes in to try and save some things in the house. There is no way to secure the house right now, what with windows broken and one of the back doors blown in, breaking the door frame.

I’m sort of just standing there. Looking around. What exactly am I supposed to do? I didn’t take a class on this. There are no instructions. I’m good with instructions. I’m not sure I’m adult enough to handle this.

Are we supposed to check in with someone? Wait for emergency personnel? What are the proper procedures?

We could hear sirens, but none came to our street. People were moving debris and cars were starting to pull through. Most were people slowly driving through seeing if anyone needed help. A few were slowly driving through holding their cell phones out the window. Filming our moments of tragedy. Videoing our wrecked homes and recording us as we cried and stared at that wreckage.

Texts and calls are coming through sporadically. Apparently my brother-in-law got  a few miles away but the debris was too thick for him to come any farther. A friend of theirs was trying a different direction and was going to come and find us.

I go back and forth between checking on the kids at the neighbor’s house and standing in our front yard. I’m nervous for Don as he pokes around the house since it is hard to tell the extent of the damage in the pitch black, but he is intent on grabbing some of the electronics and gaming systems for the boys.

We continue on like this for a few hours. Still no flashing lights of emergency vehicles or anyone official looking. My phone is now dead, my daughter keeps coming outside just to be near me and my boys have been mute for as long as I can ever recall.

There are people everywhere it seems, asking, “Is this your house? Were you in there? Is everyone ok?” People start offering water and to help. Help? Help with what? I don’t even know where to begin.

At this point it is around 10pm, when that friend of my sister comes walking up to the house. He had to park almost a mile away. He was there to help get us out of the neighborhood and to my sister’s house. Here was a rock we could lean on for the moment.

Stay tuned for the next part of the story...getting the kids, dog and filet mignon out of the neighborhood…

Posted in Everything Else | Tagged , , , , | 6 Comments

The Day After Christmas 2015

This post begins the first in a series I’ll be writing about our tornado experience. 

The day after Christmas. This day is traditionally a pretty laid back day in our household. It’s a day to sleep in, tidy up around the house and mess around with all the new gadgets and goodies everyone got from Santa!

We woke up that morning to an unseasonably warm day. Temps were predicted to be in the mid-70s and the air was thick and heavy with moisture.

The weather forecast predicted storms to roll through so we postponed travel to see some relatives to avoid driving through the storm front.

The day unfurled as expected. Pretty quiet day with the kids playing with their new toys and Don (my husband) doing a little grocery shopping. I stayed in my PJs all day long – don’t get to do that too often!

My husband loves to cook and had found a new fried chicken recipe to make that evening. He was also SO excited to return from the grocery store with a special find. We love Filet Mignon but don’t eat it often due to the price. He had found a whole uncut filet for a steal – $120 and he could slice it into steaks and freeze them for future meals! We don’t typically spend that kind of money on food but decided to splurge! Little did we know within hours our house would lose power for the foreseeable future!

Anywhoo – having grown up in a suburb of Wichita Falls, TX, devastated by a large tornado in 1979, I’ve always been wary and watchful when they are predicted. So as the afternoon progressed I turned on the local news station to stay aware of the alerts.

The boys were both playing video games and my daughter was practicing on the new digital piano we got as a family gift. Don was frying up chicken in the kitchen and I was sorting and organizing paperwork.

As the front rolled through after the 6 o’clock hour, I watched on TV as tornado warnings rolled up through Dallas proper – west of our location. Based on the radar it was going to roll past us, but I have lots of friends and coworkers in that area so I was watching it all raptly.

Sometime around 6:30ish, I hear that there is another ‘area of concern’ and looked up to see the weatherman circle an area South of us, heading our direction. I alerted the family that it was time to just move into our downstairs half bath – it is in the center of the house with no windows, so is our designated safe room. We turned off the electronics in the game room, moved a comforter in the bathroom and the kids gathered in there. I brought our dog, Spike, into the laundry room which is also a secure space.

I’m listening to the TV all the while and hear that there is rotation and a ‘possible tornado’ near I-30 and Bobtown – about 6 miles driving distance from our house. Very close and per the reports, heading our direction.

I went into the bathroom with the kids and hollered at my husband to come on already! He wanted to finish frying up the last batch of chicken! Then we heard a confirmed tornado on the ground at I-30 and the George Bush Turnpike. It was considerably closer! My husband came into the bathroom and we left the door cracked open a few inches to listen to the news. I posted a photo of all of us hunkered down on twitter:

ShelterTweet

We still had the door open to listen to the TV and hear the news anchor say that everyone in the path of the storm should be sheltering and then there was a noise.

My daughter asked, “What is that noise?” and my husband replied, “Sounds like the rain is hitting”.

I looked at my husband, said, “That’s not rain!”, pushed the door closed and continued, “That’s the train! Come here!” and hugged the family tight as the roar of the freight train grew louder.

Stay tuned for the next part of the story…

Posted in Everything Else | Tagged , , , , | 8 Comments

Re-Creating (linkable) Record Name Fields for Custom Use

Requirement: Standardize Opportunity Naming convention using a concatenation of Account Code plus Opportunity Number plus ‘Custom Opp Name’. This will standardize naming conventions across all corporate tools and assist in document searching.

Example:

  • Account: ABC Genius Tech Consulting
  • Account Code: ABCGTC
  • Number of Opportunities: 4 total
  • New Opportunity: Lots of Really Cool Widgets
  • So when this new Opp is created, the new Custom NAME should display:
    • ABCGTC-5-Lots of Really Cool Widgets 
      • (and be a clickable link to the Opportunity record)

Caveats:

  • Users still need to be able to edit the Standard Opportunity Name field but we don’t want people editing the abbreviation or number
  • Should replace the Standard Opp Name field in list views and reports with new Concatenated Name
  • New field needs to still be a link to record so users can click through in reports and list views
  • Opportunity Number should be sequential to the Account (Account A has Opps 1,2,3,etc; Account B has Opps 1,2,3,etc.)

Solution:

  1. On Accounts:
    • Create Account Code text field on account records. Set to require unique values. Account_Code__c
    • Load in Account Codes
    • Create Rollup Summary field on account records to Count the Number of Opportunities for Opp Numbering
  2. On Opportunities
    • Create Opportunity Number field OppNum__c
    • Create Process that fires every time an Opportunity is created to take the Count of Opportunities from the related Account, add 1 and stamp the new Opportunity Number field
    • Create formula field to setup your new NAME field
      • Display Text
      • Create your Concatenated Name:
        • Account.Account_Code__c & “–” & Text(OppNum__c) & “–” & Name
      • Encase the above with the Hyperlink function to display as a link

Replace the Opportunity Name field with your new NAME field in reports and list views. Another cool bonus is the link always opens in a new tab so you don’t lose your place on your report or list view!

With this new field, our Reps can easily update the Opportunity Name as usual, but our Analytics maintain the structure using the Account Code and Numbering System. We made a decision upon turning this on to let all existing Opportunity records show 0 in the new OppNum__c field with new Opportunities showing the actual count. At some point in the future we may go back and number those old opps, but that’s for another day!

Posted in Salesforce Stuff | Tagged , , | Leave a comment

Celebrating 100 Blog Posts!

I’ve been blogging since 2009 on this site, but really started posting regularly last year. This blog began as a way to talk about parenting, volunteering, being a working mom, and ADHD. I use a lot of sarcastic wit, humor and always try to speak plainly. The past year I’ve focused mainly on the ‘working mom’ aspect and my role as a Salesforce Administrator. I still weave posts about my kids in, and throw in the occasional parody song or Haiku. This blog is really just a great therapeutic way for me to verbalize what is important in my life. If I make you laugh, awesome! If I help you learn something, fantastic! If I make you think about something you wouldn’t have otherwise, perfect!

For my 100th Blog Post, I’ve spent some time deciding what to post. Stats about how my blog has evolved over the years? Just a simple giant 100 image with confetti? Nah! I thought I would take this time to put into writing 100 super awesome things to celebrate! So here you go:

100

  1. Family (this ones a given)
  2. A supportive spouse and family
  3. The Drama-teen
  4. The Middleton
  5. The Youngest
  6. Friends
  7. Virtual Friends who feel like family
  8. Coffee
  9. Music
  10. People who love music as much as you
  11. An awesome career
  12. The Salesforce Community
  13. The ability to succeed as a Woman in Tech
  14. The interwebs and all the awesome things you can learn!
  15. Super-awesome opportunities for my kids to achieve great things
  16. Audible audiobooks
  17. Shiner
  18. Trailhead! Trailhead! Trailhead!
  19. Diversity
  20. The growth of Apple and how it inspired me at a young age
  21. Awesome Admins around the world
  22. ADHD/ADD (yes, it’s something to embrace!)
  23. Giving Back!
  24. Karaoke
  25. The Salesforce MVP Program and Community
  26. RAD Women
  27. Bosses that believed in me and pushed me
  28. Weird Al Yankovich
  29. Corn Nuts
  30. Podcasting
  31. Dreamforce
  32. Salesforce LIGHTNING!
  33. Contagious excitement and the will to help others
  34. School of Rock
  35. Small towns
  36. Big Cities
  37. Diverse Cultures in our family
  38. Girly Geeks
  39. Nerdforce listeners
  40. Crazy Texas weather
  41. PTA
  42. Booster Clubs
  43. Education – it might not always be perfect but look at what our kids learn!
  44. ADHD/ADD Medication (yup – I celebrate it!)
  45. The ability to make up our own minds
  46. Whataburger
  47. Lootcrate
  48. Amazon Prime
  49. Teachers who care
  50. Sports teams and rivalries
  51. Texas High School Homecoming Mums
  52. Salesforce Apps
  53. FinancialForce Community
  54. Halloween Costumes & Decorating
  55. Painting theater sets
  56. Musical Theatre
  57. Ready Player One
  58. The Tenth Doctor
  59. Apple Watch (you will be mine one day!)
  60. Mini Coopers
  61. Starbucks
  62. Process Builder!!!! Clicks not Code!
  63. Buying a Home
  64. Family that comes to visit
  65. Facebook – staying in touch with old friends and distant family
  66. Les Mis Soundtrack
  67. Cruise Ship Vacations
  68. Apex & the Limits
  69. Speaking at Dreamforce
  70. After school Coding Clubs
  71. 80’s Movie References
  72. Back to the Future Day!
  73. Formula Fields and Validations
  74. Custom Javascript buttons
  75. Finding other geeks and nerds who think just like you
  76. Working from home
  77. 20th High School Reunions
  78. The Helping Hand of the Community
  79. Dollar Fifty earbuds
  80. Trailhead Community Badges & Twitter Contests
  81. Blog Readers!
  82. Twitter Peeps
  83. Acrylic paints and empty canvases
  84. Hugs
  85. Finally meeting someone in real life you’ve spoken to for ages!
  86. A world where we can blog about whatever we want and sometimes people read it!
  87. Technology!
  88. Hoverboards
  89. Old School Rap music
  90. Crockpot Meals
  91. vlookup formulas in Excel
  92. Swimming Pools
  93. Open Minds
  94. Grilled Cheese Sandwiches
  95. Memories that last
  96. That one time when your kid said, “You were right mom”
  97. Sleepless nights as a parent
  98. Holidays with family
  99. Getting older
  100. Being instilled with a drive to make a difference somehow!

If you got through the whole list – way to go! If you skimmed, that’s ok too!  What would you add to the list? What super awesome things are you celebrating today?

Posted in Salesforce Stuff | Tagged , , , , , , , , | 2 Comments

Whoomp, there it is! (Translated: Why Salesforce Process Builder Rocks!)

Whoomp

“Why does Salesforce Process Builder rock?” you ask.

Simple: In less than an hour I can create a Custom Object called System Status with 6 fields. Create Status records for all of our major corporate systems (phones, firewall/VPN, programs like WebEx and Office365), and setup a process where our IT group can quickly update records with news of outages or downtime.

System Status Record

With Process Builder I can easily (in minutes) setup a process so when IT Checks a Box to initiate a Company-Wide Notification of the status, a Chatter Post is automatically created in our Corporate Chatter Group (where all 400+ employees have access) with details of the System Status.

System Status Chatter Post

Without Process Builder I would not have been able to create the functionality for the  Chatter Post in minutes. It would have involved apex classes and triggers and debugging (Oh My!) which I am still quite the novice at!

So today I am shouting out my love of Process Builder to the masses! What do you love about the Process Builder?

Whoomp There It Is!

Posted in Salesforce Stuff | Tagged , , , , | Leave a comment