Search - Joel Lipman .Com

1. Zoho Creator: Add a subform while creating a record: / Zoho /; ... go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my ...; Created on 14 July 2021
2. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... + 1; } else { input.Night:ui.add(r_AvailableSlot); v_CountNight = v_CountNight + 1; v_CountTotal = v_CountTotal + 1; } } } } Done. Notes: You need the workspaces ...; Created on 23 June 2021
3. 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
4. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; Created on 03 June 2021
5. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... time and then push the creator record to Zoho Projects. How? For the following example, you will need to have setup a Zoho Oauth Connection with the appropriate authorized scopes and have access ...; Created on 30 April 2021
6. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; What? This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module ...; Created on 28 April 2021
7. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... to a Third-Party API over which I had no control. What I need to send to the 3rd-party API: { "auth": { "secret": "can_you_keep_a_secret", "key": "aaabbbbccccddddeeeeffff11112222" }, ...; Created on 03 February 2021
8. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... wrong, I have a client with ZohoCRM who upload a PDF (can be any file but is usually a PDF) to a custom module in their CRM; I then need the customer from the customer portal in a ZohoCreator app to be ...; Created on 02 February 2021
9. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which we ...; Created on 29 January 2021
10. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... = zoho.people.getRecords("P_Employee",0,200,l_SearchCriterias); Enter the code to search for and count holiday clashes: First we need the code to search for other requests with these dates, we'r ...; Created on 10 December 2020
11. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... website on how to setup a subdomain. Here is the gist of what you need to do in your respective Domain Manager system (website where you registered your domain): Setup your subdomain using th ...; Created on 17 November 2020
12. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... but it allows your client/users to edit the text of any notification without knowing any code and without needing to use your creator knowledge. I haven't been using this because I edit the content based ...; Created on 06 November 2020
13. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... devices which you'll need to tweak to display in a way other than the previous preview images. You can change the shape, content and colors used for the on/off switch but try to keep the on/off css section ...; Created on 22 October 2020
14. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... I have not found a place you cannot use this deluge script. The ZC_SUBFORM_250 error is because I am trying to assign the collection or list to the subform when I need to use "INSERT" twice: once to add ...; Created on 19 October 2020
15. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... MySQL all of which have various ways of escaping the ampersand (except for MySQL which doesn't need to and in my opinion is the best SQL). Regular expression reminder (do not use): v_SearchName ...; Created on 28 August 2020
16. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... that I know of: AU = Australia (zoho.com.au) CN = China (zoho.com.cn) EU = Europe (zoho.eu) IN = India (zoho.in) US = United States (zoho.com) Registering the App You need to do this ...; Created on 12 August 2020
17. AutoHotkey: Get Media Information and Display: / AutoHotkey /; Applies To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar ...; Created on 07 August 2020
18. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice. Why? I needed a command ...; Created on 30 July 2020
19. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What ...; Created on 08 July 2020
20. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... How? So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves ...; Created on 15 May 2020