Skip to content

Duration: 17m 12s

This Week's Topics

FileMaker Pro database rebuild - Using Claude to migrate the old database - Automatic Google Maps venue lookups - Traffic-based departure time calculations - Fixing duplicate client records for repeat bookings - Fixing duplicate venue records - Taylor reviewing historic business data - Cleaning up Apple Calendar reminders - Reviewing client care plans from old emails - Tidying up Zoho Books - Merging duplicate contact records

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.

View as .json, .yaml, .md, .ics, .mf2, .txt

No interactions yet

0

Add a comment, or send me the link to your own post.

Link back to this page if you write about it.

This is what shows up when you post the link somewhere.

taylordrayson.com

This Week With: Season 7… - 20 Nov 2026

FileMaker Pro database rebuild - Using Claude to migrate the old database - Automatic Google Maps venue lookups - Traffic-based departure time calculations - Fixing duplicate client records for…

Want to see how it is made? Here is the card on its own, drawn from this page's own title and description.