Payhip store Unlisted Product Gotcha -- It being too simplistic or am I Overcomplicating?

 As part of another blogging business and working on an actual digital publishing business, I came across (that is, baffled myself) using the Payhip Store Builder.

If you have an "Unlisted" product on the product screen and go away and forget it, you may have some heartbreak later on until you rediscover what you had forgotten.

Overall so far, I find the Payhip Store Builder a bit stifling, if I'm going to make howlers like that I'd like them to be complicated situations where I got into the deep doo-doo myself, not just mis-applying some radio button ...

ChatGPT and Office Script

 more comments when I watch it a second time

https://www.youtube.com/watch?v=70AyXUoBRqw

Office Script as an alternative to VBA

Office Script has been around for a while, the big draw seems to be Online, so Office 365 etc.

I haven't really been following it, but getting up to speed now. See the video below which got my attention a while back 

Big Caveat: on deeper investigation, It only seems to be available for Excel, not Word, which will still be stuck with VBA for the time being, which is a couple of years on from all the excitement, so slightly disappointing there. But something similar has happened with Google Docs, so more on that when I get time to post

https://www.youtube.com/watch?v=DOvHqukAGTY&t=57s

Introduction to Office Scripts:

https://www.youtube.com/watch?v=fny4zUycp_w

Video summary [00:00:00]¹ - [00:14:01]²:

This video introduces Office Scripts, a feature that allows users to automate tasks in Excel Online and Teams using TypeScript. It demonstrates how to record, edit, and run a script that creates a column chart from a data range. It also shows how to make the script dynamic, so that it can work on different data sets and files. The video covers the basics of Office Scripts, such as the code editor, the script gallery, the output window, and the script location.

Highlights:

• [00:00:00]³ The purpose and benefits of Office Scripts
  • Automate boring, repetitive tasks in Excel
  • Work on Excel Online and Teams
  • Replace VBA macros that don’t work on the web
• [00:01:15]⁴ How to record a script using the Automate tab
  • Click on Record Actions
  • Perform the desired actions on the workbook
  • Stop the recording and view the script
• [00:04:04]⁵ How to edit a script using the code editor
  • Rename the script and save it
  • Use the comments to understand the code
  • Make changes to the script, such as adding variables or methods
• [00:06:04]⁶ How to test and run a script on different data sets
  • Click on Run Script
  • View the output and the chart
  • Run the script on other tabs or files
• [00:11:08]⁷ How to manage and share scripts
  • Find the scripts in OneDrive under Documents
  • Use More Options to copy, rename, share, or delete scripts
  • Use Power Automate to automatically run scripts
• [00:13:18]⁸ How to run scripts in Teams
  • Open the file in Teams
  • Go to the Automate tab
  • Select and run the script

Shameless SEO and ChatBot Experiment

 This may mark something of a pivot, after not having posted for seven years? I might do some rapid linking of topics that have caught my attention, almost a rambling book mark collection.

Possibility one: Joshua does a job I wouldn't like at all but his breakdown of how he integrates ChatGPT with Google Sheets certainly makes it look feasible

https://www.youtube.com/watch?v=KT85wQFlRk4&t=321s