The Old Blog Of Steffi Lewis

Founder & creator of YourPCM ...

     

A Weekend Of Unexpected Coding

And learning stuff too ...

POSTED BY STEFFI LEWIS ON 06/06/2023 @ 9:00AM

#YourPCM #SaaS #Coding #Business #Marketing #Thoughts #CRM #SME #UK

I was intending on having a quiet weekend. Lots of binge watching ready for new seasons of my favourite shows to come out this summer. But that's not what happened, I ended up coding instead ...

I got a lot of coding done this weekend, but it was unexpected!

I got a lot of coding done this weekend, but it was unexpected!

created by leonardo ai


I had a whatsapp conversation with a really good prospect I've been chatting to for the last few weeks. They'd decided to dump their existing CRM and jump into YourPCM, but they needed a few extra fields in the database and could I accommodate them ready for a data import?

"Of course I could!"

To be honest, since they mentioned the extra fields a few weeks ago when we first started talking, I had been thinking about adding them, but what the hell, let's do it now. So, I got to work on Saturday and dived into the codebase.

They wanted a job title field, and some address fields. I already had a postcode field in there (linked to Google Maps) so that was no biggie. I did have to update the edit contact popup dialog box to accommodate the extra fields, and I also changed the import and export features to use them as well.

And the final flourish was to update the search page with the postcode and the job title too, so now someone can quickly and easily find all 'directors', or everyone with a postcode that starts with 'MK'. I also added the ability to search on Firstname and Surname together as a few people had said just searching on one or the other returned lots of records instead of just the one they wanted.

"So, I was very pleased with my efforts!"

It all took an afternoon to get it working correctly and at the same time, I took the opportunity to tweak a few other things so now we have field customisation options and contact date thresholds with all the on/off flags in one popup dialog box called SETTINGS and the section details are now called MY SECTIONS and they're on their own. I am planning to add another 32 sections in the near future (massive job!), so doing this now will save me some time later on.

I retired to my big, comfy recliner chair for the evening and caught up on Star Trek Strange New Worlds as the next series is out next week. It was a good day and I enjoyed making all those tweaks, changes and additions.

However, Sunday meant I needed to work on some data for my latest subscriber. She had jumped from Zoho to YourPCM and the data she needed was split across two tables ... one for companies and one for contacts. How was I going to combine them? I thought about writing a script on YourPCM for it, but didn't want to modify the database with temporary tables.

"I asked ChatGPT how to do it!"

My AI friend told me all about data queries in Excel and once I'd got those two separate sheets into a format I could use, I linked the company ID columns in a data query and hey presto ... it all merged together quite nicely.

I then copied everything out into a new worksheet, moved a few columns around, deleted some others and formatted some phone numbers and it's now ready for import. My new subscriber wanted the contacts split into a few different sections within YourPCM.

"I just need to use the filter options in Excel and then import the contacts from there!"

So, all in all, a surprisingly productive weekend of unexpected coding, and I learned something too. I did get plenty of sleep and ate a load of scrummy food, so I'm happy. Next weekend, I'll aim for a quiet one again, though I'm sure something will come up.

Oh, the joys of running a startup SaaS business, hey?

Love, light & logic ...

Steffi Lewis

STEFFI LEWIS
Independent UK SaaS Developer - Creator of YourPCM & sBlogIt!



Would you like to know more?

If anything I've written in this blog post resonates with you and you'd like to discover more about , do give us a call ...

Share the blog love ...

    

Share this to FacebookShare this to TwitterShare this to LinkedInShare this to PinterestShare this via Buffer

#YourPCM #SaaS #Coding #Business #Marketing #Thoughts #CRM #SME #UK

About Steffi Lewis ...

 

Based in the charming village of Hanslope in Buckinghamshire, UK, I bring over 30 years of experience in web development. From creating my first website for the Open University in 1993, through being part of the dot com boom, to my explorations in SaaS and AI over the last few years, my journey has been a rich tapestry of web projects, big and small, both funded and bootstrapped.

Originally developed during the pandemic, at the start of 2025, I released the next iteration of YourPCM, version 2, which is all about 'Easy Contact Management for Small Business Owners'. Is it a CRM? Yes, but I don't call it that because people glaze over at the mention of such things. CRMs are boring, difficult to get to grips with, and it's a nightmare to get help when you need it. 

YourPCM is none of those things! It's simple to use, well-supported, feature rich and beautiful, right out of the box. It's available on a simple monthly subscription with no long-term tie-in. Book a demo or grab your own 14-working-day free trial and discover why YourPCM is all about easy contact management for small business owners. 

My head is in the cloud, my heart belongs to the web, and my soul is filled with such beautiful code ��



Telephone:

01908 875991

Website:

https://www.yourpcm.uk

DAILY TRACKING LIMIT EXCEEDED