Search - Joel Lipman .Com

1. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the ...; Created on 22 September 2021
2. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have ...; Created on 03 June 2021
3. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... The important fields I wanted were some custom fields within the line items subform. Here I'm adding the parameters to ensure we get CRM records that are also pending approval or being converted. m_Params ...; Created on 17 May 2021
4. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Customization > Forms > Leave Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving ...; Created on 10 December 2020
5. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... to ensure it's all saved in the system. Create the workflow Now go to a the "Design" mode of the report that contains the forms you want to be able to merge (multiple selection) and click on the "Actions ...; Created on 06 December 2020
6. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... check your security and privacy and ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line interface (CLI) In the terminal, ...; Created on 24 October 2020
7. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ; ...; Created on 08 July 2020
8. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... it "myconnector". Ensure that as a minimum, the scope ZohoBooks.salesorders.CREATE is ticked. Click on "Authorize" Read the notice saying Creator would like access to bla bla bla and click on "Accept" ...; Created on 15 May 2020
9. 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
10. GDPR Privacy Policy: / Static Items /; ... this page. You should check this page from time to time to ensure that you are happy with any changes. This policy is effective from [date]. What we collect We may collect the following information: name ...; Created on 14 February 2019
11. 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
12. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
13. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... %A_ScriptDir% ; Ensures a consistent starting directory. #SingleInstance force ; -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- Title ...; Created on 28 January 2019
14. MySQL Transactions in PHP: / MySQL /; Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account ...; Created on 14 December 2016
15. Convert foreign characters to English alphabet: / MySQL /; ... We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE ...; Created on 13 June 2016
16. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... Ensure all text fields in the database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8 Add the charset attribute to posting HTML forms: accept-charset="utf-8" ...; Created on 25 January 2016
17. Protecting your Joomla Administrator Section: / Joomla /; ... and b) limit access to a single IP address. Note that you will need to ensure you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But just in ...; Created on 23 October 2015
18. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your Joomla v2.5.x database and website ...; Created on 12 September 2015
19. Warning: Save failed. Another menu item has the same alias: / Joomla /; ... have two items using the alias "about" and "about-us": Login to the Joomla Admin Panel and ensure any similar menu items are accounted for. Remove them if they are not used. Create the menu item that ...; Created on 13 March 2015
20. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015