Template Column as a value to Buy button

[Mohamad_Al_Sadoon]

I’m trying to add multiple values through the Template Column and then based on the User specific selection/input I would want to send that through to the Stripe button.

Is there any workarounds because this doesn’t seem to be possible?

It is possible to see user specific columns but not possible to see the template! This limitation is so frustrating!

Can other column be enabled to be selected as values? @david

[Jeff_Hager]

This is only a guess and I don’t know the true reasoning behind the limitation, but may explain why we can’t.

Allow GDE Columns in Buy Button

@Robert_Petitto Response from @david from a previous post: “ Buy Button columns must be basic data columns for security reasons for now. We want to allow computed columns but we must make it possible for the server that verifies the purchases to run the calculations—right now our servers cannot run calculations, only your running app on a device can.” Why is there Buy Button limitations?

Allow GDE Columns in Buy Button

I’m guessing part of the issue is that glide columns are most likely calculated on each individual device and not on the server. That’s probably where the security issue comes into play. The stripe interaction probably needs to happen on the server, and if the data is technically not being calculated on the server, then it’s not accessible when passing api credentials and data from the glide servers to the stripe servers. Opening up to allow each device to make direct connections to stripe pr…

The only workaround I know of is to make sure the calculated data is in the Google sheet and not calculated on the fly with glide columns.

[Mohamad_Al_Sadoon]

This is what I’m doing but the user flow is really not that great, they need to fill a form and then head to another page (wishlist) to add things to the cart 1one-by-one then go to the cart and checkout.

Unless there is a better flow i don’t know?

[Jeff_Hager]

You could play with the compound actions in staging to see if you get a flow that might work when they release it someday.

In Staging: COMPOUND Actions!

IT’S (almost) HERE! Now in staging is the ability to create compound actions—multiple triggered actions off a single event. Included is the ability to add new rows instantly without a form submission! Here’s a simple example:

[Mohamad_Al_Sadoon]

How does one access staging?

[Jeff_Hager]

Glide · Create Apps from Google Sheets

[_eric]

This is definitely a limitation. I was able to make it work but you have to get a little creative with it. I used Glide tables not Google sheet. In my solution I used one tab to calculate the values and the second tab to bring those over as a text which is what Glide requires mapped to the price field for stripe.

So what you could do is have the “product” tab, this lists the cost of the unit. Then when someone wants to buy, they can add quantity or other calculated values in the “Cart” tab do the calculations. But wait, theres more! Because values need to be “text”, you will need one last approval where the user approves the “cart” calculations (totals) and it finally pushes the “text” data to the “Checkout” which at this point is straight text. I agree it’s an added and unnecessary step from a user perspective but its the only way to carry the values over as text. Then the user can pay from there.

Good luck!

[Mohamad_Al_Sadoon]

thanks for sharing, would you be able to share how does your app looks like just to get an idea of how you did that?

[Mohamad_Al_Sadoon]

Hey Eric,

I would love to know how you were able to achieve this! Can you share the app you made for this to work?