How do I format numbers in US notation when creating invoices with Mollie integration through Zapier?

Hi there @Waggie,

It looks like we’re going to need the Code by Zapier step for this to be possible. I asked ChatGPT about the code that we’re going to use and here’s how to achieve this:

1. Add the Code by Zapier action step.
2. Choose the “Run Javascript” event.
3. Type “Number” in the “Input Data” field and map the number to the right field.
4. Copy and paste this code to the “Code” field:
   const originalNumber = inputData.number; // Assuming 'number' is the field with your amount // Replace Dutch format with US format // First remove the period used for thousands, then replace the comma with a period let formattedNumber = originalNumber.replace(/\./g, '').replace(/,/g, '.'); output = [{formattedNumber}];
   
   (view larger)
    
5. Here’s the result:
   
   (view larger)

Hopefully, this helps!

That’s really awesome @Waggie! You’re definitely correc! Using Numbers in Formatter by Zapier is easier.

Also, thank you for sharing your solution here. I really appreciate it!

Happy Zapping! ⚡️