TravelPort Universal API - Ping Request with PHP-cURLhttps://joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 sub-component of PHP that allows you to send and receive requests as the server (as opposed to the client device). Why? Yes there's documentation online that TravelPort provide you with but it didn't help. The error I'm going to address has to do with...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Sort an associative array by values in Javascripthttps://joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 but that's not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 Library for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This assumes you have already "Enabled the Drive API" via your Google Developers...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge: Loop through 30 Minute Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 the Zoho Developer Console Create a Zoho Client ID Either use self-client for a code or use the below to generate one. Code Here you will need your own client ID and client secret generated from the developer console in the following snippet: v_ClientID...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 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...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 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...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 Chrome browser with that profile. How? So you will need to be able to run AutoHotkey or create executables from an AHK file. Here is the code that creates a GUI with a ListView with rows that can be double-clicked to open the profile. As an overview:...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 is of a client's Zoho Books instance opened in a browser. the circled part is the domain of the Zoho app we are accessing: Here is a list of the datacenters that I know of: AU = Australia (zoho.com.au) CN = China (zoho.com.cn) EU = Europe (zoho.eu) IN =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 framework considering that Zoho Creator has their own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a popup, the first use example is on report workflow (click of a button in a report row) but I've...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went wrong, I have a client with ZohoCRM who upload a PDF (can be any file but is usually a PDF) to a custom module in...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 require you to add in this custom field per line item, but also requires a change to the other fields in the line item. There is an additional note that when using v2.1, you no longer post to the "Product_Details" key but to the respective module line...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line items. You may have...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 the Product IDs. This method could do with some refinement and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every active product and list their IDs. How? So here's...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 // assuming my sections are called "Tab_Section_1", and so on... [these can be named as you want, the names I've used here are for demo purposes] hide Tab_Section_1; hide Tab_Section_2; hide Tab_Section_3; hide Tab_Section_4; hide Tab_Section_5; hide...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *