Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 This is an article to document how to get your team folder ID, retrieve information about it, and upload to it via the API. Why? The documentation is there but making sense of it, is somewhat difficult, at least for me. How? So when I was trying this, I...

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

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

10 December 2020 This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in CRM. As my client's sales team would only create sales orders in CRM and don't use the invoice module (that's for their finance team using ZohoBooks), we...

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

Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

16 October 2023 left, there will be a link saying "Manage Fields" Add a picklist field type called "Department" with the options "Hire Team", and "Sales Team". Save and Close Setup: Specify Pipeline Options Login to ZohoCRM as a system administrator > Go to Setup >...

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

Team Foundation Serverhttps://joellipman.com/articles/microsoft/tfs.html

• Type: Category
• Language: *

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 The Joomla! article will support whatever content based on however your Joomla! website is configured. My day job uses Team Foundation Server, Agile/Jira and even a bespoke project management system I wrote; so the brief for this component had to...

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

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

24 August 2011 time gets stored in... Resources...the one with the codes and resource names... Users...the one with users names... Teams...another lookup table for just the name value... The one query to rule them all SELECT CONCAT(s.LogID, ' ') AS ActivityID,...

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

How to change local folder for TFShttps://joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 for remote working.) JoelLipman.Com will create 2 development sites ("play" sites) which the project manager and his/her team can use to experiment and test. Once the production website is finalised, the following need to be agreed: Parallel running...

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

Windows 10: Shortcut Apps to Settingshttps://joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 Surface Hub Accounts ms-settings:surfacehub-accounts Session cleanup ms-settings:surfacehub-sessioncleanup Team Conferencing ms-settings:surfacehub-calling Team device management ms-settings:surfacehub-devicemanagenent Welcome screen...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 a publicly-accessible link/URL for use in your email signatures. Inputs: Loginuser Outputs: Email Scope(s): WorkDrive.team.ALL, WorkDrive.workspace.ALL, WorkDrive.files.ALL, WorkDrive.organization.READ, WorkDrive.teamfolders.ALL, WorkDrive.links.ALL,...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 }], bcc: [{ email: 'no-reply@joellipman.com', label: 'Copy for myself' }], subject: 'Greetings from the Joel Lipman team!', body: 'Hi there! I\'m the very model of a modern major general. Bye. the Team.' }); } } } catch (e) { // return error (don't...

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

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 MySQLDriverCS Type: .NET Framework Class Library Usage: MySQLDriverCS.MySQLConnection Manufacturer: MySQLDriverCS project team Standard Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended...

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

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

01 March 2011 never check the errors log? By the time, 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...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 v3 (www.opensource.org/licenses/GPL-3.0). FREE / Gratis Did I not mention this already? Support Not amazing when my support team consists of me, myself and I. Saying this I'm in discussion with commercial solutions that still haven't answered some of my...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect...

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

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

02 September 2011 a Reporting solution on a Windows XP workstation. We are connecting to a SQL Server 2008 R2 Reporting Service (SSRS) with Team Foundation Server 2010. The database with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Intelligence Development Studio 2008 (BIDS) SQL Server 2008 R2 Reporting Server (SSRS) running on Windows Server 2003 Team Foundation Server 2010 (TFS) Problem #1: Image does not appear within SSRS When previewing the report in BIDS, the photo appears...

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