Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... to the end user, and when they finish signing it, it attaches automatically back on to the record?... It is possible. The article below documents it but as this is a fair bit of coding, you may want ...; Created on 06 August 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... and then wait for it to finish building the table. If you want the Zoho SQL (Ansi-SQL?) used to link the purchase order items with the sales order items based on the custom lookup field: SELECT ...; Created on 09 July 2024
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
4. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
5. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // check if end date is specified and if it is then add to this row v_EndDate = null; v_EndDateValue = ZDK.Page.getField('Actual_Finish_Date').getValue(); if (v_EndDateValue !== null) ...; Created on 09 December 2022
6. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... label[elname='radioEl_zc-Calendar_Day_Select_9']"; v_Css = v_Css + ""; input.Form_Css = v_Css; } But wait we're not finished as there are the chevrons / less-than greater-than signs options to program ...; Created on 09 March 2022
7. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
8. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
9. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... the v2.5 system so that they can log in to the new system. -- TO ACTIVATE USERS (do NOT do this until after you have finished the migration): UPDATE `v34_db`.`v34_users` a, `jbuzzer_joellipman_live`.`jdlv2_users` ...; Created on 12 September 2015
10. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... Google Maps Activity: Change the Title to what you want (don't change the activity or layout) and click on Finish: Get yourself a developers' Google Android Maps API Key (not necessarily the ...; Created on 10 October 2014
11. Generate a Timesheet in MySQL: / MySQL /; ... day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, ...; Created on 05 December 2013
12. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PC: / iOS /; ... you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure ...; Created on 03 November 2013
13. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; Applies to: Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of ...; Created on 04 October 2013
14. AwStats Data Parser (ADP): / Product Documentation /; ... finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data ...; Created on 03 April 2013
15. Restore MSSQL Error: Database is in use: / Databases /; ... Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database ...; Created on 08 March 2013
16. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...; Created on 27 April 2012
17. Reminder on SSRS row separator: / SQL Server Reporting Services /; ... row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main ...; Created on 26 October 2011
18. T-SQL Record Separator: / Transact-SQL /; ... t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query and save results as table t1 SELECT -- ...; Created on 11 October 2011
19. List MediaWiki Articles: / MediaWiki /; ... this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS ...; Created on 22 September 2011
20. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... AS ActivityDate, MIN(s.DateTimeCreated) AS DataFrom, MAX(s.EstimateTimeFinish) AS DataTo, SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish) - TIME_TO_SEC(s.DateTimeCreated))) AS ActivityDuration, ((SUM(TIME_TO_SEC(s.EstimateTimeFinish) ...; Created on 24 August 2011