Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 for each index v_DateIndex in {1,2,3,4,5,6,7} { input.Calendar_Day_Select:ui.add(zoho.currentdate.addDay(v_DateIndex).toString("EEEE") + "" + zoho.currentdate.addDay(v_DateIndex).toString("d") + "" +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use the .addDay(), check none of these are a Sunday, and move the next few days along: thisDate = '2021-10-30'; v_Today = thisDate; v_Tomorrow =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 day in a week to get the start and end dates for each v_DayIndex in {0,1,2,3,4,5,6} { v_CheckDateStart = v_FirstMonthDate.addDay(v_DayIndex); if(v_CheckDateStart.toString("E")=="Sun") { v_DST_StartTime = v_CheckDateStart; } v_CheckDateEnd =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 in {1,2,3,4,5,6,7,8} { v_NextMonthDateFirst = v_NextMonthDateFirst.toDate(); v_NextMonthMonday = v_NextMonthDateFirst.addDay(v_MyDay); if(v_NextMonthMonday.getDayOfWeek()==2) { break; } } input.Next_Switch_Date = v_NextMonthMonday.toDate(); } } else...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Generate a loop or list of any sizehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 generated list and add dates for each index v_Index in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } // // output info l_CheckDates; // // outputs:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 midnight]) v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); // // get access token (you will need your own function here as documented in...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 I've set it to only remind on business days excluding Saturdays and Sundays but you could modify the above to simply AddDay(n) instead of AddBusinessDay(n) if your guys operate over the weekends. The task will be on the lead record as soon as it is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 m_ZCrm_ZSDoc.put("zohosign__Document_Deadline",zoho.currentdate.addDay(15)); m_ZCrm_ZSDoc.put("zohosign__Document_Status","Out for Signature"); // Request_ID is a custom field added to retrieve the document later from ZohoWriter....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *