Using Math column for Price in Stripe buy button

Alexandre and @Shannon_Joseph, I’m echoing @Jeff_Hager’s point. You have to take your calculated total and write it to a static column that Stripe will read.

For the first version of Glidecart I didn’t include Stripe for this very reason, it seemed near impossible to implement, but later found a flow that worked well to include Stripe as a payment.

How you structure your app will depend on your desired UX/UI. I’ve listed the rough outline of my flow in case it helps anyone with their app.

My Flow (very rough draft :sweat_smile:)

  • Users add their items to a “cart” table - this allows them to add as many items as they want to their cart. FYI all calculations and formulas are built off of THIS SHEET
  • Once users are ready to purchase, they are directed to “Checkout”. This action creates an order on the “Order” table. This action is the step that writes the cart’s total to a static column on the “Order” table. This will be the record we use for users to submit payment for.
  • Users are then directed to a forced screen to pay for their order using their method of choice.

5 Likes