Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes"). As the actual parameter value, select the form which is the singular of the records that you are sending (in my example here I have a form...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 compare to the rows already present in the subform // first column to add in this row is start date (retrieved from field "Actual Start Date" on this record) var v_StartDateValue = ZDK.Page.getField('Actual_Start_Date').getValue(); var v_LocalStartDate...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. Eye-Level Shot puts a massive eye on the picture???) Cinematic Still Shot Full-Body shot...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 orders you think you have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 = invokeurl [ url :v_ImageSrc type :GET connection:"zdesk" ]; f_DownloadFile.setParamName("file"); // // add into subform (actual form "Document"). Uses row.ID as the identifier to prevent duplicates. c_CheckDoc = Document[Subform_Row_ID ==...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 " + v_TotalCategories + " categories across " + v_Page + " page(s)."; Additional: Total product count may differ from the actual product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google Drive: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // where is the file id The...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB