Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 = myForm[ ID != 0 ]; // // loop through these for each r_Record in l_AllRecords { // set an if condition if(r_Record.Type == "Subform1") { // loop through the first subform of this record for each r_SubformRow in r_Record.mySubform1 { v_StartTime =...

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

Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 = Map(); r_Taxes = invokeurl [ url :"https://www.zohoapis.com/books/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; for each m_Tax in r_Taxes.get("taxes") {...

• 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 // // get all portals v_EndpointPortals = v_BaseURL + "/restapi/portals/"; r_Portals = invokeUrl [ url: v_EndpointPortals type: GET connection: "my_projects_connection" ]; info r_Portals; // // once we check the JSON, we can select a portal name and ID,...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 = invokeurl [ url :"https://www.zohoapis.com/crm/v7/Contacts/" + r_DealDetails.get("Contact_Name").get("id") type :GET connection:"zcrm" ]; // l_ContactDetails = ifnull(r_ContactDetails.get("data"), List()); for each m_ContactDetails in l_ContactDetails...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 DESC"); // // get the first page of Xero invoices v_FilterReceivables = "?where=" + zoho.encryption.urlEncode("Type=\"ACCREC\""); r_AllXeroInvoices = invokeurl [ url :v_DataEndpoint + "/Invoices" + v_FilterReceivables type :GET parameters:m_Params...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 (and grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input...

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

Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 of my code 2: The second line of my code 3: The third line of my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+ @mySearchString +''')' + CHAR(10) FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') AND TABLE_SCHEMA='dbo' ORDER BY TABLE_SCHEMA, TABLE_NAME,...

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

Batch Process to rename multiple files using Windows DOShttps://joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 Method #2 Start > Run > CMD (or COMMAND) > Enter/OK Browse to folder you want to apply to this by using the "CD" command (type "CD /?" for help) As I said, I'm going to use a short batch process (*.bat). The reason the instructions below use the command...

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

Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 unless you add it to the PATH environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir jdk* and append the \bin. Note this for later. Right-click on the...

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

Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 = 'https://api.apimo.com/api/call'; $apimo_version = 2; // specify data output $apimo_method = 'getAgencies'; $apimo_type = 'xml'; // specify key and encryption $apimo_key = 'abcd1234abcd1234abcd1234abcd1234abcd1234'; // specify your assigned key here...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 used with an invokeUrl: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection: "joelconnector" ]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 m_Data.put("To",v_CustomerNumber); // // JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it to trigger off a scheduled workflow of...

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 prepare for this, I created the following Creator form: The fields: Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for debugging (link name: Selected_Value || type...

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

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

08 February 2023 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 click on and create a connection with...

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

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

05 December 2023 r_Attachments = invokeurl [ url :"https://desk.zoho.eu/api/v1/tickets/" + p_TicketID + "/attachments" type :GET connection:"zdesk" ]; l_AttachmentDetails = ifnull(r_Attachments.get("data"),{}); for each r_Attachment in l_AttachmentDetails { m_Attachment...

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

Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 at the top of my website then login, then search for Xero. fn_Xero_MapTaxRates This function used to take a Xero TaxType name and return a Zoho Tax ID (64-bit unsigned 19 digit integer) but that's more use when writing to Zoho Books. Within ZohoCRM, we...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your SQL Server Reporting Service (SSRS)...

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

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

02 December 2011 BY t1.[TimeStamp] ASC Dataset for all reports (used for the dropdown parameters): SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the...

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