Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... observant among you will have noted that I'm recording the module name and module record ID on the ZohoSign Document record. Doing this at the point of the request means that I can have a generic webhoo ...; Created on 06 August 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... A custom field against the item record has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per line item, the staff can specify which Sales Order ...; Created on 09 July 2024
3. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... to check, just round em (also means you don't need the above function to count decimals) var v_ProductCost = ZDK.Page.getField('Purchase_Rate').getValue(); ZDK.Page.getField("Purchase_Rate").setValue(parseFloat(v_ProductCost).toFixed(6)); ...; Created on 13 December 2023
4. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", ...; Created on 03 July 2023
5. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge ...; Created on 28 February 2023
6. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... ":}]} I only resolved this by not using "endCursor" in my GraphQL and instead looped through the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort cr ...; Created on 20 February 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. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Mini-DisplayPort, which means that only 1 DisplayPort cable needs to go the PC. They also have 1 HDMI input. The NZXT Z490 Motherboard I have only has 1 HDMI port. Here's a crude diagram of what I had: ...; Created on 12 March 2022
9. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... displayed here for testing purposes: the starting date, and then based on the offset, the selected date. The first bit of this snippet creates a map which for this example would be . This means that ...; Created on 09 March 2022
10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... store with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app ...; Created on 14 February 2022
11. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status ...; Created on 11 February 2022
12. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... time of print, it doesn't exist and in the meantime, I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew ...; Created on 27 January 2022
13. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every ...; Created on 02 December 2021
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... v_PositionIndex, v_ShopifyImageSrc); } v_PositionIndex = v_PositionIndex + 1; } info "Re-uploaded Photos to Shopify"; } } Correction / Additional The above solution means that ...; Created on 17 October 2021
15. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... fields of the record that I want to monitor. An eTag for me is simply an MD5 or hash of a bunch of data. If your MD5 value is different, then it means there was a change. If not then it is unlikely ...; Created on 19 September 2021
16. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; Created on 03 June 2021
17. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... example, if it says zoho.com, then this means the US datacenter. If it says zoho.eu, then this is the EU datacenter. If it says zoho.in, then this is the India datacenter. View the attached if ...; Created on 12 August 2020
18. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; What? An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...; Created on 27 September 2019
19. MS Excel - Open CSV with Long Numbers: / Excel /; ... as text file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with ...; Created on 23 July 2019
20. GDPR Privacy Policy: / Static Items /; ... by you or any third party. RISK OF LOSS All items purchased from MYCOMPANY are made pursuant to a shipment contract. This basically means that the risk of loss and title for such items pass to you upon ...; Created on 14 February 2019