Search - Joel Lipman .Com

1. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products). Source(s): WooCommerce ...; Created on 15 April 2024
2. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... Further, you must encode the value. Example: Consider the search term: ((Last_Name:equals:Burns,B)and(First_Name:starts_with:M)) After escaping comma and parenthesis in the value: ((Last_Name:equals:Burns\,B)and(First_Name:starts_with:M)) After ...; Created on 14 November 2023
3. 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
4. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... of your data. That being said, it's important to note that the use and distribution of trained models may be subject to legal or ethical considerations, depending on the nature of the data and the ...; Created on 06 March 2023
5. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth ...; Created on 20 February 2023
6. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Respon ...; Created on 13 February 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... mention the artist name if copying their style and If the artist is still living, then consider reaching out to or supporting the artist. Al Hirschfeld Alexander Calder Andy Warhol Arthur ...; Created on 11 February 2023
8. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a lead record with the status "New Lead". The client ...; Created on 11 February 2022
9. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
10. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... you will need to consider using a third-party server (my example here is a LAMP server): Complete webhook setup by passing 'Intent to receive' required stage. Xero will test both a valid and invali ...; Created on 10 January 2022
11. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... if I encounter any. This is simply how I fixed this error on this occasion. Consider the following code which loops through some Creator records, then loops through one of the subforms in each record: // ...; Created on 17 November 2021
12. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... r_Coql; Additional If you wanted the unique values of a picklist/dropdown, then consider an invokeUrl looping through the fields settings in CRM. Source(s): Zoho CRM Developer Docs API v ...; Created on 08 October 2021
13. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... = zoho.encryption.md5(l_FieldsToMonitor.toString()); // // now compare to stored eTag if(v_eTag != input.eTag) { input.eTag = v_eTag; // do the main code that takes into consideration all the fields ...; Created on 19 September 2021
14. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... Consider the following: v_TestDate = "07/01/1975"; info v_TestDate; info v_TestDate.toDate(); info v_TestDate.toString("E, d MMM yyyy"); info "*********************"; // // regex change dd/MM/yyyy ...; Created on 01 September 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // ...; Created on 26 August 2021
16. ZohoCRM: Process all records of a module: / Zoho /; ... Reactivate any workflows you deactivated in step 1. Sample Code Consider the following standalone function which loops through every contact and deletes the duplicate lead (if a lead exists with ...; Created on 24 August 2021
17. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
18. 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
19. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... data. And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and ...; Created on 28 August 2020
20. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... = zoho.books.updateRecord("Invoices",v_BooksOrgID,v_InvoiceID,m_UpdateInvoice); info r_Update; Update 2023 If the above doesn't work, consider making an API call to the following endpoint: m_Params ...; Created on 10 March 2020