Search - Joel Lipman .Com

1. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports ...; Created on 27 July 2021
2. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to ...; Created on 12 February 2010
3. Zoho Creator: Input Color Picker: / Zoho /; ... row is slightly different v_CssStyle = v_CssStyle + ".zc-Color_Picker div:nth-child(-n+30) span label span"; // first cell (white) needs a grey border v_CssStyle = v_CssStyle + ".zc-Color_Picker div:nth-child(-n+3) ...; Created on 14 October 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... allow more than 2 webhooks, then you can't use a different webhook for each event. Instead I've created the one webhook to rule them all which triggers on any event: /* ******************************************************************************* Function ...; Created on 06 August 2024
5. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the image and not ...; Created on 25 July 2024
6. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... Time: In my case, this was due to the CRM being set to a different timezone (7 hours off) and for testing purposes, I need to add the second parameter of toString() to a desired timezone. The CRM format ...; Created on 14 May 2024
7. 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
8. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets ...; Created on 22 April 2024
9. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... a rather rich HTML email signature with a profile photo included. When sending an email from CRM, they want CRM to include this rich signature (different per user) at the bottom of the email message. ...; Created on 05 December 2023
10. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted ...; Created on 14 November 2023
11. Zoho Books: System Values Maps: / Zoho /; ... of ZohoBooks for the same organization, a separate call would need to be made with a different variable org ID. /* ******************************************************************************* Function: ...; Created on 07 November 2023
12. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... and if the function is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho could introduce a removeFirst() if they change removeAll().. ...; Created on 12 July 2023
13. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID ...; Created on 06 July 2023
14. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, ...; Created on 03 July 2023
15. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023
16. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of incorrect customer (Use Email rather than ...; Created on 27 April 2023
17. ZohoCRM: Import Attachments: / Zoho /; ... of your file in the format that your CRM system is using (eg. "dd/MM/yyyy HH:mm:ss") File Name: This the file name as displayed in your CRM. For example "image001.jpg". This is different to Attachment ...; Created on 16 January 2023
18. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... the "Skills" module. This client script is triggered when the user hits the "Save" button (event: onSave) and will stop the user from saving the record and continuing if 3 different skills are not specifie ...; Created on 09 December 2022
19. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; ... you only want part of the page to display different content dynamically or on click of a button: // embeds using DIV: allows for CSS styling // embed a form loading ... // embed a report loading ...; Created on 05 May 2022
20. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... all monitors are now connected to my home PC. The way to do this might be different for you depending on the components of your PC. So here's a list of what I used: TypeComponentQuantityPrice (GBP) Reused ...; Created on 12 March 2022