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

18 August 2025 up as a message box to the sales person; but all on one line and not that readable. Using a JS Widget, we can popup a window over the Zoho CRM which displays a more clear HTML & CSS styled message box. How? There are links to how to create a widget in...

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

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

13 October 2025 v_Output = m_OutputTaxRates.toString(); } return v_Output; } fn_Xero_GetQuotes The main function that took me over half a day: string standalone.fn_Xero_GetQuotes() { /* *******************************************************************************...

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

Change div height to fit contenthttp://mail.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

COVID-19: Working from Homehttp://mail.joellipman.com/covid-19-work-from-home.html

05 July 2020 to or designed for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• 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 with an endpoint of https://www.zohoapis.com/crm/v7/Quotes. Showing Off Just a note here for myself where using invokeAPI over invokeURL: // // retrieve record details r_SoDetails = invokeapi [ service :zohocrm path :"/crm/v7/Sales_Orders/" +...

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 this website, you accept these conditions. Please read them carefully. Privacy Please review our Privacy Notice, which also governs your visit to our website, to understand our practices. Electronic Communications When you visit JoelLipman.com or send...

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

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

30 May 2009 this website you are able to link to other websites which are not under the control of Joel Lipman .Com. We have no control over the nature, content and availability of those sites. The inclusion of any links does not necessarily imply a recommendation...

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

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 customer needs. We only use this information for statistical analysis purposes and then the data is removed from the system. Overall, cookies help us provide you with a better website, by enabling us to monitor which pages you find useful and which you...

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

Using MetaMod to hide buttons from logged in usershttp://mail.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 and 'regmenu'. Edit your original menu module and select everything you want your registered users to see and then copy over to the newly created 'regmenu' module or what ever you called yours.) Make sure both menu modules are enabled. 2. Set the...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 in case this your problem too. Source: Joomla Forum: http://forum.joomla.org/viewtopic.php?f=433&t=198257 My Solution I have over 20 joomla websites on my virtual server and I haven't had this problem. I setup a website with about 20 3rd-party...

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

Using K2 with jezReCaptcha plugin causing errorshttp://mail.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 not impressed with Recaptcha as it's sound alternative doesn't work and the text form is hackable. I will be changing this over throughout the site... I may keep recaptcha for the comments feature on K2 articles but it should be considered low security.

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 to copy any files from your rocket template folder (eg. affinity) into the folder you just made (eg. copy of prosilver) and overwriting when prompted. Rename your copy of prosilver folder to the name of your new template (eg. affinity - Please, please,...

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

Remove write-protect from USB pen in Windowshttp://mail.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 this will corrupt the pen. BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year. The default setup in windows XP is that it doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT...

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

Windows 7 Aero Featureshttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 Aero Peek: Aero Peek What this is it gives you a preview of windows in a thumbnail without actually opening them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window, this also works with tabs in...

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

Formatting a date in an MDX queryhttp://mail.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query: CASE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 then they will be numbered the same. Used in -- calculation to determine row record is to display on. [Order] = DENSE_RANK() OVER (ORDER BY d.[Date]), -- date used in all calculations for date d.[Date], --generates matrix columns [WeekDay] =...

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

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

23 March 2011 as a minimum the 4 fields "Room", "EventStart", "EventFinish", and "Status" ("Tooltip" was for me so that when the user hovers the mouse over the block it will display the details). I've used a UNION clause which will hopefully make all rooms (even...

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

CSS keeping the footer at the bottomhttp://mail.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 side by side. But the footer that has a background image was under the left and right columns... The main content layer was overlapping the footer. I tried various z-index's bearing in mind that the footer has to be behind because the main content had a...

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 WM_IME_CHAR = $0286 Const WM_IME_REQUEST = $0288 Const WM_IME_KEYDOWN = $0290 Const WM_IME_KEYUP = $0291 Const WM_MOUSEHOVER = $02A1 Const WM_MOUSELEAVE = $02A3 Const WM_CUT = $0300 Const WM_COPY = $0301 Const WM_PASTE = $0302 Const WM_CLEAR = $0303...

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

Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 led me to browse MSDN for an hour before I realised all those experts were using programming solutions that seemed a bit over the top for something that should be so simple. Hey presto, I found a cheat/workaround: Click on the list to see your datasheet...

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