Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Stripe Payment from Webhook Decimal Issue

Solved
Jump to Solution
98 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I'm creating an automation in Airtable where the info from each stripe payment comes though. The price comes in without decimals, so I thought it would be easy to add a conditional action that is there isn't a '.' in the dynamic object I could just add it within the automation, but ... its seems to be out of my comfort zone.

Is there a Script that someone has to do this?  or another workaround?

1 Solution

Accepted Solutions

This worked, if someone ever needs it:

REPLACE({Paid}, LEN({Paid})-1, 0, ".")

See Solution in Thread

4 Replies 4

Hm, what're you doing with the output after that?  Could you use a formula field and just do a `{Number from Stripe} & ".00"` or something?

No .... cause if the payment was 45.95.  Stripe imports it as 4995, then it'll be 4,995.00.  There must be a regex thing for this.

I'm trying to use the formulas for this ... but ... 

I'm not good at it. Does this make sense?

 

LEFT(Total,2), ".", RIGHT(Total,2)

This worked, if someone ever needs it:

REPLACE({Paid}, LEN({Paid})-1, 0, ".")