Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes70 results
MySQL: Count occurrences of words in a column
... is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used f ...
Passwords: Did-you-know
... ents and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300. Additionally, it claims that it can crack 18% of the passwords in under 10 minutes (source: SpiesOnline.net 09/2006) In the UK a w ...
Zoho CRM: Add and Update Products from Zoho Analytics Discrepancies
... arately. The published IDs are placeholders, but IDs are not passwords. Keep OAuth tokens and secrets out of public code, use a managed connection, and grant only the access the function needs. The end result is a small scheduled integratio ...
Zoho People Analytics Regional Configuration
... roles for controlling access to the scope of the data. In other words, being able to see all data, or just the data in their region depending on which workspace they are added to. User Groups are introduced later to simplify access managem ...
Zoho CRM Client Script: Map Quote to Invoice
... lds over. Great! But what if someone skips the process, in other words, goes to the quote record, and clicks on the plus icon next to "Invoices" in the left sidebar? This script will map over the core fields, address, and line item. This to ...
Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages
What? An article on some Zoho ANSI-SQL (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from ...
Zoho Deluge: Using Remove Key on a Map and Copying Record Tags
... ry to assign this to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the tags o ...
Zoho Deluge: Get the Week Number if Week starts on a Monday
... nday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting starts at 7, followed by 1 for Monday, 2 for Tuesday, and so on... How? The logic behind this would be to take the date of the order, check if the orde ...
ZohoCRM: Get Organization Business Hours using Deluge/API
... bly not in the Zoho order, but that of the normal week (in other words, not alphabetical, numerical, or completely random order): void JoelLipman.fn_SetStaffUsualShift() { // // build a standard usual shift subform from CRM r_OrgDetails = i ...
Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo
... response similar to Siri or Ask Google where it includes the keywords in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently conne ...
Joel's Reference to MidJourney v4 Image Prompts
... rom a brief. How? A "prompt" is a text-to-image expression using words and phrases to instruct the Midjourney Bot (or any other AI text-2-image generator) which the bot can break down into "tokens" and then match with its training data to g ...
Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures
... -time-of-print, Zoho Inventory only syncs eBay one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed in ...