Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 :"https://www.zohoapis.com/books/v3/settings/paymentterms?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; info r_PaymentTerms; } Deprecated pre domain change: void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID = "12345678901";...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 Weeks which overlap at the end/start of the year need to be observed. As per the documentation: dateValue = '29-Dec-2019'; info dateValue.toString("yyyy"); // returns 2019 dateValue = '29-Dec-2019'; info dateValue.toString("YYYY"); // returns 2020 You...

• 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 { v_CountDuplicates = l_Customers2.size() - l_Customers1.size(); v_Grammar = if(v_CountDuplicates == 1,"","s"); info v_CountDuplicates + " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // //...

• 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 setup screen. Under "Automation", click on "Scheduler" Click on the "Add Scheduler" button Complete the "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at...

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

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

22 July 2024 you can send to. Here's some code to get the last 50 events: // // *********************************** // get Zoho Projects information v_BaseURL = "https://projectsapi.zoho.com"; v_Heading = ""; // // get all portals v_EndpointPortals = v_BaseURL +...

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

Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 + "/orders/" + p_OrderID + ".json"; r_GetOrder = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; info r_GetOrder; Now Continuing... Using the API Admin Access Token: r_ShopifyAPI = API_Integration[Connection_Name == "Shopify API"]; v_ClientID...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 our sales team to be able to click on a button off the CRM account record which will call an API returning all the credit information about a company. Unfortunately, if you do this simply using Zoho Deluge in a button, there are no new lines/carriage...

• 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 for each r_User in l_Users { if(r_User.get("email")==zoho.loginuserid) { v_CurrentUserID = r_User.get("id"); } } info v_CurrentUserID; Method #3: getRecords("users") // get current user id m_UserTypes = Map(); r_Response = zoho.crm.getRecords("users");...

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

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 ":" + v_CreatorTime.toString("Z").subString(3); // OR (2023) v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ssXXX"); info v_CrmTime; // yields 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 run out). If you made the thread because you need help with something, you may post again as long as you include additional information about your problem (the fact that you really really want it fixed does not count as additional information). You must...

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

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

28 September 2009 http://www.mysite.com/phpBB3/includes/acp/acp_joomla.php http://www.mysite.com/phpBB3/includes/acp/info/acp_joomla.php http://www.mysite.com/phpBB3/language/en/mods/acp_joomla.php Log into the phpBB3 Administration Control Panel. Based on the phpBB3...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 settings > Next Select 'Flash (SWF/FLV) - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on...

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

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

25 February 2010 on space allocation - usually ~100Mb)? List all email addresses please (limited as these include reply-from - eg. info@mydomain.com) Webmail or do you have standalone clients (eg. Outlook, Thunderbird, Eudora) For Joellipman.com to do: Submit connection...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 in case to my own site available for non-registered members at http://www.joellipman.com/features/downloads.html?func=fileinfo&id=12. Install IE7 from Microsoft's website. Reboot if necessary Navigate to http://browsers.evolt.org Scroll down to...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 tt.[StartTime] EventStart', tt.[FinishTime] EventFinish, CONVERT(VARCHAR(2), tt.[Status]) AS Status, 'Details and other information' AS Tooltip FROM [SLOTDETAILS] sd INNER JOIN [TIMETABLE] tt ON tt.[SlotId] = sd.[SlotId] and tt.[SetId] = sd.[SetId]...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 April 2011 (C) 2011 JoelLipman.Com. All rights reserved. GNU General Public License version 2 or later; see LICENSE.txt info@joellipman.com www.joellipman.com 1.6.0 PLG_USER_PROFILE5_XML_DESCRIPTION profile5.php index.html profiles...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 moderators, posts/topics, and opening any other can of worms, etc). Either use the website to contact me or email me at info@joellipman.com. I will do my best to get back to you as soon as I can so that we at least open a line of communication. If...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 Ever had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 SSRS and then resorted to my old methods of debugging. For those of you who don't know what a cursor is, you can find this info on another site as this article focuses on getting an Oracle stored procedure to work with SSRS. Main Example: My stored...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over image) will need...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *