Up through yesterday, I was hitting a concept roadblock on how to put content on two of the new tabs on the Celebrate America web page.

But on a bike ride this morning, I had ideas on how to solve both those issues.

SOLUTION TO DILEMMA 1

The first issue was this: I wanted to keep a log of who all has requested the music, what their group is, and when they plan to play the tune, and their location. I also need to keep email addresses and points of contact information, but I do not want to expose those to the public. However, I’d be happy to show everyone the requestors’ Group name, location, and date of expected or actual performance.

This was a head-scratcher, because I also didn’t want to have to jump through hoops to update this list every time someone requested the music.

The solution is Google Sheets. I can log the full information on a master sheet, then create a second sheet which is an automatic extract of only the sharable information from the first sheet, then embed that second sheet on the website for everyone to see. That way, they only see the sharable information and not the more sensitive stuff.

I’ve been able to embed Google Sheets docs on a website before, so that should work just fine. However, it still needs to be proven in practice.

SOLUTION TO DILEMMA 2

The other dilemma was what to do about the BLOG tab. This blog.

Again, I didn’t want to have to jump through hoops to create new blog posts, and have to endure a big hassle.

WordPress to the rescue. WordPress was originally a blogging platform, and it still has blogging DNA in its hear and core. So now I’m simply using the blogging capability of WordPress to write the Celebrate America Blog, and if you’re reading this now, the it probably worked just fine.

So, two dilemmas hopefully solved. All I need to do now is implement the solutions and cross my fingers that the solutions work as conceived.