Search - Joel Lipman .Com

1. First and Last Entry on a Page using Modulus Remainder: / Personal Home Page /; ... is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation ...; Created on 26 September 2011
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
3. Zoho Deluge: Proper Case for Names: / Zoho /; ... other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended ...; Created on 13 July 2023
4. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... need the offset so that when a user clicks on the #9 entry, the system will know this is March 9th 2022 and not June 9th 2021... To do this, we have 2 date fields which will be hidden to the user but ...; 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: 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
7. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... setup Zoho Creator entry m_Blank = Map(); m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord = zoho.creator.createRecord("my_owner","my_app","Shopify_Webhook_Payloads",m_CreateRecord,m_Blank,"joels_creator"); // ...; Created on 15 July 2021
8. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... 2. Code to push Time Log entry to Zoho Projects: Example #1: Pushing a time log with a specified start date/time (requires end time field if using): // // init (from dropdowns you have made applicable ...; Created on 30 April 2021
9. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... Webservice_rest->call_method('create_entry') #3 /home/thirdpartyapiorg/public_html/thirdpartyapi_controlpanel/user/addons/thirdpartyapi_webservice/Core/Hook/SessionsStart.php(106): Webservice_rest->__construct() ...; Created on 03 February 2021
10. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... not set a scheduled task on the expiry date/time to delete this entry for both house-keeping and security? with the following deluge if(!isnull(input.ID)) { delete from Download_File[ID == input.ID]; } ...; Created on 02 February 2021
11. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... #1: Display and access without login So the quickest is to have a form that has an image upload field. Create an entry with one image. Then... Go to Settings Publish Publish Component > Select ...; Created on 14 July 2020
12. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... the status bar v_RowCount++ SB_SetText("Generating entry #" v_RowCount ".") } ; auto fit columns LV_Modifycol(1, "AutoHdr") LV_Modifycol(2, "AutoHdr") ; update ...; Created on 08 July 2020
13. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name' Line:(99)". This indicates that the search to see if the product exists is case-sensitive, ...; Created on 21 November 2019
14. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it. 0007 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it. The code is a for loop which iterates through each row, assigning an entry for a new product ...; Created on 02 September 2019
15. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... l_AllowedEntries.add(v_thisID); } // // restore item in lookup input.myLookup = l_RememberLookup; // // repopulate lookup options (not selected items) for each r_EntryID in l_AllowedEntries { ...; Created on 28 June 2019
16. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... l_Output = List; l_Alphabet = ; l_StrLength = ; // assign a letter to a list entry for each index v_Index in l_StrLength { l_Output.add( l_Alphabet.get(randomNumber(0, ...; Created on 09 May 2019
17. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... vTotalSize := vTotalSize + A_LoopFileSize } vListingEntry := " (" autoByteFormat(vTotalSize) ")" P0:=TV_Add(vListingEntry, 0, "Icon1") Loop, Files, %MyBaseDir%\*, D { vThisFolder := MyBaseDir ...; Created on 28 January 2019
18. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
19. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
20. Android: Keytool and Google Maps displaying grey: / AndroidOS /; ... like the following (don't use this one but it will look like this): myexampleapp, 27-Oct-2014, PrivateKeyEntry, Certificate fingerprint (SHA1): B4:52:80:2B:A0:52:97:FC:6E:66:FF:61:1E:79:20:AD:4A:60:DA:FD ...; Created on 31 October 2014