ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 listview). Add a multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you enter the deluge code): Click on "Manage...

• 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 this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the...

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

Zoho Deluge - Get Current User IDhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); email = emailNode.executeXPath("/email/text()"); if (email == zoho.loginuserid) { idNode =...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 to refuse service, terminate accounts, remove or edit content, or cancel orders in their sole discretion. Reviews, Comments, Emails, and Other Content Visitors may post reviews, comments, and other content and submit suggestions, ideas, comments,...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 will go to when they type your domain name. Important: You only need the domain name and no additional packages (not even email as our servers handle that). UK Domain Registration Services (for .co.uk, org.uk, .net.uk, etc): http://www.123-reg.co.uk/...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 r_CreateRecord = zoho.creator.createRecord(v_AppOwner,v_AppName,v_FormName,m_CreateRecord,m_Blank,"joels_connector"); /* // Email yourself as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to...

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

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 of January 2009. What we collect We may collect the following information: name and job title contact information including email address demographic information such as postcode, preferences and interests other information relevant to customer surveys...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 that still haven't answered some of my questions or even raised as issues. I'm not them; add as a comment to this article or email me and that will be the support ticket. Microsoft Windows Only I know, what has the world come to? No Linux/Mac versions...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor )...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 • Your app preferences • Any user-specified shared item What is stored on your device about you: • Your public name • Your email address • Your aircraft details and equipment • Your photos/pictures • Your preferences/settings • A private key to use...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 = v_ResultInformation.concat(" Phone: " + input.Phone_Number + " "); v_ResultInformation = v_ResultInformation.concat(" Email: " + input.Email + " "); v_ResultInformation = v_ResultInformation.concat(" Event: " + v_AppointmentType + " ");...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 at 1am starting from tomorrow (3-Jul-2024) Purpose: To warn system managers if a sync started failing. Inputs: None Outputs: Emails system manager if any failures. Date Created: 2024-07-02 (JoelLipman.com - Joel Lipman) - Initial release Date Modified:...

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

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 // // list of recipients l_WorkdriveRecipients = {"me@mycompany.com","payroll@mycompany.com"}; // for each v_RecipientEmail in l_WorkdriveRecipients { m_Header = Map(); m_Header.put("Accept","application/vnd.api+json"); m_Attributes = Map();...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 { v_CrmAccountID = r_CreateAccount.get("id"); } } // // create a contact v_SearchContactsCriteria = "Email:equals:" + if(isBlank(m_XeroContact.get("EmailAddress")),"Unknown",m_XeroContact.get("EmailAddress")); l_SearchContacts =...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 { v_CrmAccountID = r_CreateAccount.get("id"); } } // // create a contact v_SearchContactsCriteria = "Email:equals:" + if(isBlank(m_XeroContact.get("EmailAddress")),"Unknown",m_XeroContact.get("EmailAddress")); l_SearchContacts =...

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 Could not execute: /usr/sbin/sendmail Warning Registration failed: An error was encountered while sending the registration email. A message has been sent to the administrator of this site. Check you can send email from that server ERROR: Message not...

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

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Shared DataSource Upload the report to the ReportServer....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 Administrator settings, then this script will break. Once you have authorized the service account, you can then put the email of the user the service account will be impersonating. Browse to https://admin.google.com Go to Security > Show More > Advanced...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 { v_OutputMessage = v_OutputMessage + "Generated and attached file to CRM record. "; } // // to generate and send via email m_MergedData.put("subject","Document for " + r_ContactRecord.get("Salutation") + " " + r_ContactRecord.get("Last_Name"));...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 data in Zoho is the same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself: void API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10;...

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