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

06 August 2024 to create a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed document attached to the initial record (where the button was). Why? If anyone has the envious task of...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 99 U+00D6 Ö latin capital letter o with diaeresis 154 9A U+00DC Ü latin capital letter u with diaeresis 155 9B U+00A2 ¢ cent sign 156 9C U+00A3 £ pound sign 157 9D U+00A5 ¥ yen sign 158 9E U+20A7 ₧ peseta sign 159 9F U+0192 ƒ latin small letter f with...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that when this field is...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 %SearchButton_Over% } return DisplayToolTip: SetTimer, DisplayToolTip, Off ToolTip % %CurrControl%_TT ; The leading percent sign tell it to use an expression. SetTimer, RemoveToolTip, 3000 return RemoveToolTip: SetTimer, RemoveToolTip, Off ToolTip...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 Under "Parameter Value" type the exact same name of your SSRS parameter prefixed with a square bracket and the at sign and then suffixed with a closing square bracket (in my example: [@StudentReference]). 4d. Add a dataset: returned "Fields" These is...

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

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

12 October 2010 these fees. You’ll most likely never get the product and will lose any money you paid. Always remember, «CompanyName» is designed for meeting up to deal with people in your neighbourhood face to face. Work from home. Some work from home opportunities...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 as other forums and websites that try to explain it. Do not waste your time like I did on the public key, verifying a JWT signature, or including any third-party libraries. You can do it in pure PHP and all you need is the JSON key that you generated in...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 € Euro currency 0128 ¥ Japanese Yen 0165 ƒ Dutch Florin 0131 ¤ Generic currency symbol 0164...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 to my own. And I'm not just adding content, the way I'm doing the below is nothing similar to what I googled (probably a bad sign but time is ticking and no one has forever). Situation: I have a report which I've already completed and pretty chuffed...

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

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

28 June 2011 a year. My websites don't depend on real-time screenshots and the sites I link to don't generally change their website design everyday... It's 100% FREE Open Source, (well as long as you have your own internet connection) mainly because it's not just my...

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

Basic Joomla 2.5 Mootools Formhttps://joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 UPDATE 2012 It is important to refer to the correct mootools scripts in order for this to work. Unfortunately, clients who sign up to template providers who disallow access to their support forums after the subscription period expires are on the rise....

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

Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in SQL for future use: Character Description \0 An ASCII NUL (0x00) character. \' A...

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

Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I...

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

Country Lookup by IP address CSVhttps://joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the level of interest.

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

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

14 May 2013 not using any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign up for FREE at AreYouAHuman.Com: Basic Signup: Signup and you will...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign up for FREE at AreYouAHuman.Com: Basic Signup: Signup and you will...

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

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 dir jdk* Change directory to the JDK folder cd jdk Change to bin folder cd bin Note the name of the JKS file you use to sign an uploaded app Type keytool -list -v -keystore "c:/Users//AndroidStudioProject/ (replace with your windows login and with the...

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

Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 in the account properties dialog. Add an account by selecting 'Accounts' tab and then clicking on 'Email' with the plus sign. Add your account and tick 'Manually configure server settings'. Configure server settings complete as per the image below...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 expression found COLLECTION expression Another error you may get when using the deluge script is: LIST value cannot be assigned to 'mySubform' -- or -- COLLECTION value cannot be assigned to 'mySubform' or expecting ZC_SUBFORM_70 expression found...

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