Search - Joel Lipman .Com

1. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; What? This is a quick article to re-enable desktop notifications after having been prompted initially and having clicked on "Not Now". Why? I'm not sure when this prompt is supposed to prompt you ...; Created on 20 July 2022
2. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears ...; Created on 28 July 2014
3. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... it and click on the ellipsis/3 dots Select the REST API Enable REST API Note the REST API function and you can now call it from wherever. Done Additional Caveat(s) This currently does ...; Created on 31 March 2022
4. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... port at the same time, something last I built a PC was not possible. However, it was suggested that a modern motherboard BIOS allows you to enable this. It's just a setting in the BIOS if your motherboard ...; Created on 12 March 2022
5. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... to change by going to Settings > Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address Format either under "Customers and Vendors" (although this applies ...; Created on 07 October 2021
6. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... hover your mouse over the function name you just created and click on the ellipsis/three dots icon Select REST API and enable the API Key, this will return a URL that you want to copy to clipboard or ...; Created on 20 September 2021
7. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... stuff here ... eg getting data fields, generating a title and setting the title: input.Title = "Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To ...; Created on 19 September 2021
8. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; ... Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and ...; Created on 02 September 2021
9. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... in the last name field and creating a contact called "Firstname Firstname Lastname" (eg. "Joel Joel Lipman" - when Joel is not my middle name). How? This is a setting that is enabled by default in ...; Created on 01 September 2021
10. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... on it and select REST API. Enable the API Key option and click on the Copy icon to copy the url to clipboard. 3. Set up the Shopify webhook Log-in to your Shopify as an admin Go to Settings ...; Created on 15 July 2021
11. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar) ...; Created on 03 June 2021
12. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... + ":" + v_ThisFrom + "-" + v_ThisTill; } } } Note: Play around with the Status, there are "Pending", "Cancelled" (UK spelling), "Approval Not Enabled" and I think "Approved", "Rejected". We' ...; Created on 10 December 2020
13. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... want to do that, just click on the "Edit Access" tab at the top next to "Email" and then click on the "Enable Edit Access" button: Advise Zoho Creator Partner Support (This email address is being protected from spambots. You need JavaScript enabled to view it. ...; Created on 17 November 2020
14. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet at https://127.0.0.1:5000 along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. ...; Created on 24 October 2020
15. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there' ...; Created on 30 July 2020
16. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... Additional Note Just as a note to do the reverse: upload an image given a URL to an image field (prerequisite: enable the field to allow Image as "Link" not just "Local Computer" or "Camera"): for ...; Created on 14 July 2020
17. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; ... With URL rewriting enabled www.joellipman.com/index.php/4-category-alias/123-article-alias.html // What I want www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF ...; Created on 14 March 2020
18. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid ...; Created on 21 November 2019
19. Zoho Deluge - Update Creator from CRM: / Zoho /; ... (might not be the same as CRM super admin!!!) Go to Setup » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it ...; Created on 18 February 2019
20. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng ...; Created on 11 February 2019