Add quantity and summary transaction page - Apps Script on Google form

[Brian Hyun]

Hi everyone,

Thanks in advance for your help. I'm doing a small experiment where we want to test if target customers purchase products thru us (basically grocery delivery service). I've built a site using a Google form and there are two things I need Apps Script

1) Currently, once they select an item, they can't add quantity. Is there anyway to add a quantity box if they select a specific item?

2) Once they select all the items they want, I want to create a summary page at the end displaying the list of products, prices and total (just like checkout page when you order products from Amazon)

https://docs.google.com/forms/d/10nY0GJ4sbjRIMOS6EbMQKfYaJNXp7j92h357toMYTnw/edit

Please let me know if you need any further clarification.

Very much appreciated!

[Alan Wells]

There is no built-in way to conditionally either show a text box for a quantity entry or not depending upon the checkbox choices.  And there is definitely no way for a Google Form to summarize the prices into a total.  You could do that with an Apps Script Web App, and an Apps Script Web App can be embedded into a Google Form.  So, unless you can do the programming yourself, I'm not sure whether it would be worth pursuing.

[Gitesh Kohli]

we faced this issue quite a bit, hence we started using sheets popUphtml, sheets itself can host all the info

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/3b58adf3-225c-497a-811f-b7f967152b64%40googlegroups.com.

[Andrew Roberts]

@Alan This line caught my eye:

"an Apps Script Web App can be embedded into a Google Form"

How do you do that then?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAKMvVpV3XAwW9q--rG%3Dk1_FRij7pR40hp8xvLo8-5sXy2w1q7g%40mail.gmail.com.

[Brian Hyun]

Thanks a lot for your response. I guess it was not possible without actual programming. Would you recommend any site I can hire someone to do it on behalf of us? 

[Brian Hyun]

Thanks for the message. Would you please provide a bit more detail on popUphtml? I googled and it seems like another programming language?

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.

[Andrew Roberts]

If you would like a hand with your project drop me a line (and...@roberts.net) or take a look at this list of other Apps Script devs.

Andrew

AndrewRoberts.net

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/3b58adf3-225c-497a-811f-b7f967152b64%40googlegroups.com.

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f6ac1d86-89fb-48bb-b27b-d59ff4e922a4%40googlegroups.com.