Attached are screenshots of:
(1) the app: listings screen > details screen > booking screen (with the buy button called “checkout”)
(2) the GS master sheet: with “price” column used to populate details screen (and “payment” column which is currently - but incorrectly - used to populate buy button product info)
(3) the GS price sheet (linked to master via relation): “price options” is used to populate details screen in-line list and booking screen choice component
(4) the GS schedule sheet (linked to master via relation): “day & time options” is used to populate details screen in-line list and booking screen choice component
Attached are screenshots of:
I see you are using a form button to show the booking form, but then you have checkout and add to cart buttons along with the submit button at the top right? This leads me to be a little confused on how your purchase process is supposed to flow. Are you using the Stripe integration for purchase, or are you using your own homemade cart? The problem with using a form is that nothing is saved to the sheet for the buy buttons to obtain values to pass along to stripe…unless I’m mistaken.
Based on what I think you currently have for your flow, is it safe to say that someone could submit a booking without paying or submit payment without filling out the booking information?
Hi Jeff! Thanks for your reply!
Yes, I was trying to use a form for the booking process (via Stripe - I was just ignoring the submit button) but I understand now how that might not work.
And no, user should definitely fill out a booking form with personal details to complete booking.
So what about if I move my choice components from the booking screen to the details screen (ie. replace the booking screen in-line list with a choice component instead), might that work?
I had actually tried that previously but had an issue when setting up choice component: “source” can be linked up to PriceRelation column on Master GS, but “data” can only linked up to Master, and not the registration sheet as I would like it to be. No sure what I am doing wrong here…
Thanks so much in advance!
I’ve been thinking about this one and it’s a little tricky because it sounds like you want to accomplish 2 things here. One, to submit the form data to acquire all of the information you need for the booking, and two, to submit payment for the booking. Using only the buy button only gives you only a handful of options like name, address, phone, product id, and description. Based on your screenshots, you will need more information for the booking.
My initial thought was to first create a booking button with the link to screen action redirecting to ‘This Item’. This would give you a fresh page that is still on the current detail row. Here you would present all of your entry fields along with a choice component which would be filled with the relation you are using for the payment options. The the entry components and the selected value from the choice component would then be written to user specific columns that you create in the detail sheet. My thought was to then create a template joining all of that information together and submit it through the Product Name or Product ID. The problem is that Glide doesn’t allow for glide create columns, such as templates, to be used for those parts of the buy button.
My only idea at this time would be to present a form where the user can enter all the information for the booking. I would also include the user email and unique id special values. Once they submit the form, then you would display the booking as an inline list in the details screen. From there you would need to require them to open the booking, then select the buy button. You could use the unique ID for the Product ID, and hopefully you have included the price for the booking as part of the form submission. Once they complete the purchase, then you would probably need a sheet formula to mark the booking as paid, or a copy of the App: Sales sheet that’s accessible to Glide where you would create a relation, using unique id, to the copied app sales sheet to check if the booking is paid.
It’s extra steps, but the best way I can think of to have a booking with all of the relevant info in your app, along with the ability to pay for the booking.
Hope that helps. Sorry it took so long to respond. It’s summer outside and I’ve been busy with other things.
Thanks so much for getting back Jeff, this is so helpful!!
So I actually made a bit of progress since our last exchange and ended up moving the choice component out of the form and into the details screen, recording the user choices (payment and day&time) into user-specific columns on master sheet which has enabled me to pass on
(price) to Stripe via buy button.
The issue I have now:
- My “Buy” button sits right next to “Register” button on the details screen which makes it confusing for the user: is there any way I can make it appear conditionally, only once the form will have been submitted? (Unable to configure via visibility/features…). If not:
- I may need to try implementing what you were suggesting. However, I am thinking maybe cleaner to add a new separate screen with booking recap and buy button (instead of displaying this on details screen) unless there was there a reason behind displaying this way?
- When I try making a fake payment I get this error message: “this item is no longer available” + I dont get the new App:Sales in my google sheet, which makes me question whether Stripe integration might not be compatible with user-specific columns.
Thanks so much in advance!!! Much appreciate your help
ps: more than happy to share my google sheet if that can help in any way.
Hi Steph, regarding this point, yes, it does not work with user-specific columns.
Agh bummer… would be really helpful if this feature could get added.
Thanks for your reply, @ThinhDinh.
This would require the user to sign in and the use of user profiles, but you could create a template column in your activities sheet that joins the activity name/id with the signed in user’s email from the user profile. You would also create a template in the Register sheet that joins the activity name/id and the registered user email. Then you could create a relation in the activities sheet that joins the two template columns and you can set visibility on the buy button to only show if the relation is not empty.
That’s all up to you. A separate screen would be fine as well for showing the recap and a buy button within the details of the recap of the booking.
Does anyone know about a way to make the order disappear after the payment is done?
I am using the built-in buy button but I don’t know how to not have the order in the shopping cart after paid.
@Santiago_Perez1 Sorry I can’t help you with your question but how did you get your cart to “do the math” of multiplying price per quantity and adding up the total plus shipping and handling?
Lo hice en la hoja de cálculo de google. Multiplico el precio por la cantidad. Luego sumo ese total al total del handling and shipping.
Espero que te sirva de ayuda.
Si! Muchas gracias, @Santiago_Perez1!
Hola Santiago! Pues llevo algunas semanas intentandolo pero no lo he logrado. Tampoco logro que se vea la cantidad “elegida” como en el tuyo se ve “1 body and hair wash” y “1 Bracelet”
Podrias ayudarme con como mostrarlo?
Hola @Aragonzalez90! Déjame hacer un vídeo para explicarlo mejor.
Aquí el vídeo.
Por supuesto, eso lo logre gracias a @gvalero que me ayudo a dar con las fórmulas.
Sorry, @Santiago_Perez1 do you still need assistance with this?
Actually yes! I’ve no idea how to make the order disappear.
I tried a relation but it makes everything else not be in the cart.
I don’t know what I’m missing.
I like this idea. Let me check it out. Because I’m trying to solve this problem with this app and a similar one with another app.
If I’m understanding correctly. The checkbox is the button you’re talking about.
So, the list/product is filter by the checkbox being not true, right?
Sure! the thing is that I have a weird set up.
I send the information to a sheet, then I fetch that info with a bunch of formulas in order to have the buy button see the total and everything else I need to get.