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

16 March 2023 reader for a payment atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as...

• 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 specified to see the results per contact person. You can only use this in another dataset which won't use a sub-query more than 2 levels deep. We're only displaying the maximum value alphabetically found in member status per contact per campaign (should...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a...

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

Zoho Deluge: Get All Orders from eBayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status...

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

Zoho Inventory: Enable Tracking using the APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A...

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

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

12 July 2023 of duplicates may easily differ to the loop of discrepancies simply because some records may be triplicates or more rather than just duplicates.

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

Zoho Books: System Values Mapshttp://mail.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it returns the ID to use. Some...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below to work, is to add a file upload field on the user...

• 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 single event: The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to get a single event record by its record ID. Note that this isn't in the...

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

Zoho Creator: Input Color Pickerhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 .customRadio+label{display:none !important;}"; // float the radio options to the left to be horizontal rather than vertical v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-cell{float:left;padding:0 !important;line-height:0...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 at the webhook endpoint would be good as well; but I couldn't spend time finding fields that can be 'placeheld', other than what the interface offers, into the template. the CRM webhook API function So let's do my favorite method of creating a REST API...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 the subject/name of the invoice to TBC when first created. Maps values from the related quote if loaded from somewhere other than converting quote to invoice.". Note that I have a workflow that when saved, uses an auto-number field, pads it with zeros,...

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

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

09 October 2025 { info "Creating Secondary Contact: " + r_CreateContact2; } } } } } // // if Xero record is more recently updated than the CRM one, then update the account if(d_XeroAccountLastUpdated >= d_CrmAccountLastUpdated) { r_UpdateCrmAccount =...

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

Splatter Logohttp://mail.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

On Gui Resize Eventhttp://mail.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 problems with the image repeating... so use moveDraw which redraws the app. This will result in flickering but it's better than if it isn't redrawing.

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

Invalid arguments passed in router.php on line 325http://mail.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The issue was that I was building my first Joomla 1.5 component and getting the...

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

The Sandpithttp://mail.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Set default parameter dates to start and end of monthhttp://mail.joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Live WebCam feed of Bournemouthhttp://mail.joellipman.com/articles/web-development/live-webcam-feed-of-bournemouth.html

30 January 2013 has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's clock is seriously off. Otherwise it's a picture from the future (see photo timestamps).

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