ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 daily 24 hours after until end date ******************************************************************************* */ // // blank map to use m_Blank = Map(); // // set timezone of this user (this CRM is set to GMT-07:00 with daylight savings in effect)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Keyboard and mouse shortcuts in Google Chromehttps://joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Google Chrome remembers the last 10 tabs you've closed. Drag a link to a tab. Opens the link in the tab. Drag a link to a blank area on the tab strip. Opens the link in a new tab. Drag a tab out of the tab strip. Opens the tab in a new window. Drag a...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 want them to load) to get the timestamp of when the queries started. IIF your result row count, if it's zero, just display blank, else, do the rest of the query. Blank out the textbox basically (execution time is kinda irrelevant when you get 0 matches)...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 We add a conditional split task to the data flow which only passes through rows from the Excel sheet which are not blank/null. Browsing the net, I found this is sometimes also used for inserting blank rows to act as dividers. Microsoft Certified...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SITS: Export field code and namehttps://joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 Using &G[COD.SRS:•|•] -- yields: -- But if CODE is not populated, -- Using &G[COD.SRS:•|•] -- also yields: The code is not blank. Doing the above, we have no way of telling whether the lookup failed or if this student does not have this field populated....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 Specify the impersonator Now for testing purposes you should leave this next variable as an empty string. If you leave this blank, the script will run through and connect to Google Drive using the Service Account. The script will work without being...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 a quick summary of what the below script does: Splits one spreadsheet to several sheets within the same workbook. Inserts a blank row at the top of each of the created sheets. Copies the header from the first sheet into the top row of each created...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

CSS Add Text to Breadcrumb Link with a Transitionhttps://joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before { opacity:0; content: ''; transition: all 1s ease;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 { l_SoapActionParts = v_SoapAction.toList("/"); v_Type = l_SoapActionParts.get(l_SoapActionParts.size() - 1); } } m_Blank = Map(); m_CreateRecord = Map(); m_CreateRecord.put("Event_Type",v_Type); m_CreateRecord.put("Payload",m_Payload.toString());...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 v_AppName = "ZohoInventory_eBayPictureServices"; v_FormName = "Inventory_Photo"; v_ReportName = "Inventory_Photo_Report"; m_Blank = Map(); m_CreatorParams = Map(); m_CreatorParams.put("Zoho_Inventory_ID",v_ItemId); r_Creator =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 && zoho.currentdate.getMonth()...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 Map(); m_Thread.put("role","user"); m_Thread.put("content",v_Message); l_Messages.add(m_Thread); // // if the message is not blank nor the trigger, send to OpenAI ChatGPT API if(!isBlank(v_Message) && v_Message!="Ask ChatGPT") { // // Need to add your...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 */ l_PhoneString = List(); v_CompanyWebsite = ""; // // get org details m_Blank = Map(); m_OrgDetails = zoho.crm.invokeConnector("crm.getorg",m_Blank); info m_OrgDetails.get("response"); if(!isNull(m_OrgDetails.get("response"))) {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 I have another connection called "zinventory" which is used here to retrieve the item/product record. // // initialize m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 from ZohoProjects. How? The bit that stumped me was making a call to the Events endpoint as it would just come back with a blank response... The reason it was blank was due to my parameters; the key item to remember is that status is a mandatory field...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 difficult, at least for me. How? So when I was trying this, I would get either "URL rule not configured" or an unhelpful blank response. Getting the folder ID This applies to if you click on "My Folders" and then checking the URL...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Make either Mobile or Email mandatoryhttps://joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 this: Login as a ZohoCRM Administrator, go to Setup > Modules > Contacts > Layout Rules > New Layout Rule Call it "If Email Blank then Mobile Required" Select the Email field as the primary field to control this rule Set the condition that the email "is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 // get the email on this contact record var v_ContactEmail = r_ContactDetails.Email; // check it isn't blank if (v_ContactEmail != "") { // display the found value in the field called "Vendor Contact Email"...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *