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 further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in this department/team: To determine the total number of...

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

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 json_Arg.Rate_Year_4_0 = v_DealRate4; // get current user to put as the new row owner (other possible values: id, full_name, email) v_CrmUser_FullName = $Crm.user.full_name; json_Arg.Rate_Change_Owner = v_CrmUser_FullName; // other fields to fill in for...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Bot Type the word /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other commands Stealth Mode To keep...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

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

05 December 2023 ]; // // let's rename the file the name of the staff member along with the file type v_FileName = m_User.get("full_name"); v_FileExtension = m_SignatureImage.get("extn"); v_FileNameFull = v_FileName + "." + v_FileExtension; // // upload to profile...

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

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 I think I have a similar article on this website but the article below documents the full process 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...

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

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

06 February 2024 Give it the following code: // attempt try { // get the ID of this record var v_ThisRecordID = $Page.record_id; // get the full name of this contact (not sure why this returns both first and last) var v_ContactName =...

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

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 cookies, but you can usually modify your browser setting to decline cookies if you prefer. This may prevent you from taking full advantage of the website. Links to other websites Our website may contain links to other websites of interest. However, once...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 other free options? We tried lots of FLV players that were usually branded or not free. These were awkward to configure a full screen button on the controls and do basic customization. Our screen recorder was also not displaying the captions of the...

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 the GUI. To display the following code in this website though, I've had to omit a lot of the HTML part. This is the code in full; apologies for the mess coding but it's a mix between HTML and autohotkey syntax (note we're making a table with 9 columns...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• 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 with object tags) Paste it 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...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 checked. Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features. Select the custom option and then select all the effects from the list below it. Hit apply and ok and...

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

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

12 October 2010 will clear into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque and the amount...

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

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 the header from "Reinventing the wheel" to the Month and Year based on this parameter: Note that I've asked it to return the full date of the parameter, this is because I will format it via the text-box properties instead of getting the expression to...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 Great! Few problems though, multiple terms are not supported; quotation marks and apostrophes may be an issue; Full PHP: $sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):""; # 2 functions...

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

Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 to your joomla database and my_wordpress_db to your Wordpress database Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p= otherwise use ?page_id=. Articles: ------...

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

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

29 September 2011 double 217 D9 U+2518 ┘ box drawings light up and left 218 DA U+250C ┌ box drawings light down and right 219 DB U+2588 █ full block 220 DC U+2584 ▄ lower half block 221 DD U+258C ▌ left half block 222 DE U+2590 ▐ right half block 223 DF U+2580 ▀ upper...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Marker". Based on the CTE above, I now need to add an actual row separating the different days which is either blank or full of hyphens/dashes. Stage #2: Replace values in last data row with blanks The trick to this is to get Stage #1 working for you...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C drive (C:\). Create an empty text file (Type "ECHO > TEMP.TXT")...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 colleagues calendars. How? Available to me I have: a Shared Calendar I can open in Outlook 2007 (the team's annual leave). full access to a SharePoint 2007 site (team portal). Steps: Open your Outlook 2007 Using MS Internet Explorer (demo below is...

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