/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
Creating a form to show raffle items, select # of tickets, calculate cost and submit for responses. 0 Recommended Answers 1 Reply 0 Upvotes
1 Update
$0 Updates
1 Recommended Answer
$0 Recommended Answers
1 Relevant Answer
$0 Relevant Answers
0
What do I use to create a form w/photos of raffle items so guests can mark their choices & quantity of tickets to purchase for each, calculate the total cost and submit their choices so we can collect their responses and collect funds then thru PayPay, etc?
Details
Relevant Answer Relevant Answers (0)
All Replies (1)
Relevant Answer
Hi AFGYoungstown Districts4-9,
 
Unfortunately the ability to do any calculations based on user inputted data is not a part of Forms.  I would encourage you to send this feature request to the developers by selecting the  Support Button in the lower right-hand corner of the Forms window. Although they aren't able to respond to feature requests directly, feedback submitted there will go directly to the development team and the more people who request a feature like this the more likely it will be implemented. This forum is staffed (almost) exclusively by volunteers, even the Product Experts are all volunteers, so unless you submit in-product feedback it is very unlikely to be seen by the people who can make that decision.
 
To use Forms to accomplish your goal, you will need to use a Form that is linked to a Sheet.  The Sheet will then do the calculations you need and it will manage a mail merge add-on that can email the information to the user.  The add-on will use a column within the linked Sheet to determine when and which kind of email should be sent.  If you are not sure how to setup the column that will trigger the sending of the email, take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”.  Here are some instructions for how to install an add-on.
___________________________
Add-ons are little “apps” that can add capabilities and functions to all of the different Google Docs products.  To find add-ons you first need to open a Doc, Sheet, Form, or Slide. In the top menu bar, you will find “Add-ons”, click on this and then “Get add-ons…”  In the search window found in the top right-hand corner, type in either the type or name of the add-on you wish to look for. When you find what you would like to use, click on the blue “+FREE” button and then follow the instructions to give the add-on access to your data. (See image below)  Be sure to read what the add-on will be accessing and if you do not want to grant permission for some items, do not continue to install the add-on. Once the add-on is installed, you can then begin to use it by going to the “Add-ons” menu and then selecting the specific add-on you want to use. Also, if you cannot find a specific name or type of add-on, you are probably looking in the wrong add-on area.  I know, this is a bit confusing at first and when you are dealing with two different Google Productions at the same time (ie Sheets and Docs), it can get more confusing.  Instead of housing all of the add-ons in one catalog, they are divided up into the specific Google Product that will use the add-on. So, there is a catalog for Docs, Sheets, Forms, and Slides and they are only accessible by opening the specific type of file you are working with and going to the “Get add-ons…” menu item.  For example, mail merge add-ons can be found in both Sheets (currently 58 possibilities) and Docs (currently 21 possibilities) and they are not the same add-ons. [Side note - when looking for mail merge add-ons, I would suggest using a Sheets add-on.] The moral of the story is if you cannot find something you are looking for in Docs add-ons, it might be in one of the other add-on catalogs.
 
_________________________________
 
I hope this helps!
 
Adam
Diamond PE Docs volunteer
Silver PE Classroom volunteer
Cert. Educator 1 & 2
Cert. Trainer
(not a Google employee)
 
When you've received a response that answers your question, please observe these forum courtesies:
 • If you had a Sheets problem, leave your demo sheet shared as View Only as part of this solution's archive,
 • Click Recommend on the post that best addressed your question, and
 • Post again soon!
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Removed from Updates
Marked as Recommended Answer
Marked as Update
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
Known Issue
Fixed
Marked Fixed
Unmarked Fixed
Unable to mark fixed
Unable to unmark fixed
/docs/profile/0