Search - Joel Lipman .Com

1. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
2. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
3. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
4. Can't play music after Firmware Update Version 3.: / IT Support /; Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System ...; Created on 21 September 2009
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... record that holds my API connection details v_IntegrationRecordID = 123456789012345678; r_CrmRecord = zoho.crm.getRecordById("Integrations",v_IntegrationRecordID); v_TradingAPIVersion = r_CrmRecord.get("Compatibility_Version"); // / ...; Created on 31 March 2022
6. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... from MacOSX to Final Cut Pro (latest version 2022) and I don't have to pay for each year's software version as I do with MS Windows builds. Saying that, there are a lot of automations and applications I ...; Created on 12 March 2022
7. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? ...; Created on 14 February 2022
8. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... "$1", false); // yields -123.4567 Awesome! Recap on the Creator version: v_Test8 = 12.000; info v_Test8.toString().replaceAll("^(^-?\d+\.\d*[1-9])(0+$)|(\.0+$)", "$1", false); // yields ...; Created on 08 February 2022
9. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 22 January 2022
10. 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
11. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... HTML tags: l_TimeZones = List(); for each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later ...; Created on 19 October 2021
12. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and the below is how I achieved this. How? First-off, let me list the various formats that ...; Created on 17 October 2021
13. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 13 October 2021
14. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion ...; Created on 12 October 2021
15. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... REST API function that will forward the payload data to Zoho Creator (Yes you will need CRM version Enterprise or Zoho One [that supports functions] for this process). So first off, here's a reminder ...; Created on 20 September 2021
16. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... select JSON Under URL, paste the URL for your CRM REST API function from the steps above. Under Webhook API version I specify the one with the word Latest in the parentheses. Click on Save ...; Created on 15 July 2021
17. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... quick to do and much easier than first thought. The article below documents how to create your first widget in a MacOS environment. I aim to create a WindowsPC version of this document at some point ...; Created on 24 October 2020
18. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some ...; Created on 22 October 2020
19. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... accessible version that you want. Now you can use that value in your HTML. Method #2: Using Deluge Assuming that I have a form called "MyImages" and an image upload field that has the field link ...; Created on 14 July 2020
20. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... name exists." Version := "1.1" Width := 600 Height := 600 BgColor := "EEEEEE" FgColor := "34495E" Options := "+Caption +Border +OwnDialogs" DefltDir:= A_ScriptDir ; -------------------------------------------------------------------------------------- ; ...; Created on 08 July 2020