Search - Joel Lipman .Com

21. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... can be workflow, approval, or blueprint. If trigger is not mentioned, the workflows, approvals, and blueprints related to the API will get executed. Enter the trigger value as [] to not execute the workflows. ...; Created on 16 June 2021
22. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... OnValidate Trigger: Function executed on the application of a leave Inputs: string p_RequestID,string p_Dept,string p_LeaveFrom,string p_LeaveTill Outputs: map/collection Date ...; Created on 10 December 2020
23. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... your action item Name the workflow Execute the action for Collection of record (this step is very important!) And you should have something like the following: Click through on "Add New Action": ...; Created on 06 December 2020
24. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... worry about knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through the installation process with the final step to move i ...; Created on 24 October 2020
25. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... File 2.txt My File 3 (2).wav My File 3.wav My File 3 (3).wav How? So if you copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate ...; Created on 08 July 2020
26. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once Name the workflow > Create Workflow Give it the code // // ********************************************************** // ...; Created on 15 May 2020
27. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... "$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP ...; Created on 06 May 2019
28. Zoho Deluge - Get Current User ID: / Zoho /; ... = userResp.executeXPath("/users/user"); if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); ...; Created on 08 April 2019
29. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then paste the below into the developer window. Ensure that your mouse cursor has focus in ...; Created on 11 February 2019
30. 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
31. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... = storeCredentials($STORE_PATH, $credentials); return $credentials; } Include the following at the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials ...; Created on 31 October 2018
32. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... // execute cURL request $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output = $response; } // close ...; Created on 29 October 2018
33. MySQL Transactions in PHP: / MySQL /; Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account ...; Created on 14 December 2016
34. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; ... $url); curl_setopt($ch,CURLOPT_POST, count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string); // execute post $result = curl_exec($ch); // close connection curl_close($ch); Things ...; Created on 28 March 2015
35. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
36. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... do this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let' ...; Created on 05 August 2014
37. Convert to Proper Case in T-SQL: / Transact-SQL /; ... can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my ...; Created on 04 June 2014
38. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
39. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... the component. public override void PreExecute() { // Debug Logging DebugLogEvent("PreExecute Started"); IDTSInput100 input = ComponentMetaData.InputCollection[0]; ...; Created on 04 October 2013
40. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... row, see my original data file here (sample data): And this is what a Data Viewer returned when executed: My columns were being pushed out of alignment (something about being displayed ...; Created on 23 April 2013