Zoho Creator: Receive JSON via a Shopify Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 Shopify as an admin Go to Settings (left sidebar right at the bottom) Click on Notifications Scroll all the way down the page until you arrive at Webhooks Click on Create webhook Under Event select Order Update Under Format select JSON Under URL, paste...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 v_CreatorQuoteID = r_Result.get("ID"); v_LinkUrl2 = "https://creatorapp.zoho.eu/" + v_OwnerName + "/" + v_AppLinkName + "/#Page:OpenQuote?ID=" + v_CreatorQuoteID; v_QuoteRef = ifnull(r_Result.get("Quote_Ref"),"-"); v_QuoteName =...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing street 2 and shipping street 2 from the Account module to the Quote module, then on...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM Template, the table of line...

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

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 template to use... This is too many steps for some. Instead, we've been asked to create a button that sits on the view page of a record and the staff simply click on and it does all the aforementioned. How? The difficult part here was to figure out how...

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

Zoho Analytics: Set Up a Widget Displaying Sales Personhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 a deal owner and needed to repeat this for all the invoices against a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters I select on a dashboard. First you will need a table or query...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 Name" IN ( "Campaign 1","Campaign 2","Campaign 3" ) ) t2 The bigger query: Now create another query (better to refresh the page so that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign 1",...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 evaluate v_currentDate = zoho.currentdate.toString("yyyy-MM-dd"); v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page = 1; v_PerPage = 10; m_Output = Map(); l_Costs = {11,13,15,17,20}; b_DebugMode = true; l_DebugMessages = List();...

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

ZohoCRM: Using Criteria with Module Record Counthttp://mail.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://mail.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 it is intended to be all in the same function as there are references to some variables in earlier snippets of code on this page. Error(s): 2945: UPLOAD_RULE_NOT_CONFIGURED Was happening when I was trying to update the Zoho Creator record, specifically...

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

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

02 July 2024 = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics, ensuring you are on the "Home" page (click on "Home" in top menu if not), // then click on the cog icon "Organization Settings", then click on "Organization Details", //...

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

Zoho Projects: Get All Eventshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was making a call to the Events endpoint as it...

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

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

25 July 2024 optional. Click on "Create" and select "New Table / Import Data": One of the last options on the "Import Your Data" page is "Enter Data Right Away": You'll be presented with a table of about 10 columns called "Untitled-1". I enter some labels in the...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 Completion: Attach the signed document to the contact record [DEPRECATED: Please use Generic Webhook at the bottom of this page] For this, we'll create the webhook function first (this one I've called Fn - ZohoSign - Document Completed) and then make it...

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

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 the current feed. Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not the one next to your profile as that's global settings but the one next to the "Import Statement" button). There are a...

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

Changing the yourdomain.com for phpBB3http://mail.joellipman.com/articles/cms/joomla/changing-the-yourdomaincom-for-phpbb3.html

01 October 2009 This is related to the issue of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first...

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

After installing rokstories, get invalid argument 106http://mail.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...

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

Mootools - How to contain a menu sidebar between header and footerhttp://mail.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 in height. What? Basically I have a menu in a sidebar, I don't want it to overlap the header nor the footer.I have a content page next to it which changes in height dynamically (a separate mootool function to this one). How? So this is my take on it, if...

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

The greatest invention in IThttp://mail.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 twenty or thirty characters back. And it is completely useless if your mistake is ancient history." - Learning GNU Emacs (page 42) Undoing can itself be undone. After having undone an action, you can redo it... - Docs.Gimp.Org Synonym: redound Latin -...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *