Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06" = 34 hours and 6 minutes). Error(s) Input...

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

Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 do this but I thought I'd write this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and probably...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What...

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

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

13 October 2021 - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 ID The following snippet is a separate function to run (standalone) and will return to you the templates and the field references: r_Templates = invokeUrl [ url: "https://zohoapis.com/writer/api/v1/templates" type: GET connection: "joels_connector" ];...

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

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

22 October 2021 This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The...

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

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 - GetItemTransactions Documentation: https://developer.ebay.com/devzone/xml/docs/Reference/eBay/GetItemTransactions.html */ v_Found = 0; v_Updated = 0; v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 m_SearchCriteria.put("sort_by","payment_number"); // // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks");...

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

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows = ZDK.Apps.CRM.Deployment_Rate_Log.fetch(); Another example of looping through a subform In the...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 v_Question); l_Messages.add(m_Message); m_Params.put("messages", l_Messages); // // https://platform.openai.com/docs/api-reference/chat/create m_Params.put("temperature", 0.8); m_Params.put("n", 1); m_Params.put("max_tokens", 256);...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify page to start from v_StartingPageIndex = 1; // // specify...

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

ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 Portal Signup: https://developer.dhl.com/user/register - DHL Developer API Documentaiton: https://developer.dhl.com/api-reference/shipment-tracking#reference-docs-section */ // // initialize v_ShipmentStatus = "error"; v_TrackingNumber =...

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

Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 = ifnull(input.p_QuoteRef,"-"); v_CustomerID = ifnull(input.p_CxID,"-"); // // Search ZohoBooks estimates for the quote reference and validate by the contact Zoho ID if(v_QuoteRef != "-") { r_SearchResults =...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 a function which took me a day to write. Why? As mentioned, it took me a while to write and I would like to use it as a reference for when I forget how to do this. The use-case here is that we have a dropdown/picklist on a CRM invoice record that has...

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

Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 and push it to Zoho Analytics. Find the form link name: Putting this here as it should be what we first did! This is with reference to the Zoho People version 5: Login to Zoho People as an administrator (don't have to be super admin) Go to Settings (cog...

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

Splatter Logohttps://www.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 I have a menu called "unused menuitems" (named unusedmenu), which isn't displayed anywhere on my site. I'm guessing the reference in the database is what corrects this.

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 all the submitted data on the front-end of my component is controlled and not customizable. I fixed this by removing the reference to router.php within the installation XML file. (router.php). I even deleted the router.php file from my installation zip...

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