Search - Joel Lipman .Com

1. Drop If Object Exists: / Transact-SQL /; ... of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF ...; Created on 03 August 2012
2. ZohoCRM: Process all records of a module: / Zoho /; ... Reactivate any workflows you deactivated in step 1. Sample Code Consider the following standalone function which loops through every contact and deletes the duplicate lead (if a lead exists with ...; Created on 24 August 2021
3. Zoho Creator: Add a subform while creating a record: / Zoho /; ... Billing_Address.country=v_AddressCountry Line_Items=c_LineItems ]; From the documentation Additional Note that any bidirectional relation field that exists will be prepopulated ...; Created on 14 July 2021
4. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) ...; Created on 02 February 2021
5. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 ...; Created on 29 January 2021
6. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What ...; Created on 08 July 2020
7. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... to work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a subform exists in the form called "Attachments" // ...; Created on 15 May 2020
8. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... to check if element exists on "removeElement" Zoho OAuth Connector Just in case you don't know how to setup a Zoho OAuth Connector, here's how you do it in CRM: Login to Zoho CRM as an administrator ...; Created on 17 March 2020
9. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... If you use POST then this adds/creates a record and if it already exists you will get a . Documentation advises that the payload is empty which is not true in my case. This is my invokeUrl: v_DataEndpoint ...; Created on 06 February 2020
10. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, ...; Created on 21 November 2019
11. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL ...; Created on 06 May 2019
12. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... until it is about to expire. Firstly, we need to check how many minutes are remaining since the access token file was last modified: // check minutes remaining $api['jwt']['token']['minutes']=0; if(file_exists($api['jwt']['token']['file'])){ ...; Created on 02 February 2019
13. 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
14. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... manage tokens function authenticate() { global $STORE_PATH; $credentials = (file_exists($STORE_PATH)) ? getStoredCredentials($STORE_PATH) : null; if (!(isset($_GET['code']) || isset($credentials)) ...; Created on 31 October 2018
15. Joes Word Cloud (JWC) Download: / Downloads /; ... 1.6.3 - Core script reverted to v1.5.2 - Styled Joomla! Admin Options into sliding panels. - Added Joomla! Admin Option: Specify border color for link. - Now checks if mb_strtolower function exists ...; Created on 07 September 2015
16. Android: Function to let user take photo or choose existing: / AndroidOS /; ... The ImageView exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java file and will display an AlertDialog ...; Created on 04 November 2014
17. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... to the name if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or ...; Created on 24 October 2014
18. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... made changes, stored it as a new one) Check the DOT for records that will be output. Check that DRE contains the rules for the DOR code you are using. Check that an ERE exists relating to the EOR ...; Created on 21 August 2014
19. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it ...; Created on 13 June 2014
20. SSRS Change Background Color of Image: / SQL Server Reporting Services /; ... first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent ...; Created on 08 April 2014