ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

• 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 This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the...

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

Delete related records from multiple tableshttp://mail.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 :"me+DEBUGZOHOSIGNWEBHOOK@joellipman.com" subject :"My ZohoSign Webhook - ANY EVENT" message :v_DebugMessage ] } return ""; Related List for Custom Module Just for good measure (and because it took me an hour to write this), here's the code to generate...

• 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 This is an article to apply an automation that when creating an invoice in CRM from a related quote, it maps in the fields. Why? The process should be that you go to the CRM quote record and click on "Convert" > then select "Invoice", and it should map...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: multipart/related; boundary=joes_awesome_divider', 'Authorization: Bearer ' . $access_token) ); // execute cURL request $response=curl_exec($ch1); if($response...

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

Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

26 July 2021 results or response from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being...

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

ZohoCRM: zoho.crm.searchRecords only returns certain recordshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-search-records-only-returns-certain-records.html

29 July 2021 zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The...

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

Zoho CRM: Schedule a Meeting using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 // // all day meeting m_ScheduleMeeting.put("All_day",false); // // meeting owner/host ID (can see any record related to this meeting) m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what (in this example, a lead record but can be...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 // using Analytics API v2.0 (this time with criteria) // // get contact email and related surveys r_ContactDetails = zoho.crm.getRecordById("Contacts", p_ContactID); v_ContactEmail = r_ContactDetails.get("Email"); info v_ContactEmail; // // the...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 pathfinder, or orchestration(for the Journey Builder feature). If "trigger" is not mentioned, the automation actions related to the API will get executed. Enter the trigger value as [] to not execute the workflows. [1] To remove or delete a line item...

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

Disclaimerhttp://mail.joellipman.com/static-items/disclaimer.html

30 May 2009 accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Any reliance you place on such information is therefore strictly at your...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 on a non-object in /includes/functions_display.php on line 135 sometimes line 82 or a blank page. We found this seems to be related to some Virtuemart modules we had installed (well all virtuemart modules)... Virtuemart, Joomla and this phpBB works as...

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

Alternative method of displaying Unicode in Autohotkey GUIhttp://mail.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 superscript latin small letter n 253 FD U+00B2 ² superscript two 254 FE U+25A0 ■ black square 255 FF U+00A0 no-break space Related Searches autohotkey chr

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 You can change the icon for the shortcut using the shortcut properties and browsing to the program it was created to run. Related Link(s): Elevated Program Shortcut without UAC Prompt Avoid UAC prompts by using an elevated program launcher...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 leave this as having a parent_id of 0. The fix is immediate after the change is committed to the database. NTS: Possible Related Error: "You cannot access the private section of this site"

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related SMG Run SMG from the menu system Enter a CODE (in our demo "CAPCHG") Enter a Short Name (unsure of how this is used) Enter...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 should have populated this correctly but if you are still getting problems, I have the following fields that I also use related to Google Maps v2: Last Additional Ensure that when Google asks for your Android API key, you enter the production key...

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

Joes Quicklist Weblinks (JQW) Downloadshttp://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 - Date Uploaded: Sun, 21st Aug 2011 2.0.1 - Code Overhaul: Use J16 core Mootools - Code Overhaul: Removed all CSS Popup related parameters - Parameter: Hits Prefix Text in popup - Parameter: Date Prefix Text in popup - Parameter: Popup Trigger: Weblink...

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