Search - Joel Lipman .Com

1. Infopath: / Category /; Created on 05 March 2020
2. UNC Paths in Sharepoint 2007 links: / SharePoint /; Applies to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. ...; Created on 08 November 2012
3. MediaWiki: MySQL to extract path to images: / MediaWiki /; ... name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename: select img_name, img_size, img_user_text, img_timestamp, CONCAT(SUBSTR(MD5(img_name), ...; Created on 06 December 2011
4. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just ...; Created on 21 July 2011
5. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... Off Just a note here for myself where using invokeAPI over invokeURL: // // retrieve record details r_SoDetails = invokeapi [ service :zohocrm path :"/crm/v7/Sales_Orders/" + p_SalesOrderID type ...; Created on 18 December 2024
6. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... after 4 days: No code here necessary, this screenshot shows the settings I put in as a separate workflow: Step 3: Delete transferred tasks on converted contact Having disregarded the happy path, ...; Created on 14 May 2024
7. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... = "https://creatorexport.zoho.com/file" + zoho.appuri + "Products/" + c_Product.ID + "/Photo/image-download/" + v_ProductPhoto_PublishKey + "?filepath=" + v_ProductPhotoFile; } v_ItemImgDisp = ""; // // ...; Created on 07 May 2024
8. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... + v_PublishKey + "?filepath=/" + v_DocFileName; // // Store the link to the local file as the local image - this is where we could check on file extension and substitute with PDF, DOC, XLS ...; Created on 26 January 2024
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
10. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
13. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... :zoho.loginuserid to:"Joel Lipman " subject :v_Subject message :v_Message Attachments :file:v_CSVFile ] } Error(s): ],"path":["query","productVariants","pageInfo","endCursor"],"extensions":}]} ...; Created on 20 February 2023
14. ZohoCRM: Import Attachments: / Zoho /; ... := "Date Created|Date Modified|Foreign Key|Zoho CRM ID|Original File with Path|New File with Path|Original Filename|New Filename|Display Filename|KB File Size" ; add gui Gui, New, -MinimizeBox -MaximizeBox ...; Created on 16 January 2023
15. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); / ...; Created on 21 June 2022
16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the public URL of the file on this record v_PublicUrl = "https://creatorapp.zohopublic.eu/file" + zoho.appuri + "Inventory_Photo_Report/" + input.ID + "/Creator_File/download/" + v_PublishKey + "?filepath=/" ...; Created on 31 March 2022
17. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; What? A super quick article on how to download an attachment from CRM and upload to a "file upload" field in Creator. Why? My use case here is that we are creating a Creator app that will show ...; Created on 11 March 2022
18. 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
19. Zoho CRM: Schedule a Call using Deluge: / Zoho /; What? This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to ...; Created on 18 November 2021
20. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey + "?filepath=/" + v_Filename; URL Syntax #2 // works in eBay v_ImageSrc = "https://creator.zohopublic.com" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" ...; Created on 17 October 2021