Thanks for this really useful tutorial. One question: If you start in the Form building page and from there Click to connect the answers to Google Sheets, will you still have the same benefits while collecting and analyzing the results?
Ok I have an important question. If I designed a Google Form and used it and filled 3 forms. Then I looked at the data through Google Sheet. Now I have 100 more entries in the Excel file. I want to add them to Google Sheet so that the number of entries becomes 103 (100 entries I entered manually on Google Sheet, 3 entries I entered through Google Form). Now after that when I enter a new entry through Google Form, it records the place of entry number 4 instead of taking up a new space and entering the data in the new place 104? What is the solution.
I need some help, ok maybe a lot of help :). I am trying to design a Google form that will take Family registrations. so right now I have a section for primary info such as LastName, Primary contact... Then I have a section on parents info. Where I am having issues is if a family has kids I need a way to capture Child info for that number of kids. So I was trying in Script a question "How many kids?" and then retrieving that data to set up a loop to loop through the Child info section that many times, but I'm coming up blank. Would you have or know of a video that might touch on this?
I don't think there is a loop solution. Assuming you only have certain maximum number of kids in mind, you could do conditional questions. It's not going to be pretty, but it will sort of work.
If I want to do that, then I add an onChange event handler to the sheet, and look for changes on the page of interest. I can then open the form in the script, find the relevant question, and update the list of options etc.
Teacher...I tried combining Grand Total and the Dollar Amount in the Same Cell with the Dollar Sign and Amount using & but it shows .3 instead of .30 ?! Grand Total: $251.3 Grand Total: $251.30
Great video. Thanks for sharing. Does this Google Form and the sheet created protect data from over written since the basic data is coming only from the form. I wanted to create a form for data entry to record my Option and Equity Trades and hence the query. Presently I am using a normal Google Sheet to enter create with Pivot Tables and Data query etc. But the risk is data corruption or incorrect edits or over writing on existing data. Thanks
Google Sheets Tables ua-cam.com/video/L9PHJD0Wqfc/v-deo.html
The best teacher ever for Google Sheets and Apps Script tutorials, who helped me become a good developer since I started learning from you.
You have the best video content on Google Sheets on UA-cam, bar none. Thanks.
Glad you like them!
Please upload to UA-cam frequently. please. I want to study a lot.
4:28 This makes sense. So I just need to know how to handle a regular table. Thanks a lot.
Every video is so clear precise and next level. Hit like before watching it actually.
Thank you!
I was amazed how flexible the Forms to Sheets integration was. The inclusion of the Table feature makes it even better.
Thanks for the update.
🙂
This changes so much for my work! I thank you a lot 🙂 You are a gentleman an a schoolar.
🙂
Do not rest.
Please upload video everyday.
Big fan from South Korea
🙂
Love your content. Would love a video about referencing google tables in apps script
I am a big fan of you brother
:)
Thanks for this really useful tutorial. One question: If you start in the Form building page and from there Click to connect the answers to Google Sheets, will you still have the same benefits while collecting and analyzing the results?
Very helpful. Thank you. Is there a way to change existing data in a table using google forms?
Awesome video! How would you capture in your example if Ron ordered 14 pencils and 5 clips? Can that be done without submitting a second form?
Thanks for sharing...
Thanks for watching!
Thank you again...
Ok I have an important question. If I designed a Google Form and used it and filled 3 forms. Then I looked at the data through Google Sheet. Now I have 100 more entries in the Excel file. I want to add them to Google Sheet so that the number of entries becomes 103 (100 entries I entered manually on Google Sheet, 3 entries I entered through Google Form). Now after that when I enter a new entry through Google Form, it records the place of entry number 4 instead of taking up a new space and entering the data in the new place 104? What is the solution.
Can you please make a video about how to use The Google Picker API? 🙏
its good
How can I take order from a customer who ordered many products and quantities? Using Google form and make order receipt and invoice
I need some help, ok maybe a lot of help :). I am trying to design a Google form that will take Family registrations. so right now I have a section for primary info such as LastName, Primary contact... Then I have a section on parents info. Where I am having issues is if a family has kids I need a way to capture Child info for that number of kids. So I was trying in Script a question "How many kids?" and then retrieving that data to set up a loop to loop through the Child info section that many times, but I'm coming up blank. Would you have or know of a video that might touch on this?
I don't think there is a loop solution. Assuming you only have certain maximum number of kids in mind, you could do conditional questions. It's not going to be pretty, but it will sort of work.
03:45 I think you meant to say Google Sheets Table, rather than Excel Table.
I'm surprised I don't make that mistake more often given how much time I spend in Excel on a daily basis.
I hope you have started something else but you have surprised me. I hope you are surprised every week 😂.
Can a Google form load a dropdown in the form with items from an existing Google Sheet?
No, but you can run a script on schedule to update the dropdown based on google sheets data.
If I want to do that, then I add an onChange event handler to the sheet, and look for changes on the page of interest. I can then open the form in the script, find the relevant question, and update the list of options etc.
update the column type to a dropdown in the table in the sheet for the question you want
Why my form responses, cannot be a table?, its just like regular data with white colour
Old form you made long time ago?
Teacher...I tried combining Grand Total and the Dollar Amount in the Same Cell with the Dollar Sign and Amount using & but it shows .3 instead of .30 ?!
Grand Total: $251.3
Grand Total: $251.30
Add a decimal point to format?
Great video. Thanks for sharing. Does this Google Form and the sheet created protect data from over written since the basic data is coming only from the form. I wanted to create a form for data entry to record my Option and Equity Trades and hence the query. Presently I am using a normal Google Sheet to enter create with Pivot Tables and Data query etc. But the risk is data corruption or incorrect edits or over writing on existing data. Thanks
Well, if you only use the Form you won't overwrite the data, but you can still go to the spreadsheet and overwrite it there.
@@ExcelGoogleSheets Thanks for you prompt reply.