Search - Joel Lipman .Com

1. Standalones: / Category /; Created on 05 March 2020
2. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... US ones grouped at the top so let's remove the select and optgroup tags, escape any double-quotes, and prepend/append with a Zoho Deluge list declaration: l_TimeZoneOptions = List(); l_TimeZoneOptions.add("(GMT-10:00) ...; Created on 19 October 2021
3. Running Internet Explorer 6, 7, 8 as standalones: / Windows OS /; ... and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at home I'd just use Virtual PC with Windows7 but my customers are on XP and I ...; Created on 18 May 2010
4. Some milestones for a website project: / Web-Development /; ... developing the website. ALPHA/BETA – these are the next major milestones that represent near completed websites, these are subject to extensive testing, compatibility and QA by both the developer ...; Created on 14 April 2010
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... you will complete, and the ones that other recipients will complete Send it for your end-user to complete and sign it This comes back to a section called "ZohoSign Documents", download the attachment ...; Created on 06 August 2024
6. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... file to be hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that includes ...; Created on 25 March 2024
7. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... published Creator page (idem). CORS Policy error(s): Check your design as you can have a JS widget talking to Zoho. You won't be able to pull/download files, even published ones, but you can display ...; Created on 14 March 2024
8. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... - ??? https://workdrive.zoho.com/apidocs/v1/filefoldersharing/shareeveryone ******************************************************************************* */ l_PhoneString = List(); v_CompanyWebsite ...; Created on 05 December 2023
9. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... list of unique ones from the "all" list to be left with just the duplicates. The Code v_CountDiscrepancies = 0; // l_Customers1 = Customer[ID != 0].distinct(Customer_Name); l_Customers2 = ...; Created on 12 July 2023
10. 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
11. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... ones m_CreateBooksItem.put("track_serial_number",true); m_CreateBooksItem.put("track_batch_number",true); // // let's try creating it r_CreateItem = zoho.inventory.createRecord("items",v_BooksOrgID,m_CreateBooksItem,"zinventory"); info ...; Created on 04 May 2023
12. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... ZohoCRM webhook, because CRM webhooks run more reliably then the ones we have found in ZohoBooks and other Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes ...; Created on 27 April 2023
13. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... above within the same function to return a map. Note that this is for fixedpriceitems only. For auction ones, you would need to adjust the parsing code below to capture auction details. This includes ...; Created on 28 February 2023
14. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Product Photography Real Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. ...; Created on 11 February 2023
15. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows = ZDK.Apps.CRM.Deployment_Rate_Log.fetch(); ...; Created on 09 December 2022
16. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... TLD as com or eu depending on whether you access zoho.com or zoho.eu v_TLD = "com"; // // enter client ID, secret and refresh token as noted from above steps (the below are sample ones and will not ...; Created on 17 October 2022
17. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will happen. Here's the Zoho Deluge code I use (note that I've put this in a namespace called "DataCleansing", ...; Created on 27 January 2022
18. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can ...; Created on 15 December 2021
19. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time ...; Created on 07 December 2021
20. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; What? This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server ...; Created on 07 December 2021