Search - Joel Lipman .Com

1. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... MAX(DATEDIFF(MILLISECOND, ExecutionLogStorage.TimeStart, ExecutionLogStorage.TimeEnd)), '00:00:00'), 121) AS TIME) [High] , CAST(CONVERT(CHAR, DATEADD(millisecond, MIN(DATEDIFF(MILLISECOND, ExecutionLogStorage.TimeStart, ...; Created on 03 August 2011
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a high-level overview: ...; Created on 25 March 2024
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... = "GetOrderTransactions"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // ...; Created on 27 April 2023
4. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = "GetOrders"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); m_Params.put("OrderStatus","All"); m_Params.put("SortingOrder","Ascending"); m_Params.put("CreateTimeFrom",v_OrdersFrom); m_Params.put("CreateTimeTo",v_OrdersTill); // // ...; Created on 29 March 2023
5. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when ...; Created on 01 March 2023
6. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // send order filters m_Params.put("CreateTimeFrom",v_timeFrom); m_Params.put("CreateTimeTo",v_timeTill); m_Params.put("OrderRole","Seller"); // // ...; Created on 28 February 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Lamp Gel Lighting &l;;color1> Halfrear Lighting Hard Light High Key Light Incandescent Lamp Key Light Light Pollution Low Key Light Moody Lighting Moon Light Natural Lighting Ray Tracing ...; Created on 11 February 2023
8. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... ZDK.Apps.CRM but my syntax highlighter lowercases this) var r_ContactDetails = ZDK.Apps.CRM.Contacts.fetchById(v_VendorContactID); // get the email on this contact record var v_ContactEmail ...; Created on 20 July 2022
9. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... function that can return the ebay URL of the image. Done High Level Overview Create a REST API CRM function Get Zoho CRM to create a Zoho Creator record by passing it the Inventory ID Get ...; Created on 31 March 2022
10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream ...; Created on 12 March 2022
11. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... .choice-table-cell span label:nth-child(3) span I want to highlight the current selection so I'll make this a different color (hot pink): div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)[elname='radioEl_zc-Calendar_Day_Select_2'] ...; Created on 09 March 2022
12. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status ...; Created on 11 February 2022
13. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... = "GetItemTransactions"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // ...; Created on 22 January 2022
14. 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
15. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy): You will then be shown a summary of your import: You can then ...; Created on 12 January 2022
16. Zoho Creator: Change Radio into Tabs: / Zoho /; ... = ""; // align radio options horizontally v_Css = v_Css + ".zc-Tabs-group .choice-table-row"; // fix internal padding ("Quote" was higher then other radio options) v_Css = v_Css + ".zc-Tabs-group .choice-table-cell"; // ...; Created on 22 October 2021
17. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... a slightly transparent red background (if they do, then add the field again and delete the one highlighted in red - alternatively give it a unique name in the record). Then map the fields using the dot ...; Created on 21 October 2021
18. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... = "GetMyeBaySelling"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // ...; Created on 13 October 2021
19. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... build params m_Params = Map(); // set to application or user to see the notifications for each m_Params.put("PreferenceLevel","User"); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // ...; Created on 20 September 2021
20. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This ...; Created on 22 October 2020