Back this week after missing last week due to family illness, filming from a new angle using Taylor's standing desk
Gordon has started rebuilding his FileMaker Pro booking database, which he's used since 1996
The old database needed replacing because FileMaker wasn't compatible with the next macOS update
Using Claude to read the FileMaker XML exports and build a replacement database from scratch
Adding features the old system didn't have, like automatic Google Maps venue lookups
Calculating what time to leave for a venue using historical traffic data for that specific day of the year
Fixing duplicate client records that happened when a repeat family booked for a different child
The new system tracks multiple children per family properly, making repeat-booking stats accurate
Solving duplicate venue entries, like two "All Saints Church Hall" venues in different areas
New venues can now be pulled automatically from Google's Places API when typing an address
Still need to sort out the print and letterhead side of the new system
Running the old and new databases side by side during the transition
Taylor has been reviewing historic business data spread across old project tools, emails and calendars
Deciding whether it's worth migrating old incomplete project data or starting fresh going forward
Adding recurring reminders for tasks that repeat biweekly, yearly, or on other schedules
Cleaning up Apple Calendar reminders that have built up over time
Digging through old client emails to confirm what care plans and terms were originally agreed
Only bringing active clients into the new system, not past ones who've left
Tidying up bookkeeping records in Zoho Books
Merging duplicate contact records when details change, like a client's maiden name after marriage
Using AI to scan old emails and pull out project history that was never properly logged
Visit the website:
https://www.thisweekwith.co.uk
Drayson Design Website –
https://www.draysondesign.com
The Creative Tinker Website –
https://www.thecreativetinker.com
Facebook:
https://www.thisweekwith.co.uk/facebook
Youtube:
https://www.thisweekwith.co.uk/youtube
* Full transcript will be available on the website. We may receive a referral fee from any of our links which help towards the costs involved in creating this content for you.