Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 the CRM webhook API function So let's do my favorite method of creating a REST API function in CRM Login to ZohoCRM > Setup > Functions > New Function Give it a function name, I'm calling mine fn_ZohoBooks_Estimates_AcceptDecline with the parameters:...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 tool for the job is a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a new survey is added... but at least it lets me synchronize every hour. Then I'll write the SQL queries...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 a few fields on the CRM contact record to store the survey metadata Login to ZohoCRM with permissions to edit modules Go to Setup > Modules and Fields > Contacts > Layout > Standard Add the section: "Latest Survey" Add to it the fields "Response ID",...

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And Vice-Versa: $posted_datetime=$_POST['this_datetime'];...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Can't play music after Firmware Update Version 3.0https://www.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable the...

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

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 (despite spanning 10 pages when printed) is on the same page. The same happens when I run this on the Reporting Server. My Setup - XP Workstation - Business Intelligence Development Studio 2008 (BIDS) - SQL Server Reporting Services 2008 R2 (SSRS) - PDF...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking...

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

UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 mapped the same drive letter to the path? Then they won't be able to use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of...

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

SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

07 November 2013 images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg. http://www.gravatar.com/my-picture), Go to your...

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

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

22 November 2013 The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 This applies to a workstation (hopefully you're not doing development directly on the server). I re-installed sql server setup, re-ran the repair to no avail. A clue came from the MS site for an older version of the pipeline in that you access the SQL...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients) Find the...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the...

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