# Using Math column for Price in Stripe buy button

Hello Everyone, : )

I’m trying to make a shop for users of my apps.
I try simple thing : Price x Quantity = Price appear in Buy button.
I try a Math column (stripe dont see it)
I try a template column (stripe dont see it)
i try a if then else column (stripe dont see it)

Where am i wrong ?

1 Like

The Buy Button only supports sheet columns right now.

1 Like

Create an array formula in the sheet to multiply price and quantity (make it user specific). Use that to get the sub-total.

Hey @Mark any plans to change this in the future?

Oh, i see. So it’s impossible to set the quantity base on user choice.
It’s doable with google sheet formula, but it’s will be slow and the choice of one user will appear for every user.
Am I right ?

Yes, we want to fix this eventually.

4 Likes

How can you create a array formula in the sheet and make it user specific ? I was tinking that only column user specific create in glide can be ‘user specific’

You’re right.

Can you show me a screenshot of your worksheet on how you created this formula?

Hi Shannon, What’s your question ?
If it’s how to apply the formula : “quantity x Price” for individual user choice, unfortunately, it’s still impossible (to my knowledge).

But for doing it in your google sheet with and array formula, it’s very simple :

=ARRAYFORMULA(IFERROR(IF(I3:I="","",I3:I*J3:J)))
I3:I is your price for 1 item

and that’s it, you have your Total Price.

I send you sreenshot when i 100% understand your question ^^.
Good day !

OK, here is my situation and tell me if you can find a solution.

I have a food truck locator app with multiple food trucks that will allow for mobile ordering.I want users to be able to place mobile orders for food once they find a food truck of their choice. The problem I am having is the ‘Stripe’ buy button only has input for set items that I don’t necessarily need. I need to be able to have the mobile order place and be able to include the menu item name, menu description, price and any food prep instructions (ie no ketchup, pickles, extra cheese, etc.)

I have been told I can create a custom ‘shopping cart’ to solve this problem, but I have not been able to figure it out.

Just a short correction, it accept also user specific column, so not in the sheet.
I think is just a matter to open it to the other type… But maybe not so simple!