Zoho Deluge - Determine Quarter from Date with Fiscal Year
- Category: Zoho
- Hits: 12076
This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month.
Why?
Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3...
How?
I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below:
l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames = {"January","February","March","April","May","June","July","August","September","October","November","December"};
Zoho Deluge - InvokeConnector and useful snippets
- Category: Zoho
- Hits: 12926
So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode.
Zoho Deluge - Compare time and currenttime with timezone
- Category: Zoho
- Hits: 18210
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an access token used in OAuth2.0 for an API.
How?
All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will switch the current time to Europe/London (You can use an abbreviation such as GMT but this doesn't seem to check if daylight savings is in effect):
Autohotkey - Chrome Profiles in Alphabetical Order
- Category: AutoHotkey
- Hits: 14598
- MS Windows 10 Pro v10.0.18362 Build 18362 (64-bit)
- Google Chrome Browser v79.0.3945.88 (Official Build) (64-bit)
- AutoHotkey v1.1.30.01
This is an article to create a standalone application which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order.
Why?
This program will be redundant if Google ever update their Chrome browser to list the multiple profiles in alphabetical order like it used to be... but to date they have not. So I made a program that lists the profiles in alphabetical order and can be double-clicked to open the Chrome browser with that profile.
How?
So you will need to be able to run AutoHotkey or create executables from an AHK file.
PHP - Remove newlines and spaces from StyleSheet
- Category: Personal Home Page
- Hits: 7390
What?
This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines.
Why?
What I have:
#copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); }
What I want:
#copyright a{margin:10px 0 0 85px;box-shadow:5px 5px 5px 0px rgba(51,51,51,0.3);}
How?
So I'm doing this with a regular expression to get rid of newlines:
$v_AppStyle = " #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); }"; $v_AppStyleFormatted = preg_replace('/\s+/', ' ', $v_AppStyle);
and a few str_replace arrays:
// exceptions $a_ReplaceFrom1 = array("px ", "0 ", " a"); $a_ReplaceTo1 = array("px?", "0?", "?a"); $v_AppStyleFormatted = str_replace($a_ReplaceFrom1, $a_ReplaceTo1, $v_AppStyleFormatted); // replace all spaces to empty and replace question marks back to spaces $a_ReplaceFrom2 = array(" ", "?"); $a_ReplaceTo2 = array("", " "); $v_AppStyleFormatted = str_replace($a_ReplaceFrom2, $a_ReplaceTo2, $v_AppStyleFormatted); echo $v_AppStyleFormatted;
Zoho Creator: Retrieve record with case-insensitive query
- Category: Zoho
- Hits: 18245
Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive.
Why?
Consider that I have the following creator table:
Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03
I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product.
Zoho Deluge - First Monday of Month or Last Tuesday of Month
- Category: Zoho
- Hits: 15942
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.
Why?
This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say the first Monday of the month (ignoring bank holidays) or to say the last Tuesday of the month.
How?
Quite easily. For the first Monday of the month, it is likely that even if today was the first day of the month and coincidentally a Monday, then we would want to specify the field date to be the first Monday of the next month. If however we want the last Tuesday of the month and that Tuesday happens before today, then we want the last Tuesday of the next month.
CSS Center an iFrame Horizontally and Vertically
- Category: Cascading Stylesheets
- Hits: 24728
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.
Why?
On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an alert message, it popups a div at the centre of its app. The alert message is always at the center of the iframe but if the iframe has a height of 2000 pixels, the iframe gets aligned to the top of the parent...
How?
We're going to use a touch of CSS and instead of determining heights and alignment with JS.
Page 24 of 73
Credit where Credit is Due:
Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.
Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.
Thank you for visiting and, as always, we hope this website was of some use to you!
Kind Regards,
Joel Lipman
www.joellipman.com
Latest Articles
Accreditation



Donate & Support
If you like my content, and would like to support this sharing site, feel free to donate using a method below:

bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF
Paypal:

Bitcoin:

Ethereum:
