Search - Joel Lipman .Com

1. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... = Map(); m_Params.put("responseFormat","json"); // note how criteria column is denoted by double-quotes and a value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" + v_SalesOrderID + "'"); m_Config ...; Created on 09 July 2024
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
3. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted ...; Created on 14 November 2023
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... set first and last name v_FirstName = "BILLIE-JO"; v_LastName = "MCDONALD-O'LEARY ii OF CAMBRIDGE-worcester-OXFORD"; // // let's deal with double or triple barrelled first names v_FirstName = v_FirstName.replaceAll("-", ...; Created on 13 July 2023
5. Zoho CRM: Change System Field Length: / Zoho /; ... allowed" field and select "Inspect Element" Expand the DIV the field is in and double-click on the INPUT element (specifically the disabled="disabled" attribute), then press delete/backspace to remove ...; Created on 19 June 2023
6. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... searching the web for other art styles: Anamorphic Aquatint Avant-Garde Batik Caricature Collage Composite Concentric Conceptual Constructivism Contour Cor-Ten Steel Daguerreotype Diptych Double ...; Created on 11 February 2023
7. ZohoCRM: Import Attachments: / Zoho /; ... file(s). Ready.", 1) MsgBox, 0,Done, Copied %v_FilesCopied% of %v_FilesTotal% file(s) Return MyListView: if (A_GuiEvent = "DoubleClick") { LV_GetText(RowText, A_EventInfo, 4) Clipboard : ...; Created on 16 January 2023
8. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode = ifnull(r_Result.get("payment_mode_formatted"),""); v_PaymentDate ...; Created on 17 August 2022
9. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Cable (White) 1 £19.99 Build & Cost Breakdown Initial Build Total (functional PC, onboard GPU, 32Gb RAM, Previous O/S): £1,099.81 Second Part Build Total (GPU, RAM doubled, Windows 11 Pro, other): ...; Created on 12 March 2022
10. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", ...; Created on 08 February 2022
11. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
12. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel ...; 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: Receive eBay Order Notifications via Webhook: / Zoho /; ... Just as a double-tap, let's run my GetNotificationPreferences function above specifying the "PreferenceLevel" to "User" to see the user notifications I just created. I get the following response: 2021-09-20T20:14:17.077Z Success 1173 E1173_CORE_APINOTIFY_19146596_R1 Feedback Enable FixedPriceTransaction Enable ...; Created on 20 September 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
16. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...; Created on 16 June 2021
17. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... 0167 † Dagger 0134 ‡ Double Dagger 0135 – en-dash 0150 — em-dash 0151 ¶ Paragraph Symbol (Pilcrow) 0182 Western Languages À Uppercase A grave 0192 Ã Uppercase A tilde 0195 Ä Uppercase ...; Created on 03 June 2021
18. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... using the invokeUrl() function, the odd thing is that Zoho's request adds double-quotes to the request and escapes the other double-quotes sending something like this: { "auth": "", "data": "" } What ...; Created on 03 February 2021
19. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) ...; Created on 02 February 2021
20. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask ...; Created on 24 October 2020