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. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... / and ensured the cursor remained as a hand to indicate clickable: div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(2) div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3) ...; Created on 09 March 2022
3. Zoho Creator: Change Radio into Tabs: / Zoho /; ... + ".zc-Tabs-group .choice-table-row"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then I need to get rid of the circles (radio inputs) but ensure the labels are still visible (I can ...; Created on 22 October 2021
4. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... I call my subform "Quoted Items" and specify this having the fields "Ref, Item, SKU, Description, Quantity, RRP, Discount, Total". Add the subform to your document and ensure that none of the fields hav ...; Created on 21 October 2021
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... %A_ScriptDir% ; Ensures a consistent starting directory. #SingleInstance force ; -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- Title ...; Created on 28 January 2019
17. 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
18. 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
19. 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
20. 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