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

17 November 2021 all of them) l_AllRecords = 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...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 through relevant privacy notices presented in context and choices that are on brand. More info about GDPR. Terms & Conditions Conditions of Use Welcome to our online store! JoelLipman.com and its associates provide their services to you subject to the...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE a_condition=true ) AS my_field_name FROM another_pretend_table T-SQL SELECT STUFF( ( SELECT ',' + column_to_return_as_string FROM...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 + "Awesome Reason To Buy This #1 "; v_ItemDescDisp = v_ItemDescDisp + "Awesome Reason To Buy This #2 "; // // condition grade v_ConditionChar = ifnull(c_Quote.Grade_Condition,"C").subString(0,1); v_ConditionDisp = if(v_ConditionChar ==...

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

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

03 October 2024 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 empty" > click on the "Next" button Set Mandatory FIelds > and select "Mobile" Repeat these steps to add...

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

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

06 May 2010 Return to the Design interface (F8) Right-click on your dataset (in my case: DataSet1) Select 'Dataset Properties' Add a condition to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above...

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

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 -- If field is " Space is a big place " yields "Spaceisabigplace" Reminder: -- We're using this for a comparison condition and not trying to change the value.

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 Inputs: ** ** @TableName : Name of the table ** ** @ColumnName : Name of the column to be scrambled ** ** @WhereClause : Condition to get the set of Data to be scrambled. Can be null ** ** ** ** Outputs: ** ** The Data in @ColumnName column will be...

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

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 Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once Name the workflow > Create...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 initialize v_Index = 0; // // search in Creator v_OwnerName = ; v_AppLinkName = ; v_FormLinkName = ; v_ViewLinkName = ; v_Condition = "(Opportunities==\"" + v_DealID + "\")&&(UpdateClick==\"Yes\")"; r_SearchResults =...

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

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

16 December 2021 When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all calls Action is the function below with the parameter "p_CallID" being the Calls - Call ID...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals. When you use "equals" for multiple conditions, and if...

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

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

14 May 2024 the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition since go live and simply specified "All Leads". I'm calling my function fn_Leads_FollowUpNonConverted with the parameter...

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