Tip 1: Avoid the most common error while using a Lookup in Deluge.

Hi everyone,

Today, we'll look at how to compare different data types. Like other programming languages, Deluge supports seven different kinds of data types -- String, Bigint, Decimal, Timestamp, Boolean, List, and Map. To perform particular actions, we often try to compare or match two different data types.

Let's look at a simple example:

In the below given IF condition, we are trying to check if the left expression which is a text field is equal to "Jack".

if (input.name == "Jack")
{
alert "Hi Jack";
}

As both the expressions are of the same data type, the code works perfectly fine.

But, if we try to match the value in a text field(of type string) with a integer, we would get an error: In Criteria left expression is of type STRING and right expression is of the type BIGINT.

if(input.name == 2 )
{
alert "Hi Jack";
}

Another common scenario:

Users often get this error when they try to compare a Lookup value with a string. To explain this we have created two forms -- New Order Form and Record Inventory Details Form.

New Order Form - Allows you to place an order for a new product.

Record Inventory Details - Stores the information about the products you have in your inventory.

The Select Product Field in the New Order form is a Lookup field that displays product names fetched from the Record Inventory Details form.

Case 1: Here we will use Fetch Records task to fetch records from a Record Inventory Details Form and use it to auto-populate the price based on the product selected(Product_Name) from the drop down(which is a Lookup). But, we get an error as shown below.

Note: itemDetails is a collection variable which is used to store all the details of that particular product.

This is because the Lookup Field will lookup the ID of that particular record in the source Form.

Solution: Hence, to avoid this error, we need to compare the Lookup field value to the ID of base record in source form as shown in below screenshot. You can also explore our Learn Deluge Tutorial to know more about other Deluge tasks.

Hope you got a fair idea on how to compare different data types and use Lookup field to perform particular actions. Keep watching this space for more such tips.

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
[SESSION ENDED] Ask the Experts #07| Live Q&A: Building workflows with Blueprint in Zoho Creator |
Hello, Post the release of Zoho Creator Blueprint last month, we're happy to tell you that we'll be launching a new 'Ask the Experts' session on 16th September (Thursday) this month focussing on creating blueprints in Zoho Creator. The session will be
Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Community Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. Customize
Community Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
[RECORDING: Community Webinar] | Build complex reports and documents with a Zoho Creator & Zoho Writer integration | March 23, 2021
Dear developers, Report generation is an essential activity to ensure decision makers have the best information available to be able to monitor and improve performance. Enterprises may need to generate and distribute stakeholder specific documents in