Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts), make a note on its contents or embedded code specific to the template. Copy over Users: Rename the Admin ID in the new v34...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 cos there's nothing better m_Link.put("Joel",123456789012345678); // create link r_Link = zoho.crm.createRecord("Tests_X_Contacts", m_Link); } Code to Add a value to a multi-lookup (on Update Record): v_DealID = ifnull(input.p_DealID,0); if(v_DealID !=...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails = zoho.crm.getRecordById("Contacts", r_QuoteDetails.get("Contact_Name").get("id")); v_ContactFname = r_ContactDetails.get("First_Name"); v_ContactSname =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 Last Name" Now your booking form will be similar to the following: And if the account is integrated with Zoho CRM, the contacts will be pushed correctly as first name and last name rather than full name to last name: Source(s): Registration Form for...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 get customer id then Email v_BooksCustomerID = invoice.get("customer_id"); r_CustomerDetails = zoho.books.getRecordsByID("contacts",v_BooksOrgID,v_BooksCustomerID,"zbooks"); v_CustomerCheckCode = r_CustomerDetails.get("code"); if(v_CustomerCheckCode ==...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 use-case is that I need this done over a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 // // determine recipients l_ZB_InvoiceRecipients = List(); r_ZohoBooks_CustomerDetails = zoho.books.getRecordsByID("contacts",v_BooksOrgID,m_ZB_InvoiceDetails.get("customer_id"),"zbooks"); if(r_ZohoBooks_CustomerDetails.get("contact") != null) {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 (use a custom report that only has the 2 searchable fields) var config = { appName : "joes_quote_builder", reportName : "Contacts_Report_SearchableByWidget", criteria : "(Primary_Email == \"" + v_ShopifyEmail + "\" && Shopify_ID == \"" + v_ShopifyID +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 the lead record relating to reminding staff to convert the lead. // l_RelatedTasks = zoho.crm.getRelatedRecords("Tasks", "Contacts", p_ContactID); for each m_RelatedTask in l_RelatedTasks { if(!isNull(m_RelatedTask.get("Subject"))) {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 FROM "Accounts" acc ) AS t1 LEFT JOIN "Joels Image Library" img ON t1."Status" = img."Status Value" UNION ALL SELECT 'CRM Contacts' AS "DataSource", date(t2."ModifiedTime") AS "Date", t2."RecordID" AS "Record ID", t2."RecordName" AS "Record Name",...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 And then let's specify a couple of layout rules to enforce this: Login as a ZohoCRM Administrator, go to Setup > Modules > Contacts > Layout Rules > New Layout Rule Call it "If Email Blank then Mobile Required" Select the Email field as the primary...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication feature for leads and contacts but not for products. How? There may be a better way of doing this. What I'm trying to have is a generic function that will...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *