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: 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... able to download this file. How? The trick to doing this is that actually you have to treat it as an attachment. As you may already know, when you queried CRM for that field, you received a JSON ...; Created on 02 February 2021
14. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... As someone who's been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very ...; Created on 24 October 2020
15. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually ...; Created on 16 May 2019
16. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... Which is an unintended but desired effect. Class .page: I actually like using this class because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to my template. ...; Created on 22 February 2019
17. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
18. Joes Revolver Map (JRM) Downloads: / Downloads /; ... actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values.- Date Uploaded: Fri, 30th Jul 2010 ...; Created on 07 September 2015
19. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... sold by JoelLipman.com. JoelLipman.com agents, representatives and employees are to be held harmless from any and all claims, liabilities, damages, and expenses (including attorneys’ fees actually incurred) ...; Created on 24 October 2014
20. AHK Countdown Tooltip: / AutoHotkey /; ... ThisManyWorkingDaysInMessage:=ThisManyWorkingDaysIn " day" ( ThisManyWorkingDays==1?"":"s") " you actually have to be in." ThisManyWorkingHoursMessage:=ThisManyWorkingHours " hour" ...; Created on 17 July 2014