Search - Joel Lipman .Com

1. Zoho Creator: Add a subform while creating a record: / Zoho /; What? This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create ...; Created on 14 July 2021
2. ZohoCRM: Import Attachments: / Zoho /; ... Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in CRM. This took me a while as our own documentation ...; Created on 16 January 2023
3. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... your Windows OS... Now for the BIOS: Restart your PC While it is booting up (displays NZXT logo), bash the "DEL" key every second or so. Go to "Advanced" > "Chipset Configuration" > Scroll down ...; Created on 12 March 2022
4. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the fields I mentioned earlier in the Creator form. Here's the code which should happen when the form containing this radio field loads up: // // initial CSS (hide element while it is styled) input.Form_Css ...; Created on 09 March 2022
5. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Create an entry in our new form: Access this application so you are viewing the front-end of your Creator app and go to your recently created API Integration form (tip: keep this open while you ...; Created on 14 February 2022
6. Zoho Creator: Change Radio into Tabs: / Zoho /; ... the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have ...; Created on 22 October 2021
7. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge: First of all, here's the HTML SELECT dropdown I ...; Created on 19 October 2021
8. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... My use-case scenario here is that while I could upload the link from Creator to eBay's Picture Services successfully, Shopify would not accept any links I gave it. Why not use the links that eBay returns? ...; Created on 17 October 2021
9. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... It took me a while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What I had: $ $ $ $ ...; Created on 07 October 2021
10. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... :zoho.adminuserid to :"This email address is being protected from spambots. You need JavaScript enabled to view it." subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While still on the CRM functions page, ...; Created on 20 September 2021
11. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports ...; Created on 27 July 2021
12. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... Shopify webhook payload is now in your Zoho Creator! Having used this for a while, we average about 5 seconds from when the Order is updated (with payment?) in Shopify to when it gets parsed and created ...; Created on 15 July 2021
13. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will not work with the numbers at the top of your keyboard unless you ...; Created on 03 June 2021
14. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Why? I've written this article as it took a while to achieve. The Zoho People application and its API are documented but there are problems with the documentation at the time that this article was ...; Created on 10 December 2020
15. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Init static variable { i:=-1, xDetails:={}, xDetails.SetCapacity(309) While ( i++ < 309 ) { xDetails[ objDir.GetDetailsOf(0,i) ] := i } ...; Created on 07 August 2020
16. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... "") ; loop until there are no more double spaces while InStr( v_NewName, " ") v_NewName := StrReplace( v_NewName, " ", " ") ; trim any leading/trailing spaces ...; Created on 08 July 2020
17. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a while. This is ...; Created on 28 June 2019
18. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... set original_url = new.url_alias; set url_counter = 1; while exists (select true from my_table_name where url_alias = new.url_alias) do set new.url_alias = concat(original_url, '_', ...; Created on 06 May 2019
19. GDPR Privacy Policy: / Static Items /; ... a new opportunity for marketers to strengthen their brand loyalty by focusing on consumer privacy while delivering amazing experiences. Think of it as experiential privacy — having privacy be a key part ...; Created on 14 February 2019
20. 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