Search - Joel Lipman .Com

1. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other ...; Created on 03 June 2021
2. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...; Created on 28 August 2020
3. Hide Menu Item from Registered and Special: / Joomla /; Hide Menu Item from Registered and Special Refer to this link if you want to clean out a front-end admin interface with your website's style. The following is from http://forum.joomla.org/viewtopic.php?f=32&t=252258&start=0 at ...; Created on 06 September 2009
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Go back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders ...; Created on 06 August 2024
5. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
6. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... item and description v_ItemDescDisp = "" + c_Quote.Product.Product_Name + " "; if(c_Quote.Special_Edition.containsIgnoreCase("yes")) { v_ItemDescDisp = "SPECIAL EDITION "; } // // ...; Created on 07 May 2024
7. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... hover the mouse over it after creating the function so that you can enable the REST API endpoint of it. This will need to be triggered whenever there is an update to the order (especially when tracking ...; Created on 22 April 2024
8. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... receive and pass to the JS widget. the HTML You may note that I have additional CSS and JS files. I like to keep the copies local (especially if the hosting is included) so the app doesn't suddenly ...; Created on 14 March 2024
9. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... The workaround for staff is to round this up manually and then save the record. But this can be an annoying overhead, especially if it can be auto-corrected with a client script. Pre-amble For ...; Created on 13 December 2023
10. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... of print, this is the only way I know: add a note field to inject some CSS into it and hide the delete icon as well as the "Add new row" link. In Design mode: Add a special field of type "Add Notes" ...; Created on 28 February 2023
11. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes field. We would rather only have to update the code for 1 workflow rather than 20 workflows ...; Created on 19 September 2021
12. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; What? This is an article for training purposes. I'm pretty sure there is official documentation on how to do this but I thought I'd write this article to make it simpler for new developers to follow ...; Created on 02 September 2021
13. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function ...; Created on 01 September 2021
14. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... = r_Data.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // ...; Created on 26 August 2021
15. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... is used for but I enter the same name in lowercase and replacing special characters with an underscore. eg. "the_joel_lipman_app" Authentication Type: set this to "oauth2" Param Type: set this to "Header" ...; Created on 12 August 2020
16. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... are sending are not in the right format. : The attachment parameter is populated with the file content instead of the internal file name. : The doc parameter contains special characters. Improper ...; Created on 15 May 2020
17. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString ...; Created on 31 May 2019
18. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; ... :first { size: A4; margin: 0cm 0cm 0cm 0cm; } If this works for you then brilliant because it didn't work for me... I guess I'm special, this is what I had to do: ...; Created on 22 February 2019
19. GDPR Privacy Policy: / Static Items /; ... information to improve our products and services. We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email ...; Created on 14 February 2019
20. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... Application.ActiveSheet.Range("A1").PasteSpecial Set xRow = xRow.Offset(SplitRow) Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press ...; Created on 11 February 2019