Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Stripe Payment from Webhook Decimal Issue

Solved
Jump to Solution
2021 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, ".")