Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 Under Device Summary, you will be shown a host of information related to your device, which includes the email address associated to your Kindle. Copy and save the email at your desired location, for that’s the email id you need to send files to for...

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

Zoho Creator: Populate a Multi-Lookuphttps://joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

18 August 2022 in l_Appointments { // // get package references specified in a previous multi-line text field l_PackageRefs = c_Appt.Associated_Package_Slips1.toList(); // // important to declare this as a list of integers l_PackagesToAdd = List:Int(); for each...

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

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

26 January 2024 for correcting any historical records, and then when given just one ticket reference; will create or update the images associated in the subform: void Standalone.fn_DownloadAndCacheAttachments(string p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,"");...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 Upload the generated file to the record Note that this is overwriting the existing record and associated file. We have no intention of creating a new record per file... Saying that, the file name will change every time it is updated as you will see....

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

Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 click on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system but important to some staff... How? In an earlier...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 - Individual Responses Query (if using CRM to send surveys) If using the CRM integration, the Survey will already be associated with an email address. If not, then see the 2nd snippet of code. SELECT concat('REF-', left_pad(to_integer(substring(r2."ID",...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 (they were on the quote and clicked on the plus next to 'invoice') if (o_InvoicedQuote != null) { // check on the quote associated to this invoice var o_QuoteDetails = ZDK.Apps.CRM.Quotes.fetchById(o_InvoicedQuote.id); console.log(o_QuoteDetails); //...

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

Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL,...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *