HOW TO: Include a leading zero (such as 0.25) in an amount when using NetSuite

In saved searches using SuiteScript, NetSuite automatically formats numeric values such as 0.25 to just .25. To get around this, you could

  • Use a formula column of the field in the saved search
  • Use the toFixed handlebars helper in integrator.io. Example: {{toFixed subTotal "2"}}

This is just one of the many examples on how to use handlebar helpers. We have a great Handlebars helper reference guide, including ToFixed handlebarsI

You'll also probably want to check out our Inline handlebar helpers and Nested Expressions
Let us know if you have other handlebars or value formatting questions we can help you with here on our community! Also, let us know if there's any information you'd like us to add to our handlebars documentation!