Search - Joel Lipman .Com

1. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; What? An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for ...; Created on 04 November 2024
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken ...; Created on 23 May 2024
3. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table ...; Created on 07 May 2024
4. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; What? A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce ...; Created on 15 April 2024
5. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... to ZohoAnalytics using the API. The use-case here is that a client wants customers to submit ZohoDesk tickets and upload photos of the problematic product to the ticket. They then want an Analytics ...; Created on 05 December 2023
6. 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
7. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that when this field is entered and the document signed and returned, it attached the signed document ...; Created on 17 October 2022
8. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before ...; Created on 20 July 2022
9. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. ...; Created on 12 January 2022
10. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... it just wants the dropdown option equivalent (eg. "10 mins", "1 hrs") Just as a refresher if this was a task and not a call: v_ReminderDate = v_SystemAppointmentDateTime.subMinutes(15); v_ReminderStr ...; Created on 18 November 2021
11. Zoho Creator: Change Radio into Tabs: / Zoho /; ... the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have ...; Created on 22 October 2021
12. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
13. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... the client wants: iPhone res). I then found that Shopify does accept a Base64Encoded version of the image and the below is how I achieved this. How? First-off, let me list the various formats that ...; Created on 17 October 2021
14. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06 ...; Created on 30 April 2021
15. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... = row.Upload_File; // looping through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the URL l_BuildUrl = List:String(); l_BuildUrl.add(v_CreatorDownloadBase); l_BuildUrl.add(v_AppOwnerName); l_BuildUrl.add(v_AppLinkName); l_BuildUrl.add(v_ViewLinkName); l_BuildUrl.add(v_CreatorRecordID); l_BuildUrl.add(v_SubFormName ...; Created on 15 May 2020
16. A for loop within a for loop in MS-DOS: / MS-DOS /; What? A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line ...; Created on 03 October 2013
17. T-SQL Record Separator: / Transact-SQL /; ... my customer wants. What if that last row of that day was actually blank and didn't have any of the data we want in the end? The aim here then is to get the inserted blank row to always be the last one ...; Created on 11 October 2011
18. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... -- There are a few notes about running the scripts. -- A new table in Joomla 1.6+ is the `jos_assets` which wants to list -- each article, banner, category, contact, newsfeed, weblink. ...; Created on 30 January 2011
19. Error during processing - Converting Date/Time: / Transact-SQL /; ... try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants ...; Created on 13 July 2010
20. Ubuntu as a media server: / Linux /; 1. If someone wants to use Ubuntu as a home media pc connected to a tv, there is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? ...; Created on 19 September 2009