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 Workdrive: Getting Team Folder ID: / Zoho /; ... a timestamped duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home//teams//ws//folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url :"https://www.zohoapis.com/workdrive/api/v1/teamfolders//folders?page%5Blimit%5D=50&page%5Boffset%5D=0" type ...; Created on 11 September 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... 1: Credit Application: Template exists in ZohoSign Very quickly, let's go over the implementation plan for this scenario (where you have the template in ZohoSign with fields for the end user to complete): Add ...; Created on 06 August 2024
4. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is also referred to as the pricelist... ...; Created on 23 May 2024
5. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... Uses row.ID as the identifier to prevent duplicates. c_CheckDoc = Document[Subform_Row_ID == v_ImageRowID]; // // if exists then update if(c_CheckDoc.count() > 0) { c_CheckDoc.Image=c_ImageRow.Image; c_CheckDoc.File_field=f_DownloadFile; v_UploadFileID ...; Created on 26 January 2024
6. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
7. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... are steps as to what to add in the TXT record. How to add the TXT record itself will depend on your mail server or the domain registrar's website to manage your DNS: If no TXT record exists for the SPF, ...; Created on 04 May 2023
8. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on ...; Created on 27 April 2023
9. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... + v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url :v_SearchEndpoint type :GET connection:"my_connection" ]; v_CountExists = 0; if(!isnull(l_CheckExists.get("data"))) { for ...; Created on 08 February 2023
11. ZohoCRM: Import Attachments: / Zoho /; ... for this lookup field. - Parent Id: Ensure that CRM Record ID exists and that you are uploading the associated module CSV at the same time as the attachments (eg. if Parent Id is a CRM contact record, ...; Created on 16 January 2023
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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