Search - Joel Lipman .Com

21. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... specify system/application offset v_ApplicationTimeOffset = "-05:00"; // // customer is in (America/Los_Angeles) v_CustomerCallTime = '2021-11-19 08:12:34'; // // set system/application date time ...; Created on 18 November 2021
22. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... I call my subform "Quoted Items" and specify this having the fields "Ref, Item, SKU, Description, Quantity, RRP, Discount, Total". Add the subform to your document and ensure that none of the fields hav ...; Created on 21 October 2021
23. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // ...; Created on 27 September 2021
24. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... I use but you will need to adapt it for your own system: // init (specify your own organization ID for Zoho Books) v_BooksOrgID = 20210922122; m_BooksCreateSO = Map(); // get CRM record details r_SoDetails ...; Created on 22 September 2021
25. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
26. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; v_APICallName = "SetNotificationPreferences"; // // specify the URL of the CRM REST API Function here (can be a mailto:email@address) v_CrmRestFunction ...; Created on 20 September 2021
27. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... > Modules and Fields Hover the mouse cursor over the "Products" module and then over the ellipsis Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard ...; Created on 02 September 2021
28. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... it Shopify - Webhook - Order Update Specify the Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won ...; Created on 15 July 2021
29. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I ...; Created on 06 December 2020
30. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... into 3 stages: Zoho Creator: Specify Custom Domain Domain Registrar: Setup subdomain and add CNAME Zoho Support: Get Zoho to setup SSL 1. Setup Custom Domain So go into your Zoho Creator ...; Created on 17 November 2020
31. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... custom javascript file referring to the ZOHO.CREATOR.init() and calling Creator records. ./plugin-manifest.json: JSON specifying service as "CREATOR". Error(s): When trying npm install -g zoho-extension-toolkit: ...; Created on 24 October 2020
32. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... com.cn (China), ... v_TLD = "eu"; // my creator form f_MyImages = MyImages[Name == "Logo"]; v_Filename = f_MyImages.MyImage.getSuffix("/image/").getPrefix("\""); // specify publish key of published ...; Created on 14 July 2020
33. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button ...; Created on 08 July 2020
34. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... = invokeurl [ url :v_DataEndpoint type :GET connection: myConnector ]; Solution: My endpoint was specifying COM instead of EU as per the client's data center: v_DataEndpoint = "https://books.zoho.eu/api/v3/contacts?organization_id=123456789"; r_Response ...; Created on 06 February 2020
35. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... 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 ...; Created on 27 September 2019
36. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... 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 ...; Created on 02 September 2019
37. MS Excel - Open CSV with Long Numbers: / Excel /; ... each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers) ...; Created on 23 July 2019
38. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; ... the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before { opacity:0; content: ''; transition: all 1s ease; transition-property: width, opacity; } /* ...; Created on 18 May 2019
39. Zoho Templates - Font size is inexplicably tiny: / Zoho /; What? This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden ...; Created on 22 February 2019
40. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... WorkRng = Application.InputBox("Specify Data Range", xTitleId, WorkRng.Address, Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent ...; Created on 11 February 2019