Search - Joel Lipman .Com

1. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023
2. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
3. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... a list based on the number of days ago (list of dates to check) l_GeneratedList = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // ...; Created on 21 March 2023
4. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign 1", cp."Campaign 2", cp."Campaign 3" FROM "Contacts" c LEFT JOIN "Contacts vs Campaigns ...; Created on 20 March 2023
5. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... output return m_Response; click on "Save Script" Test using the sidebar on the right Click on "Done" when satisfied. Click on the left arrow/caret to return to the ZohoCRM ZIA main page Clic ...; Created on 06 March 2023
6. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = 1500; // // now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ...; Created on 01 March 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other ...; Created on 11 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately will display a notification saying your migration is ...; Created on 16 January 2023
9. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... om Ref", po."Sales order ID" AS "SO ID", soi."Item ID" AS "SO Item ID" FROM "Purchase Order Items" poi LEFT JOIN "Purchase Orders" po ON po."Purchase Order ID" = poi."Purchase Order ID" LEFT OUTER J ...; Created on 03 November 2022
10. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
11. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this application mode) Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify ...; Created on 31 March 2022
12. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... fans (3 x 3-packs) but left the 2 fans included with the AIO because 7 of the fans would be on the Coolmoon controller hub and I wanted some color (not a lot, not even Storm trooper) amongst the white. ...; Created on 12 March 2022
13. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the days of the week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What ...; Created on 09 March 2022
14. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: ...; Created on 12 January 2022
15. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... my Zoho Deluge - Connect to Xero API article for setting up an app) Select "Webhooks" in the left sidebar menu Tick "Contacts" and "Invoices" and enter the Delivery URL as the REST API Function you noted ...; Created on 10 January 2022
16. Zoho Creator: Change Radio into Tabs: / Zoho /; ... = v_Css + ".zc-Tabs-group label.choice-label-text"; // make labels have rounded top-left corners v_Css = v_Css + ".zc-Tabs-group label.choice-label-text"; // make labels have rounded top-right corners v_Css ...; Created on 22 October 2021
17. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... on In the left button menu, click on Header Scroll down and click on Shipping Address Format (Custom) Enter the following placeholders: $ $ $ $ $ $ $ Done Source(s): The brilliant ...; Created on 07 October 2021
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... be notified if feedback is left: OAuth Method (requires contacting eBay to enable this once run) void API.fn_eBayQuery_SetNotificationPreferences() { /* Function: fn_eBayQuery_SetNotificationPreferences() ...; Created on 20 September 2021
19. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... "v_Filter" appears to do absolutely nothing but I've left it in there in case one day I figure it out: // init m_CreateSO = Map(); v_SalesPersonID = ""; // // eval v_BooksOrgID = 12345678901; r_SoDetails ...; Created on 30 August 2021
20. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... (left sidebar right at the bottom) Click on Notifications Scroll all the way down the page until you arrive at Webhooks Click on Create webhook Under Event select Order Update Under Format ...; Created on 15 July 2021