Help

Stripe Payment from Webhook Decimal Issue

Solved
Jump to Solution
902 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Lost-Merovingia
7 - App Architect
7 - App Architect

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
Lost-Merovingia
7 - App Architect
7 - App Architect

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.

Lost-Merovingia
7 - App Architect
7 - App Architect

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)
Lost-Merovingia
7 - App Architect
7 - App Architect

This worked, if someone ever needs it:

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