• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Recipe Building Recipe Error Troubleshooting
S

Saul Macht

started a topic almost 5 years ago
Answered

Error adding two data pills: Error calculating input for field 'message': false can't be coerced into Float

I'm trying to add two amounts in a log message and am receiving this error. What would be causing it?

image


Best Answer
P
Patricia Guevarra said almost 5 years ago

Hi Saul,


Thanks for reaching out! There are two things you need to take note of:

1. What data format the pills are in. It should be in integer or number format to be added. Take note of the icon beside the data pills, it should appear as 0.00. You can see more information about that here: https://support.workato.com/solution/articles/1000153309-recipe-basics-understanding-app-data-and-field-mapping


If it isn't, you need to convert it using a .to_f or .to_i formula. You can learn more about that here: http://docs.workato.com/formulas/number-formulas.html#conversions


2. Whether the pills are empty. It will give this error if you are trying to add an empty pill. This is especially important to check if you are using a pill from a Search, an optional field, or a field nested under a conditional action. In case it could be blank, you can use the .present formula. You can see more information about that here: http://docs.workato.com/formulas/number-formulas.html#present


Let us know if you have further questions!

Answer

Patricia Guevarra

said almost 5 years ago

Hi Saul,


Thanks for reaching out! There are two things you need to take note of:

1. What data format the pills are in. It should be in integer or number format to be added. Take note of the icon beside the data pills, it should appear as 0.00. You can see more information about that here: https://support.workato.com/solution/articles/1000153309-recipe-basics-understanding-app-data-and-field-mapping


If it isn't, you need to convert it using a .to_f or .to_i formula. You can learn more about that here: http://docs.workato.com/formulas/number-formulas.html#conversions


2. Whether the pills are empty. It will give this error if you are trying to add an empty pill. This is especially important to check if you are using a pill from a Search, an optional field, or a field nested under a conditional action. In case it could be blank, you can use the .present formula. You can see more information about that here: http://docs.workato.com/formulas/number-formulas.html#present


Let us know if you have further questions!

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 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato