Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the...

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

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

12 July 2023 There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 and click somewhere on the page (not on a link as this will take you to another page) and the field returns to displaying "Name:". Why? I've noticed a lot of solutions now use JQuery or Mootools but most of these will not work in Internet Explorer 7...

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

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 data r_QuoteDetails = zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails =...

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

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

11 March 2022 Parent Record (a single line that will be a unique ref to prevent downloading the same record again and again) Document Name (a single line that will be the name of the file including its extension) Document (the file upload field) Downloaded (a...

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

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 specify the tooltip text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to change. Note that I am using the method of hiding the input button and putting an image over...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 just a serious lack of documentation as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 This should work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , e.[Parameters] AS [Parameters] , e.[ByteCount]...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

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

31 March 2022 Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it, etc. Make a workflow which does the clever...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 is sync'ing with your ZohoAnalytics: Login to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next"...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 Program Size: 1,190Kb (fits on a floppy disk) Setup/Install: None, it's portable (can run off USB or media) Program Name: WebsiteThumbnailer_v0_6.exe Prefix: JWT So I need a FREE program that simply takes pictures of some websites my website links to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 { "secret": "can_you_keep_a_secret", "key": "aaabbbbccccddddeeeeffff11112222" }, "data": { "member_id": "123456", "channel_name": "shopify", "item_name": "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending...

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 the first version of the record (sorted by ID ascending) and will attempt to delete the other records which match on product name. I would recommend commenting out the delete commands and leaving the info commands to preview what records it will delete....

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 items to invoiced items (i console logged out this line item and copied each of the fields hoping they had the same API name in both modules) o_NewLineItem.CUSTOM = o_ThisLineItem.CUSTOM; o_NewLineItem.Config = o_ThisLineItem.Config;...

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

MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename:...

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

SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0)) Staff, SUM(IF(t2.VisitorType='Student', 1, 0))...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 the Application Clearance and Decision Entry (ACD) screen. Put the cursor in the field and press F1, this will give you the name of the field, its entity and dictionary. My example below will use the Decision/date and Response/date fields (rather than...

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