Search - Joel Lipman .Com

21. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other ...; Created on 11 February 2023
22. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... a rate without any preset values. Rates will be taken from the Opportunity record. If these are blank then enter the rates manually below: Rate Year 1.0, Rate Year 1.5, ..."); } // updat ...; Created on 09 December 2022
23. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution. How? Disclaimer ...; Created on 03 November 2022
24. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... you or may be already working for you without this issue. By changing the workflow to execute not "When any field is upddated" but "When any selected field is updated" and then selecting the fields "Status", ...; Created on 17 August 2022
25. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...; Created on 09 March 2022
26. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... if your search query string has spaces in it, the above without the small apostrophes (single-quotes) will return either a parsing error or just no data. In the line: v_GraphQl = " product } } } }" Change ...; Created on 14 February 2022
27. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... and display 12.5% instead of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there ...; Created on 08 February 2022
28. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the last element. At time of print, I ran this to retrieve 1970 active product IDs and their SKUs without erroring by going over the Zoho Deluge statement execution limit. Additional: See my ...; Created on 12 October 2021
29. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... (tested with both the keyword 'distinct' and without it with no difference in the response): // // build up COQL query v_CoqlQuery = "select Currency from Quotes where Subject!='' group by Currency"; ...; Created on 08 October 2021
30. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... it sent a payload (like a webhook) to my CRM REST API function. The following includes UserDeliveryPreferenceArray but I've successfully subscribed without this. I'm just including it because I want to ...; Created on 20 September 2021
31. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this enabled without applying the fix. So the fix is a setting: Login to Zoho Bookings as the admin ...; Created on 01 September 2021
32. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... m_Record.toString(); } Without a regex solution and the replacement back to commas then the above outputs: Actions Do you want to get rid of the annoying escaped double-quotes ...; Created on 26 August 2021
33. ZohoCRM: Process all records of a module: / Zoho /; What? A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether ...; Created on 24 August 2021
34. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... Standard as for any usual form without a redirect. Drag a decision box field on to the form; we are calling ours "Save & Close" with the field link name as "Save_and_Close" (the field link name is important ...; Created on 27 July 2021
35. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... in the Creator system. Alternative Solution without CRM A proposed solution has been to create a Zoho Creator form and publishing this for public use. Then giving Shopify the URL to the form and ...; Created on 15 July 2021
36. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... out of date at time of print, trial and error will resolve this or use our examples above. // fields required if submitting time log without start time (uses current time and adds hours to it) - date ...; Created on 30 April 2021
37. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... but it allows your client/users to edit the text of any notification without knowing any code and without needing to use your creator knowledge. I haven't been using this because I edit the content based ...; Created on 06 November 2020
38. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without ...; Created on 24 October 2020
39. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... functionality of Zoho Creator and could be seen as a 'Pure CSS' feature. I'm aiming to make a list of capabilities that can be done without loading another framework considering that Zoho Creator has their ...; Created on 22 October 2020
40. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...; Created on 28 August 2020