Search - Joel Lipman .Com

1. Zoho Creator: Input Color Picker: / Zoho /; ... Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the application later - so perhaps rename this to 'Staf ...; Created on 14 October 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... t for Signature"); // Request_ID is a custom field added to retrieve the document later from ZohoWriter. m_ZCrm_ZSDoc.put("Request_ID",v_RequestId); r_ZCrm_ZSDoc = zoho.crm.createRecord("zohosign__ZohoSign_Documents",m_ZCrm_ZSDoc); v_OutputMessa ...; Created on 06 August 2024
3. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets ...; Created on 22 April 2024
5. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... number "OrgId" there Note this down for later use Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the "Home" level Click on the cog icon in the top-right for "Settings" ...; Created on 05 December 2023
6. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = "IN: " + invoice.get("invoice_number") + " ID: " + invoice.get("invoice_id"); m_Params.put("description",v_DescriptionString); // Later Add Code to "customer_id": "123456700000001234567", get customer ...; Created on 16 March 2023
7. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... to generate meaningful reports. The first dataset should be just the profit per item based on what was purchased. I'm including the Purchase Order ID so that I can refer to it later for shipping ...; Created on 03 November 2022
8. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So ...; Created on 07 April 2022
9. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... added row in that subform (on user input). This sets the document name for display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart ...; Created on 11 March 2022
10. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel ...; Created on 07 December 2021
11. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later ...; Created on 19 October 2021
12. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... notification preferences are setup. This one didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked. void API.fn_eBayQuery_GetNotificationPreferences() { /* ...; Created on 20 September 2021
13. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the ...; Created on 01 September 2021
14. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & ...; Created on 30 July 2021
15. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... You might already be familiar with some of the trigger options below but one that worked was initially guessed as "none" but then later found in the documentation could also be an empty list []. ...; Created on 16 June 2021
16. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... credentials that Google Chrome cannot process. Network errors and attacks are usually temporary, so this page will probably work later.” My workaround was simply not to use Google Chrome but to ...; Created on 24 October 2020
17. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... in code later (preferably in lowercase as it will lowercase it anyway) Scope: Enter each scope you need and click on the plus icon to add each one. Keep "Use credentials of login user" ticked. You ...; Created on 12 August 2020
18. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with ...; Created on 04 May 2020
19. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? ...; Created on 07 February 2020
20. VBScript to retrieve Windows Product Key: / Windows OS /; ... WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time ...; Created on 23 September 2015