Search - Joel Lipman .Com

1. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. ...; Created on 15 December 2021
2. 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
3. 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
4. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; What? This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would ...; Created on 13 January 2020
5. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success", "continent": "Europe", "continentCode": ...; Created on 03 June 2019
6. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
7. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... */ // // blank map to use m_Blank = Map(); // // set timezone of this user (this CRM is set to GMT-07:00 with daylight savings in effect) v_ThisTimeZone = "Europe/London"; // // get details from ...; Created on 14 May 2024
8. 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
9. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // accommodate for timezone offset v_LocalStartDate.setMinutes(v_LocalStartDate.getMinutes() - v_LocalStartDate.getTimezoneOffset()); // return in yyyy-mm-dd format (on save this will display ...; Created on 09 December 2022
10. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; What? So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a ...; Created on 12 January 2022
11. 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
12. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) ...; Created on 11 November 2021
13. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... value is "2020-02-10T11:49:12+0100" // yields ,"message":"invalid data","status":"error"} Solution: The above ALMOST works for API and Deluge Shortcode, but we're missing the colon in the TimeZone value: ...; Created on 06 February 2020
14. Client Services: Website Development Agreement: / Static Items /; ... companies). This will have an impact on some of the systems date and time operations (eg. if you get an e-mail at 2am PST from the server, this is also 10am GMT – e-mails from people will use the timezone ...; Created on 15 November 2013
15. Unix Date Format Specifiers: / Linux /; I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) ...; Created on 05 July 2011