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 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 the top of the IDE (where you paste the code) and...

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

What can MAGA’s do to stop Biden from cheating again?http://mail.joellipman.com/articles/_other-misc/jokes/what-can-maga’s-do-to-stop-biden-from-cheating-again.html

28 August 2024 The robot proceeds to chat about NASCAR, Budweiser, and John Deere tractors. The guy comes back a third night and this time when asked says, "About 50." The robot leans in real close and says, "Isn't it terrible the way Biden stole the election?" Source:

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

Zoho Deluge: Convert Hex to RGBhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns...

• 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 be sent via the URL as a verification to be checked 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...

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

Google Event Ilustrations aka Flairshttp://mail.joellipman.com/articles/google/google-event-ilustrations-aka-flairs.html

05 December 2024 clean the house, clean the apartment, clean house, tidy up, vacuum clean, vacuum cleaning code: learn to code, coding time, hackathon, Rails Girls, Railsgirls, Hour of Code, Codecademy, Computer Science, Programming in Python, Web Programming,...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 } It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this but the truth is that I do not have a...

• 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 value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to Sales Order (creates a new sales order)...

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

Hide Menu Item from Registered and Special http://mail.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title...

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

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

30 September 2009 do the same. It's just so complicated in Photoshop when web-developers need to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the selection on Create a new...

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

Joomla banners not rotatinghttp://mail.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 > Banner... What I do is I don't select a client but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display, consider setting categories as vertical, horizontal and square banners. This means...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 been switched to SEF in the global configuration (where all SEO settings are set to "Yes") and works fine irrespectively. In time, if I ever learn to use it properly, I may change my opinion but why complicate things...?

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

SSRS Expand specific drilldown by defaulthttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget to tick the option "display can be toggled by this report...

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

Border settings not saving in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a...

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

SSRS - Lost window with datasetshttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 the project and the window panel for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report...

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

Code Troubleshooting Checklisthttp://mail.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation since the service last worked? Suggestions by Wikipedia...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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: *

Free Translator API using Googlehttp://mail.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 So this is a quick article to get your Google Translation services working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. Microsoft's Bing has added itself to the fray pretending to...

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

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

30 January 2013 is where technology 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: *

MS Excel: Convert a text to a numberhttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 an error?!?!?!? The answer on the Microsoft website is as helpful as the Microsoft paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the VALUE() function.......

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string" parameter to "shared datasource" parameter where the user can select which...

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