• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home Formula Mode Tips & Tricks Text Manipulation Formulas

How do I handle blank or null data in my input?

Modified on: Thu, Aug 29, 2019 at 5:47 AM

When we are mapping data, sometimes we find that some data may not be available and it can lead to the recipe failing. In the example below the invoice date is mapped from a field called 'Date' and the value for Date is not always guaranteed to be there. To take care of this, you go into formula mode, by clicking on fx and key in something like the inputs below.. 



What is it doing?


1. "Date.blank?" is checking to see if the Date is blank.

2. The next ? represents the result of the check. If it is true, or false

3. The next step 'Job created at' : 'Date' specifies what to do if the result was true or false. 

    For example if it is blank, use 'Job created at' for the value, and if it is not blank use 'Date'

Note: If the data in the pill used after ? is also blank (in the above example [Job created at]), you will get an error as well. 


Another way that can be done is this:



This gives you a second choice on fields. If First Name has any value in it, we will go ahead with the First Name. Otherwise, we will use the value from Company Name instead.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

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