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: 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... .choice-table-cell span label:nth-child(3) span I want to highlight the current selection so I'll make this a different color (hot pink): div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)[elname='radioEl_zc-Calendar_Day_Select_2'] ...; Created on 09 March 2022
13. Zoho CRM: searchRecords with sorted results: / Zoho /; ... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods ...; Created on 10 February 2022
14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... "$1", false); // yields 12.3 // same expression again but with a different value v_Test2 = 12.000; info v_Test2.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.000 So ...; Created on 08 February 2022
15. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... " + r_Event.get("eventType"); // // get the xero ID of the record (hexadecimal) v_Xero_ResourceID = r_Event.get("resourceId"); // // do different things based on the category of the update if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT")) { / ...; Created on 10 January 2022
16. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records ...; Created on 17 November 2021
17. Zoho Creator: Change Radio into Tabs: / Zoho /; ... Set Clicked Tab to Selected One niggling issue I had was that when selecting a tab, the selected tab didn't stay a different color or style. One theoretical way around this could be that I restyle ...; Created on 22 October 2021
18. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with ...; Created on 08 October 2021
19. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... $ $ and in my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test ...; Created on 07 October 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... fields of the record that I want to monitor. An eTag for me is simply an MD5 or hash of a bunch of data. If your MD5 value is different, then it means there was a change. If not then it is unlikely ...; Created on 19 September 2021