Search - Joel Lipman .Com

21. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year the week is in. Weeks which ...; Created on 06 July 2023
22. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on ...; Created on 27 April 2023
23. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // ...; Created on 29 March 2023
24. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers ...; Created on 20 March 2023
25. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... - OpenAI ChatGPT BBC News: ChatGPT bug leaked users' conversation histories 2023-03-23 PCMag UK : ChatGPT Users Report Seeing Other People's Conversation Histories [...report the payment page for ...; Created on 06 March 2023
26. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
27. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... CSV file to email for debugging purposes v_ReportCSV = "Ref,Shopify SKU,Shopify Title,Shopify Product ID,Shopify Variant ID,Shopify Inventory ID,Shopify Price,Shopify Quantity,Shopify Status,Shopify Barcode,Created ...; Created on 20 February 2023
28. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
29. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I' ...; Created on 03 November 2022
30. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...; Created on 19 October 2022
31. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where ...; Created on 18 August 2022
32. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Publish it by going to Settings > Publish > Publish Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a ...; Created on 31 March 2022
33. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...; Created on 14 February 2022
34. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called Portal_Listing_Report and I have a publish key ...; Created on 17 October 2021
35. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // ...; Created on 27 September 2021
36. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... "ZohoCreator.report.CREATE") v_AppOwner = "myCreatorAppOwner"; v_AppName = "myCreatorAppName"; v_FormName = "eBay_Webhook_Payloads"; v_ReportName = "eBay_Webhook_Payloads_Report"; m_Payload = crmAPIRequest; v_Typ ...; Created on 20 September 2021
37. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the ...; Created on 01 September 2021
38. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; What? A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing ...; Created on 01 September 2021
39. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
40. 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