How to count the number of phrases or words in a Multiline Cell in Google Sheets
Let’s say you have a Google Sheet with Multi Line text like: And you want to count how many times each phrase is mentioned or the most popular terms. keyword count Jquery 569 Google Tag Manager 438 Google Font Api … Continued
How to update BigCommerce Product Page Template
Go to BigCommerce Admin at YOURSTORESHORTCUT.mybigcommerce.com/admin Edit StoreFront -> Themes For current theme -> click Advanced -> Edit Theme Files Go to Templates -> components -> product-view.html
What to do when Notepad++ crashes and won’t open
Notepad++ is a great code-editor tool but there are times when it just won’t load and it hangs. It can be annoying when you are trying to get your work or coding done. Maybe that’s why there’s a Red cross … Continued
Google Sheets – How to extract the matching text based on a list
Although this is fairly easy to do, I ran into an issue and wanted to share some tips. Let’s say you want to return the matching text based on an existing list. In my case, I wanted to return the … Continued
How to fix the “You don’t have permissions” error in Google Sheets IMPORTRANGE
If doing an IMPORTRANGE function in Google Sheets and you get the “You don’t have permissions to access that sheet.” error follow these steps: First make sure the sheet you are importing is NOT the XLSX version for Office Compatibility. … Continued
How to fix “Processing webhook: Webhook user no longer in account. ” in Aha! Roadmap tool
If you use Aha! Roadmap tool, you have JIRA integrated and received the following error: “Processing webhook: Webhook user no longer in account. ” this usually means that the user assigned to the Aha WebHook no longer exists in Aha user … Continued
How To Recover Your Sessions In Notepad++ During Crashes
Are you having that annoying and common issue where Notepad++ crashes or won’t start up? There are lots of articles about how to get Notepad++ to start up with the -noSessions and -noPlugins command line argument already. But how can … Continued
What is Gmail Authorized Application “682126721867 .apps.googleusercontent.com”??
Took me a while to narrow it down but wanted to share the info in case you freaked out like I did at first. going directly to 682126721867.apps.googleusercontent.com did not reveal any information. Doing a WHOIS 34.197.187.40 returned Amazon as … Continued
Why is Accessibility, ADA and Section 508 Compliance so important and how do I fix it?
A few years ago, a company I work for, started getting slammed with requests to ensure that our online content platform and content itself was Section 508 compliant or WCAG accessible for eCommerce sites. What is it? What does that … Continued
Installing pimcore via ampps returns PHP Version error
If you use ampps for a local dev stack or for production, you may run into errors while trying to install pimcore: “Required PHP version less than 7.2.0 AND found version is : 7.3.11“ Apparently softaculous isn’t quite smart enough … Continued