Articles - Joel Lipman .Com

Zoho Deluge - Determine Quarter from Date with Fiscal Year

: Joel Lipman; Zoho; 31 January 2020; Hits: 4723

What?
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:

copy raw

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"};

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"};

Category: Zoho :: Article: 703

: Joel Lipman; Zoho; 23 January 2020; Hits: 4759

What?
So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode.

: Joel Lipman; Zoho; 13 January 2020; Hits: 7959

What?
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):

: Joel Lipman; Xero; 10 January 2020; Hits: 442

What?
This is an article documenting a generic script that can be used to push an invoice to the demo Xero environment. Following the steps below will connect you to the Demonstration environment of Xero at no cost to you the developer.

How?
Similar to my ZohoAPI script the process is:

Start with a HTML form to add your client ID/client Secret/scopes and Redirect URI. These get stored in a temporary file to retrieve later.
Then you get a button that will return the "CODE" variable via GET (URL). Clicking on this will get the CODE variable and use it to generate a refresh token.
Then with the refresh token generate an access token.
Then with the access token get a connection "TenantID".
Then with the tenantID we can retrieve records and/or finally create an invoice (accounts receivables).

Autohotkey - Chrome Profiles in Alphabetical Order

: Joel Lipman; AutoHotkey; 07 January 2020; Hits: 3251

Applies To:

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

What?
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.

: Joel Lipman; Personal Home Page; 03 January 2020; Hits: 2338

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:

copy raw

#copyright a{
    margin: 10px 0 0 85px;
    box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3);
}

#copyright a{
margin: 10px 0 0 85px;
box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3);
}

What I want:

copy raw

#copyright a{margin:10px 0 0 85px;box-shadow:5px 5px 5px 0px rgba(51,51,51,0.3);}

#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:

copy raw

$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);

$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:

copy raw

// 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;

// 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;

Category: Personal Home Page :: Article: 697

Zoho Creator: Retrieve record with case-insensitive query

: Joel Lipman; Zoho; 21 November 2019; Hits: 4523

What?
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:

copy raw

Product_Name   Product_SKU   
-------------- -------------
MyProduct1     TEST01
Myproduct2     TEST02
myproduct3     TEST03

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.

Category: Zoho :: Article: 696

: Joel Lipman; Zoho; 27 September 2019; Hits: 6741

What?
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.

: Joel Lipman; Cascading Stylesheets; 23 September 2019; Hits: 11505

What?
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.

: Joel Lipman; Zoho; 02 September 2019; Hits: 4260

What?
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.

Why?
I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let us assume we have the following in a form/report called "Stock_Upload":

copy raw

RowID	Name	            SKU	        Account Email	
0001	Test Product 1	    TEST001	    This email address is being protected from spambots. You need JavaScript enabled to view it.	
0002	Test Product 1	    TEST001	    This email address is being protected from spambots. You need JavaScript enabled to view it.	
0003	Test Product 1	    TEST001	    This email address is being protected from spambots. You need JavaScript enabled to view it.	
0004	Test Product 1	    TEST001	    This email address is being protected from spambots. You need JavaScript enabled to view it.	
0005	Test Product 2	    TEST002	    This email address is being protected from spambots. You need JavaScript enabled to view it.	
0006	Test Product 1	    TEST001	    This email address is being protected from spambots. You need JavaScript enabled to view it.	
0007	Test Product 1	    TEST001	    This email address is being protected from spambots. You need JavaScript enabled to view it.

RowID Name SKU Account Email
0001 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it.
0002 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it.
0003 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it.
0004 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it.
0005 Test Product 2 TEST002 This email address is being protected from spambots. You need JavaScript enabled to view it.
0006 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it.
0007 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it.

The code is a for loop which iterates through each row, assigning an entry for a new product or account, and specifying the quantity for each.

How?
So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario:

Category: Zoho :: Article: 693

: Joel Lipman; Zoho; 22 August 2019; Hits: 7203

What?
This is a reminder on how to swap out a product in an invoice.

Why?
A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock.

How?

: Joel Lipman; Zoho; 20 August 2019; Hits: 5331

What?
A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items.

Why?
I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and programmatically.

How?
A little undocumented this "feature" but the gist is if you want to add tax, it has to be built up in the tax options, if you want this to be zero, you need to pass the option of tax as zero and remove all other options.

Xero API: Standard PHP/cURL Create Invoice

Credit where Credit is Due:

RSS Feed

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Donate & Support