Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... count from 0 to 4999 Observation #2: Setting a loop with leftpad limited to 100,000: Our trick of using the leftpad() method to build a list of any number is actually limited to 100000 as you will ...; Created on 31 July 2024
2. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... :file:f_AllProducts ] // return v_TotalProducts + " product(s) in " + v_TotalCategories + " categories across " + v_Page + " page(s)."; Additional: Total product count may differ from the actua ...; Created on 15 April 2024
3. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... = invokeurl [ url :v_ImageSrc type :GET connection:"zdesk" ]; f_DownloadFile.setParamName("file"); // // add into subform (actual form "Document"). ...; Created on 26 January 2024
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the ...; Created on 13 July 2023
5. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the ...; Created on 12 July 2023
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
7. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, ...; Created on 29 March 2023
8. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when ...; Created on 01 March 2023
9. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Product Photography Real Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. ...; Created on 11 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
11. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... in this row is start date (retrieved from field "Actual Start Date" on this record) var v_StartDateValue = ZDK.Page.getField('Actual_Start_Date').getValue(); var v_LocalStartDate = new Date(v_StartDateValue); ...; Created on 09 December 2022
12. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the user to be able to click and download/open ...; Created on 11 March 2022
13. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... : 5, "actualQueryCost": 5, "throttleStatus": { "maximumAvailable": 1000, "currentlyAvailable": 995, "restoreRate": 50 } } } } Additional Note th ...; Created on 14 February 2022
14. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... for outbound and inbound but local to the customer and we want to remind our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will ...; Created on 16 December 2021
15. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use ...; Created on 07 December 2021
16. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Image as attachment a base64 encoded string. Note the above says that 10 photos produced 10 webhooks but actually I'd overlooked the webhook used to invokeUrl download a Creator file so it was using 20 ...; Created on 17 October 2021
17. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement ...; Created on 12 October 2021
18. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = v_AddressIndex + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for ...; Created on 22 September 2021
19. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; ... a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom ...; Created on 17 June 2021
20. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... equivalent Creator record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? ...; Created on 16 June 2021