Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent to the end user, and when they finish signing it, it attaches automatically back on to the record?... It is possible....

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 the following script: -- =============================================================================== -- Description: Gets the room bookings for a week based on a given date and campus --...

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

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

24 August 2011 parameters...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets stored in... Resources...the one with the codes and resource names... Users...the one with users names... Teams...another...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 a Cliq conversation will now yield something like the following: Additional For every chat message, the OpenAI ChatGPT forgets what the context of the conversation was about: Well we can populate the list of messages so that there is a conversation...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 process where it will load the first few images and as the user scrolls down the dropdown, more are loaded. This still gets buggy on certain mobile devices as some images are over 1Mb. So I needed a tool that every time a new product is added, a...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 You may post your opinion in the thread that announces the punishment, so long as you do not flame anyone. If this thread gets out of hand, it will be closed, and you may not complain elsewhere on the board, or by other means including, but not limited...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 type you are trying to upload, or the file is too big, or this feature just isn't available to you. Note: The temporary file gets deleted when the script finishes. So the file shouldn't exist if you check after the script has completed. Do the following...

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

Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 lemon wedges Method Sift the flour and salt into a large mixing bowl with a sieve held high above the bowl so the flour gets a airing. Now make a well in the centre of the flour and break the eggs into it. Then begin whisking the eggs - any sort of...

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

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

15 November 2009 on the weblinks page. I could modify the page for categories (by default it's an ugly unordered list), but changing scripts gets overwritten in a joomla upgrade so too many changes is a hard process to keep track of. Joomla 1.6.x Responding to a comment...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

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

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

13 April 2010 advertised by Gadget Show on Five.tv). Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen. BTW I don't use the "remove device safely" rubbish as my old pen never did and it was...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to the files to create as being in this folder. ./profile5/profile5.php User - Profile -...

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

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

19 July 2011 must be calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 the check: The Plan User enters value in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 Scenario #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a literal string. So here's some ok code but it will fail if my reference data has a non-numeric value in...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 -- forename and surname parameters are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows matching the selection criteria (the parameters). The concern was that this would make the report...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 address and wanted any person visiting the old domain to be redirected to the new domain. Why? I warned that a 301 site gets removed from the Google directory and true to form Google have removed it. Not sure why nobody believed me when I raised the...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 that in our case we needed the lookups on the source database which was not the same as our staging one which this package gets as its source): -- here we are pretending the lookup tables are prefixed with "lookup_" SELECT x.[sequenceID],...

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