• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Recipe Building Questions
M

Matthew Hauck

started a topic about 5 years ago
Answered

How do you search non-case sensitive (downcase)?

When writing a recipe, you search for a field and compare it to another object. I cannot understand how the downcase formula works and keep getting errors. I changed both to formulas and just used the field name and .downcase. Is this not the proper way? The UI on the screen and the documentation are hard to understand. 

The UI asks for a field or formula, then and/or and another field or formula, so this is what I used.


Search Salesforce for Account email

If 

Salesforce Search objects.Accounts Account email c.downcase 


equals 

Wufoo New entry Email.downcase then do


I get an error of undefined method `downcase' for nil:NilClass


Best Answer
P
Patricia Guevarra said about 5 years ago

Hi Matthew,


Thanks for reaching out! That error means that you may be using the .downcase formula on a blank or empty data pill. You can instead use something like


pill.present? ? pill.downcase : ""


This means that if there is a value present in the pill, then use the value of the pill downcased, otherwise it will use an empty string. You can also place a value within the quotes according to your needs.


Does this work for you?

Answer

Patricia Guevarra

said about 5 years ago

Hi Matthew,


Thanks for reaching out! That error means that you may be using the .downcase formula on a blank or empty data pill. You can instead use something like


pill.present? ? pill.downcase : ""


This means that if there is a value present in the pill, then use the value of the pill downcased, otherwise it will use an empty string. You can also place a value within the quotes according to your needs.


Does this work for you?

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count