Search - Joel Lipman .Com

1. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; What? This is an article to show you how to, using Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has ...; Created on 05 December 2023
2. Zoho Books: Generate Bank Text File for Download: / Zoho /; What? This is an article to document how we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? ...; Created on 02 October 2023
3. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022
4. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
5. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
6. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
7. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
8. Generate Academic Calendar using MySQL: / MySQL /; ... is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID ...; Created on 27 November 2012
9. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... so when clicked, it loads up a page in a browser (redirect from a zoho page) if(b_ValidResponse) { // // generate HTML page when clicked (please amend the following variables) v_CompanyName ...; Created on 04 November 2024
10. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... upload the file to this folder if(v_WorkdriveFolderID != "") { v_PermaLink = ""; // // generate a test CSV v_NewLineChar = hextoText("0A"); l_Csv_File = ; v_UploadFilename = " Test Upload ...; Created on 11 September 2024
11. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Y EVENT" message :v_DebugMessage ] } return ""; Related List for Custom Module Just for good measure (and because it took me an hour to write this), here's the code to generate a related li ...; Created on 06 August 2024
12. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... Why? We're assisting a client implement Zoho People as their new HR solution. Zoho Analytics is used to generate specific spreadsheets for a feed into their third-party payroll system. If the data ...; Created on 02 July 2024
13. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... than 1 second m_Payload = crmAPIRequest.toMap(); m_Blank = Map(); // // you created an app that generated a client ID and a client secret and resulted in an access token // the client secret used ...; Created on 22 April 2024
14. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... can be "Read". Click on the "Generate API Key" button Note the consumer_key and consumer_secret somewhere (these aren't displayed to you in future - so this is your one chance, or else you need to generate ...; Created on 15 April 2024
15. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... we'll generate the CSV rows and then a file; then we'll use invokeURL to upload the file. Generating the CSV Here's the simplified code to generate the CSV - note that I am replacing commas with the ...; Created on 25 March 2024
16. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... There are no contact persons associated with this Invoice. - Encountered when trying to use the send an invoice API - Need the generated invoice to pre-select a contact person to email - ...; Created on 07 March 2024
17. Zoho Books: System Values Maps: / Zoho /; What? A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then ...; Created on 07 November 2023
18. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generat ...; Created on 06 July 2023
19. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ...; Created on 27 April 2023
20. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023