Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 and creating a distinct list variable... But what if there are 20000+ records? The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for...

• 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 and inefficient brain The non-existent and plethora of forums not explaining how to attach a binary image to eBay eBay Developers Program - eBay Trading API v1247 - UploadSiteHostedPictures JoelLipman.Com - Zoho Creator: Public URL of an Image field /...

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

ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 m_Response.put("code",0); return m_Response; Source(s): Stripe Dashboard - Developers - API Keys Stripe Docs - Decline codes - Learn about decline codes and how to resolve them when a charge fails.

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of...

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

DBMS Random Referencehttps://joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)] FROM DUAL; option1...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 to this error is your report needs to use a datasource with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS server holding our report, we do NOT...

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