Search - Joel Lipman .Com

1. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
2. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing ...; Created on 23 March 2011
3. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; So I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally ...; Created on 14 January 2011
4. Accessing a MySQL Database with Business Intelligence Development Studio: / MySQL /; ... to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source Administrator) MS Business Intelligence Development ...; Created on 05 January 2011
5. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... create task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition ...; Created on 14 May 2024
6. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... note the following: I've put some really small print here just so that you don't really read this and appreciate that we have terms and conditions like every other business. ...; Created on 07 May 2024
7. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... > REST API (link under the tabs) Click on the Add key button Give it a description, assign a user that it will run as (preferably of the admin or account that will never leave the business), and permissions ...; Created on 15 April 2024
8. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... How? So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer visits website to ...; Created on 26 January 2024
9. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... e Meeting"); // // the start time m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // // the end time m_ScheduleMeeting.put("End_DateTime",zoho.currenttime.addBusinessDay(1).addMinutes(30).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // ...; Created on 02 March 2022
10. 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
11. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use ...; Created on 02 November 2021
12. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
13. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString() connection:"ascentbusiness" ]; or l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map(); m_Data.put("data",l_Quotes); m_Data.put("trigger",[]); v_Url ...; Created on 16 June 2021
14. GDPR Privacy Policy: / Static Items /; ... deemed severable and shall not affect the validity and enforceability of any remaining condition. Website privacy policy template This privacy policy sets out how [business name] uses and protects any ...; Created on 14 February 2019
15. Joes Google Map (JGM) Downloads: / Downloads /; VersionPlatform ChangeLogOptions1.1 - Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: ...; Created on 07 September 2015
16. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it a few ...; Created on 21 August 2014
17. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
18. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; Applies to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business Intelligence Development Studio What? I recently revamped our standard ...; Created on 08 April 2014
19. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE would crash and ...; Created on 07 March 2014
20. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013