Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 block; width: 200%; margin-left: -100%; transition: margin 0.3s ease-in 0s; } .onoffswitch-inner:before, .onoffswitch-inner:after { display: block; float: left; width: 50%; height: 30px; padding: 0; line-height: 30px; font-size: 14px; color: white;...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 we need the code to search for other requests with these dates, we're going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a month in one go - increase the submonth/addmonth...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 when the form was loaded. Then I would tell Audit_Change to only trigger the workflow if it had waited about 5 seconds till after this datetime to allow auto-updates to happen. This method is fine for 1 or 2 fields and if your workflows only trigger...

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

Amazon Kindle: Send PDFs to your Kindlehttp://mail.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 need to do. Go to the official Amazon home page that applies to your region. Sign in with your Amazon username and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home...

• Type: Article
• Author: Joel Lipman
• Category: Kindle
• 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 level, create another folder called "Profile Photos". Navigate into the "_Global" folder and note the last hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as specified in the function...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 Settings" Click on any page in the left sidebar (eg. Plan Details), your Org ID is in the URL as the last number after the slash (eg. "20012345678") Note this down for later use Create a connection to Zoho Analytics: ZohoDesk > Setup > Developer Space >...

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

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 = "https://analyticsapi.zoho.com"; // // to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics,...

• 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 span label span{width:14px;height:14px;margin-right:2px;border:1px solid #eee !important;}"; // create a new row after every 10 boxes (1 box = choice-table-row + choice-table-cell + choice-table-row = 3 divs) v_CssStyle = v_CssStyle + ".zc-Color_Picker...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Integration cannot be marked Inactive Summary In this case, the client’s bank account had previously been syncing correctly. After several weeks, however, the feed stopped updating, and the option to Refresh Feed was missing entirely from the Banking...

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

View your available module positionshttp://mail.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

15 September 2009 installed a template for Joomla and spent hours working out where or how you are going to put what where, try adding ?tp=1 after your index.php url (ie. http://www.yourdomain.com/?tp=1) If this doesn't work for you try this: Log in to the backend of...

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

Keyboard and mouse shortcuts in Google Chromehttp://mail.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or Ctrl+E Places a '?' in the address bar. Type a search term after the question mark to perform a search using your default search engine. Click the address bar, then press Ctrland the left...

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

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 be used to store the phpBB3 system. For installation purposes, this mysql user has been granted all privileges (change this after a successful install and remove system privileges such as "drop table"). Upload the compressed file to your...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in...

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

Error during processing - Converting Date/Timehttp://mail.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 Properties. Find your parameters in the Query. Check that there are no apostrophes enclosing the parameters. Before: After:

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 and will offer to ship them from an overseas location, or even get you to book seats on a plane. These are usually sought after dog breeds such as English Bulldogs, Yorkshire Terriers and Chihuahuas. These ads are usually accompanied by staged pictures....

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 I started maintaining the project, a revamp had been agreed with another web team. This has been delayed somewhat and still after 2 years there is no new site (blamed on the customer for not knowing what their application did in the first place... tut...

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

What's the problem? Amusing computer issueshttp://mail.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 me.". "Hang on its on the other side of the room.". This was a remote support job over the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was connected via...

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

List all cron jobs for all usershttp://mail.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab...

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

MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...

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

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 provided in the main report (note: main report runs with incident number as NULL, the user can then add an incident number afterwards or when the initial report was run). The confirmation page just checks with the end-user that this is what they really...

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