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.