URL Alias uniqueness with PHP & MySQLhttp://mail.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 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....

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 the invoice line items with their respective sales order item id value. For our client's purpose, we are running a custom function off the invoice module which: creates a sales order checks the returning sales order line items cycles through the invoice...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Send mail attachment: creator file upload field value as attached file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: Find in list view occurrences of new names column CountExistingInColumn2( v_Filename ) {...

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

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

22 October 2020 on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in functionality of Zoho Creator and could be seen as a 'Pure CSS' feature. I'm aiming to make a list of capabilities that can be done...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request using the invokeUrl() function, the odd thing is that Zoho's request adds double-quotes to the request and escapes the other double-quotes sending something...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create a standalone function called "Test". Type in line 1: r_Record = zoho.crm.getRecords then press Enter (DO NOT START...

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

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

17 May 2021 } } } Retrieving a record with 2.1 JSON The following is a snippet when querying a CRM module (invoices) from a CRM function. The important fields I wanted were some custom fields within the line items subform. Here I'm adding the parameters to ensure...

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

Windows OS: Alt Codes / Symbols / Special Charactershttp://mail.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 key. Remember: This will not work with the numbers at the top of your keyboard unless you are on a laptop and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled. Which numbers you might ask? Well every character is...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Deluge: Zoho Bookings Get Available Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

23 June 2021 to make a booking based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots function requires as parameters according to documentation = zoho.bookings.getAvailableSlots(, , , ); Set up your connector with the...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list cannot be displayed.: You are trying to return (an empty record dataset).

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

Zoho CRM & Zoho Books: Get SalesPersonshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

30 August 2021 in ZohoCRM and wanted to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next snippet of code, I am getting the Zoho...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function if the .get is an out-of-bounds and the .toDate() or .toString() fall apart with an unparsable date: v_TestDate =...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 rather than 20 workflows every time we want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To this end, I create a field called...

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

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime;...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 "gid://shopify/ProductImage/23456789012345" } } This next version is a more generic form of the above function uploading the photo to Shopify: void API.fn_ShopifyQuery_UploadPhoto(int p_ProductID, int p_Position, string p_ImageSrc) { m_Header = Map();...

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

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid...

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