Zoho Creator: Retrieve record with case-insensitive query
Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search638 entries
Zoho Deluge - First Monday of Month or Last Tuesday of Month
An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the month is before the current date, then set it to the last Tuesday of next month.
CSS Center an iFrame Horizontally and Vertically
So this is a quick article to demo how to center an iframe horizontally and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline.
Zoho Deluge - Counting in a Map dataType
A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the same.
Zoho Deluge - Modify the product line items in an invoice module
This is a reminder on how to swap out a product in an invoice.
Zoho Deluge: Adding / Removing Total Tax from a Quote Record
A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items.
MS Excel - Open CSV with Long Numbers
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,14571020000...
AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops
Yay for Microsoft Windows 10 in joining the rest of the Operating Systems in implementing multiple desktops. So if you have a Mac or Linux system, you will know of a feature where you can have another virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe l...
Zoho Deluge - Get Refresh/Access Token API v2
A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls.
Loading more notes...
No more notes to load.