Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... observant among you will have noted that I'm recording the module name and module record ID on the ZohoSign Document record. Doing this at the point of the request means that I can have a generic webhoo ...; Created on 06 August 2024
2. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... it works then the connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed ...; Created on 04 October 2023
3. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... Sent Invited The catch is that our campaign names are in data rows not individual columns. How? There may be ways of doing this using the GUI and a "Pivot View" report but ...; Created on 20 March 2023
4. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Respon ...; Created on 13 February 2023
5. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... defaults certain arguments to any prompt you submit. I don't really recommend this unless you're doing a batch of images which need to match the same style and dimensions. To start, type /prefer suffix ...; Created on 11 February 2023
6. ZohoCRM: Import Attachments: / Zoho /; ... and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with ...; Created on 16 January 2023
7. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... There may be many ways of doing this, this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or ...; Created on 03 November 2022
8. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... a name, I'm calling mine joel_creator Authorize it, etc. Create a REST API CRM Function Login to ZohoCRM Go to Setup > Functions > New Function Give it a name and such, I'm doing the following Function ...; Created on 31 March 2022
9. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... supports it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't work, then I found you need to do an extra step in ...; Created on 12 March 2022
10. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
11. Zoho Creator: Change Radio into Tabs: / Zoho /; ... this code in-line of the form. If you were to embed the form on to a page, you would be free to use some reserved CSS attributes on the page style rather such as position: absolute. Because I'm doing ...; Created on 22 October 2021
12. 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
13. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... doing it), then Retrieve the ID of the created Sales Order (captured in response) Update the Shipping Address on the Sales Order in Zoho Books using the API The following is the code templat ...; Created on 22 September 2021
14. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
15. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes field. We would rather only have to update the code for 1 workflow rather than 20 workflows ...; Created on 19 September 2021
16. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as: Fatal error: Uncaught Error: Class '\Webservice\Service\Exception' not found in ...; Created on 03 February 2021
17. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... able to download this file. How? The trick to doing this is that actually you have to treat it as an attachment. As you may already know, when you queried CRM for that field, you received a JSON ...; Created on 02 February 2021
18. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which we ...; Created on 29 January 2021
19. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... we'll go into more detail: Create a function that accepts a form of records Create a workflow that understands the function parameters Create a function Why are we doing this first? Well ...; Created on 06 December 2020
20. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... need to give the full path of the custom domain (eg. https://mysubdomain.joellipman.com), I include the app owner and app name. Then you need to give them edit access by doing the following: Go to your ...; Created on 17 November 2020