Search - Joel Lipman .Com

21. 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
22. 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
23. 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
24. 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
25. 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
26. 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
27. 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
28. 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
29. 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
30. 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
31. 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
32. 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
33. 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
34. 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
35. 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
36. 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
37. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; ... Note that a footer exists (contains page number) because if printed, the page would end on a dataset row and continue the next page with the rest of the dataset. This footer allows for a large space ...; Created on 08 April 2014
38. T-SQL: Parse an XML value: / Transact-SQL /; ... in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 ...; Created on 27 March 2014
39. Excel: Find values in one column that are not in another: / Excel /; ... in the old column and which ones are new... Why? Consider the 3 following columns in an Excel spreadsheet: Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 ...; Created on 06 March 2014
40. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... data source" and browse to it to ensure it exists. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Parameter-Drive ...; Created on 11 November 2013