Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do I...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 called Portal_Listing_Report and I have a publish key held in v_ListingPublishKey and lastly, my datacenter is .COM: URL Syntax #1 // works in eBay v_ImageSrc = "https://creator.zoho.com/file" + zoho.appuri + "Portal_Listing_Report/" + input.ID +...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the following code is an excerpt from my program which checks an online server (for IT Events during this month)...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this is response = zoho.creator.updateRecord( ownerName, appLinkName, formLinkName, id, dataMap, connectionlinkName);...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 I do it. How? So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves certain bits out. Just getting the syntax...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 or expecting ZC_SUBFORM_70 expression found COLLECTION expression How? Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task can be used in the...

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

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

20 July 2022 // get the record details for this contact record (note this is ZDK.Apps.CRM but my syntax highlighter lowercases this) var r_ContactDetails = ZDK.Apps.CRM.Contacts.fetchById(v_VendorContactID); // get the email on this contact record var v_ContactEmail...

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

Using K2 with jezReCaptcha plugin causing errorshttps://www.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 this website I just went recaptcha-happy), then there are some settings you need to change in the plugin options: Inclusion Syntax = NO Auto-verify =YES Update 16.NOV.2009 I don't see this supported anymore so I wouldn't recommend using the JezRecaptcha...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 with this see my article on overriding the MediaWiki system to allow SWF file uploads) Refer to it in an article using the syntax: Image:Example.swf(Replace the swf file name with the name of your SWF file). Download these files You can download these...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // sends...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 characters. The full set of POSIX character classes is supported. To use this operator, specify the expression using the syntax [:class:] where class is the name of the POSIX character class to search for. For example, to search for one or more...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

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

12 August 2014 yields: A colleague of mine found this ABLANK solution. It took two of us the best part of two days to come up with the SRL syntax... Our XSLT can then do the following: -- for *LookupFailed* both code and name will be blank. -- possibly use...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 articles out there and discussion forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods. Method #1: Display and access...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 delete the one highlighted in red - alternatively give it a unique name in the record). Then map the fields using the dot syntax, add these to a list, and then submit as the subform name, like in the following example (note I have applied a regex to use...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 you rename it from "Tabs" to something else, all CSS references need to be changed as well to the new name and follow the syntax .zc-NewName-group{}]. What I have (Original) I want to run some deluge (snippets below) every time the form loads, so I Go...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 The issue is that round() only rounds up decimals to integers when the datatype is an integer and not a decimal: // syntax: // v_Test9.round(2); // round(v_Test9, 2); v_Test9 = 10.0; info v_Test9.round(2); // yields 10.00 v_Test10 = 10; info...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 Candidate x JobOpening Name: Mandatory name field that we will use so as to create unique records The connection Within any syntax editor of ZohoRecruit (where you type the deluge code), there will be a "Connections" in the top grey bar that you should...

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