Search - Joel Lipman .Com

1. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... s build a ZohoCreator subform c_UsualShift = Collection(); for each v_WorkDay in m_ShiftBuildUp.keys() { info v_WorkDay; // // format the opening time and closing time v_StartTi ...; Created on 28 March 2023
2. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... select which fields to return l_OutputFields = List(); l_OutputFields.add("ItemID"); l_OutputFields.add("Title"); l_OutputFields.add("SKU"); l_OutputFields.add("QuantityAvailable"); l_OutputFields.add("SellingStatus"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // / ...; Created on 01 March 2023
3. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
4. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... and end dates for each v_DayIndex in { v_CheckDateStart = v_FirstMonthDate.addDay(v_DayIndex); if(v_CheckDateStart.toString("E")=="Sun") { v_DST_StartTime = v_CheckDateStart; ...; Created on 07 December 2021
5. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
6. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... == "Subform1") { // loop through the first subform of this record for each r_SubformRow in r_Record.mySubform1 { v_StartTime = r_SubformRow.Start_Time; ...; Created on 17 November 2021
7. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... exclude variations m_Params.put("HideVariations","true"); // // restrict what fields to return l_OutputFields = List(); l_OutputFields.add("BuyItNowPrice"); l_OutputFields.add("ItemID"); l_OutputFields.add("SKU"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // ...; Created on 13 October 2021
8. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... form v_StartTime = ifnull(input.Start_Time.toTime(),zoho.currenttime); v_EndTime = ifnull(input.End_Time.toTime(),zoho.currenttime.addHour(1)); v_Billable = if(input.Billing == "Paid", "Billable", "No ...; Created on 30 April 2021
9. Zoho Deluge: Check Time Booking Slots: / Zoho /; ... a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each thisRecord in allRecords { thisRecord_StartTime ...; Created on 05 December 2018
10. Generate a Timesheet in MySQL: / MySQL /; ... environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday ...; Created on 05 December 2013
11. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, ...; Created on 17 November 2011
12. T-SQL Record Separator: / Transact-SQL /; ... WHERE WeekNumber=wm.[WeekNumber])) AS 'Date', tt.[RoomId] AS 'Room', tt.[StartTime] AS 'Start', tt.[FinishTime] AS 'Finish', sd.[Descrip] AS 'Event Type', sd.[Notes] AS 'Booking Notes', c.[Name] ...; Created on 11 October 2011
13. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET ...; Created on 23 March 2011
14. Parameters not being used in report processing: / SQL Server Reporting Services /; ... dateadd(d, tt.[WeekDay] - 1, @baseDate)) AS 'Day', tt.[SiteId] AS 'Site', tt.[StartTime] AS 'Start', tt.[FinishTime] AS 'Finish', tt.[RoomId] AS 'Room', sd.[Descrip] AS 'Event Type', sd.[Notes] ...; Created on 07 January 2011