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

27 April 2014 folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher and scoring key given to you. > Save Upload the files to \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 the column name/alias (the header). It might seem trivial but 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...

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

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

30 July 2020 Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 v_Total = v_Total + v_LineItemTotal; } // // other actions you want to do after all quotes looped through // } Save your function and click on "Done" to ensure it's all saved in the system. Create the workflow Now go to a the "Design" mode of the report...

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

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

10 December 2020 functions for other Zoho apps, it would stand to reason that the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 // // return Zoho response to Shopify return {"crmAPIResponse":m_Response}; Save the function Return to the functions list and hover your mouse over the function you just created until an ellipsis/3 dot icon appears > Click on it and select REST API....

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

Zoho Creator: Assign an integration field value with an integration valuehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

27 July 2021 is a quick article to help anyone encountering this gotcha: I have an integration field, if someone changes it, I want to save the value to the record immediately. Why? If you try to update an integration field via deluge with another integration field...

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

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

02 September 2021 select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and clicking on "Save") Hover the mouse over "Quotes" and select "Quote Conversion Mapping" Map your fields that you want and click on "Save" Re-click on...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 box using your HTML knowledge (in my example, clearing the hard-coded address) Once it looks like you want, click on the "Save" then "Save Now" button in the top right of your CRM. Done... get everyone involved to check they see the change as well......

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

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 Also remove the class names "disableEditProp" and "eventNone". You should get the following: Click on "Done", then on "Save and Close". Go to the Lead Conversion Mapping page (Setup > Modules and Fields > Hover the mouse over the Leads word and click on...

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

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

05 December 2023 [ url: v_Endpoint2 type: POST parameters: m_Params.toString() headers: m_Header connection: "zanalytics" ]; info r_AddRow; } Save Script and Save the workflow Change the field type to image in the ZohoAnalytics report: Go to the Attachments Data Table...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 section. Enter a required email address to receive alerts if your Notification Endpoint URL becomes unreachable, then click Save. Enter your Notification Endpoint URL, which must use 'https' and be accessible to you, and ensure it can respond to eBay's...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 to PATH Edit your zsh file: nano ~/.zshrc Append the PATH line: export PATH="$PATH:/Users/yourname/Library/Python/3.9/bin" Save and Exit Press Control + O (write the file) Press Enter (confirm filename) Press Control + X (exit nano) Apply It source...

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

SSRS Templates in BIDS 2008https://www.joellipman.com/articles/microsoft/ssrs/ssrs-templates-in-bids-2008.html

01 April 2011 Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the folder: "C:\Program Files\Microsoft Visual Studio...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is selected. How? This needs to...

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

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

23 September 2009 mouse clicks that you can use to perform specific actions. Knowing some of the Google Chrome shortcuts listed below can help save you time. Window and tab shortcuts Ctrl+N Opens a new window. Ctrl+T Opens a new tab. Ctrl+Shift+N Opens a new window in...

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

Embed an FLV file into a web pagehttps://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 into your HTML page Replace both instances of the text "http://my.video.com/myVideo.flv" with the full url of your own FLV. Save the HTML page and publish The Code: Additional: Stop AutoPlay Thank you to Anna Moors for writing in and asking "how to stop...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: *

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 right arrow keys Press "Enter" on Boot device priority Press "Enter" on the first boot device Select "CDROM" Press "F10" to save and exit the BIOS. Load your ISO or CD into your CDROM Go to "Action" in the menubar and select "Reset..." Additional...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks! Hopefully this will save you time. I spent a whole morning following someone else's complicated connection using SQL Server Management Studio and would...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 then for color, select Expression (fx): Adding Events To do this we'll be modifying the dataset. Now would be a good time to save if you haven't yet. Let's focus on this part of the used dataset SQL script: ), Events AS ( --Create some events to place...

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