Search - Joel Lipman .Com

1. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the ...; Created on 04 October 2023
2. Excel: Extract hyperlink from link: / Excel /; What? A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert ...; Created on 06 November 2014
3. MediaWiki: MySQL to extract path to images: / MediaWiki /; What? In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, ...; Created on 06 December 2011
4. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... by creating a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics table from a query, we do the following: Login ...; Created on 09 July 2024
5. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer ...; Created on 06 February 2024
6. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... extras Just making a list of things that at-time-of-print of this article aren't in the official Zoho documentation: Query the documents folder r_MyDocuments = invokeurl [ url: "https://www.zohoapis.com/books/v3/documents?organization_id=123456789" type: ...; Created on 02 October 2023
7. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... == c_Order.Order_Date,c_Order.Order_Date.toStartOfWeek().subDay(1),c_Order.Order_Date.toStartOfWeek()).toString("w"); Additional: I'm just adding a little extra based on the further feedback, if ...; Created on 06 July 2023
8. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... or on the phone. They bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added ...; Created on 16 March 2023
9. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... and clear cached files - same result Downloaded the ZIP file from GoDaddy for the 7th time and extracted the 3 files Opened CPanel and went to the SSL/TLS manager and clicked on "Manage SSL sites" Opened ...; Created on 07 April 2022
10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... supports it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't work, then I found you need to do an extra step in ...; Created on 12 March 2022
11. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... extract user ID v_UserID = m_Webhook.get("user_info").get("id").toLong(); } // // if user ID was extracted sucessfully if(v_UserID != 0) { // // get user details (we need the profile) r_UserDetails ...; Created on 11 February 2022
12. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use ...; Created on 07 December 2021
13. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with ...; Created on 19 October 2021
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... webhooks; the following reduces that back down to 10 webhooks (1 to download each photo and base64 encode it but no extras to upload it in addition to the product update): // initialize m_Product = ...; Created on 17 October 2021
15. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run ...; Created on 24 September 2021
16. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... - SetNotificationPreferences Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/SetNotificationPreferences.html - Event Types Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/extra/stntfctnprfrncs.rqst.evntprprty.evnttyp.html ...; Created on 20 September 2021
17. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... triggering a change // ... } An extra layer: To go one step further, and only if you notice the form going slowly when it first loads (or doesn't load at all), consider adding a boolean box as ...; Created on 19 September 2021
18. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows 10 but we needed something lightweight that doesn't require any extra files and that could ...; Created on 07 August 2020
19. MySQL: Count occurrences of words in a column: / MySQL /; ... as `total`, `value` FROM ( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value` FROM ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, ...; Created on 12 March 2020
20. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... to split a string into a list by the backslash character: v_File = "C:\Documents\My_File.txt"; // want to extract My_File.txt l_FileParts = v_File.toList("\\"); info l_FileParts.get(l_FileParts.size() ...; Created on 06 February 2020