Need help ;-)

Ask for Help
1

Hi community!

Do you know how I can make a Google Sheet result depend on the user?
Actually I would like to multiply the quantity of the product with the price and use the result for Stripe. but… Stripe just accept values from Google sheet and I don’t know how the values can depend of the user. Today if a user change the quantity for instance, if the value is stored in the Google sheet, this value will appears in all the accounts.

Thanks a lot for your help,

Regards

2

Google sheets does not have user specific functionality like glide provides. It has no knowledge of the apps users. You would have to submit a form, so there is a new row in a sheet that is only visible to one user. Like your own homegrown cart. From there you can perform your math in the google sheet and use the calculated values on a buy button.