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. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... + v_CrmContactID + "/Attachments/" + r_Attachment.get("id"); r_Download = invokeurl [ url :v_AttachmentEndpoint type :GET connection:"ab_crm" ]; r_Download.setParamName("file"); r_CheckIfDocumentAlreadyExists ...; Created on 11 March 2022
3. 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
4. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: ...; Created on 12 January 2022
5. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... check if already Xero Ref ID exists in CRM Contacts v_CrmContactID = 0; l_SearchResultsByRef = zoho.crm.searchRecords("Contacts","Xero_Ref_ID:equals:" + v_Xero_ResourceID); for eac ...; Created on 10 January 2022
6. Zoho Creator: Change Radio into Tabs: / Zoho /; ... > Form Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is Created or Edited (Form Event) When to trigger ...; Created on 22 October 2021
7. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called Portal_Listing_Report and I have a publish key ...; Created on 17 October 2021
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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