Google Forms to Google Sheets Tables & Auto-Updating Formulas

[@ExcelGoogleSheets]

Google Sheets Tables kzbin.info/www/bejne/gmqzeX16ZbyknMU

[@cislinknl6352]

The best teacher ever for Google Sheets and Apps Script tutorials, who helped me become a good developer since I started learning from you.

[@stwheel]

You have the best video content on Google Sheets on KZbin, bar none. Thanks.

[@ExcelGoogleSheets]

Glad you like them!

[@DreamWorker0]

Please upload to KZbin frequently. please. I want to study a lot.

[@lafamillecarrington]

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.

[@ExcelGoogleSheets]

🙂

[@pancux670]

Every video is so clear precise and next level. Hit like before watching it actually.

[@ExcelGoogleSheets]

Thank you!

[@shinhoyoung8426]

Do not rest. Please upload video everyday. Big fan from South Korea

[@ExcelGoogleSheets]

🙂

[@svXPs]

4:28 This makes sense. So I just need to know how to handle a regular table. Thanks a lot.

[@wernerzurowetz6198]

This changes so much for my work! I thank you a lot 🙂 You are a gentleman an a schoolar.

[@ExcelGoogleSheets]

🙂

[@dannylayton317]

Love your content. Would love a video about referencing google tables in apps script

[@learntoearn8533]

I am a big fan of you brother

[@ExcelGoogleSheets]

:)

[@김진경-z4l]

❤ Very. Good . Thanks

[@jeanlouisBarre]

Very useful, I didn't know that one could move OrdersTable up and down without breaking everything. A little plus if I may : Ana had a second though and wanted a pen instead of a pencil. How to you keep the last order and remove all previous ones ? To do that, in a new sheet you may use this formula : SORTN(Sort(OrdersTable;1;False);rows(OrdersTable[Timestamp]);2;2;True) that will first sort OrdersTable by Timestamp reverse order then sort this result by Name alphabetical order (column 2) removing duplicate.

[@jeanlouisBarre]

Instead of referring lines by number this would be better and more flexible : SORTN(Sort(OrdersTable;MATCH("Timestamp"; OrdersTable[#HEADERS]; 0);False);rows(OrdersTable[Timestamp]);2; MATCH("Name"; OrdersTable[#HEADERS]; 0);True)

[@silvestrecamposano6317]

Thank you again...

[@khawguanleng7]

Thanks for sharing...

[@ExcelGoogleSheets]

Thanks for watching!

[@boredomindex3353]

Can you please make a video about how to use The Google Picker API? 🙏

[@kirstenmartinez1985]

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?

[@Sakiotis]

Very helpful. Thank you. Is there a way to change existing data in a table using google forms?

[@samr1953]

Would there be a way to show the updated Grand Total on the form?

[@jerrydfowler3480]

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?

[@ExcelGoogleSheets]

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.

[@thomashartmann5037]

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?

[@SamKatakouzinos]

03:45 I think you meant to say Google Sheets Table, rather than Excel Table.

[@ExcelGoogleSheets]

I'm surprised I don't make that mistake more often given how much time I spend in Excel on a daily basis.

[@davidserralvo]

How to add a filter to a column, where value is formatted as Date (e.g. 12/14/2024), to select a date range “from - to”?

[@bumpersmith]

Can a Google form load a dropdown in the form with items from an existing Google Sheet?

[@ExcelGoogleSheets]

No, but you can run a script on schedule to update the dropdown based on google sheets data.

[@johnrumm4786]

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.

[@sergiopozo5999]

update the column type to a dropdown in the table in the sheet for the question you want

[@learntoearn8533]

How can I take order from a customer who ordered many products and quantities? Using Google form and make order receipt and invoice

[@mdalbazi]

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.

[@ashutoshgovind1877]

I hope you have started something else but you have surprised me. I hope you are surprised every week 😂.

[@syukraakhmad3822]

Why my form responses, cannot be a table?, its just like regular data with white colour

[@ExcelGoogleSheets]

Old form you made long time ago?

[@Electric-Bob]

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

[@ExcelGoogleSheets]

Add a decimal point to format?

[@MattTemes]

This is the worst thing ever. I wish they would let us opt out of this or just remove the bug altogether instead of forcing us to conform to this horrible mistake. Editing the data prevents any response updates unless we re-link the form, and re-linking the form deletes any edits or formatting. We got sick of not being able to add check boxes and highlights cells so we are literally back at pen and paper unless this goes away. Complete disaster.

[@alphabeta01]

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

[@ExcelGoogleSheets]

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.

[@alphabeta01]

@@ExcelGoogleSheets Thanks for you prompt reply.