How can I have the results of two different forms populate to one sheet?

margieg63

I have a sheet called Event Sheet. There is a lengthy form associated with this sheet that allows submitters to request rooms for a specific date / time, etc. It also allows them to request media, room setup, etc. I duplicated this form and created a 'short form' and took out many of the inputs so folks can just request a room. My problem : I am not seeing the new short form submissions on the original sheet. Thoughts or solutions?

Paul Newcome

Are you having new entries at the top or bottom of the sheet? If at the bottom, try scrolling all the way to the bottom and see if they are there.

When a form is entered, it is entered on the next UNUSED row. So lets just say there was data on row 1 and you deleted it from the cells. That means that even though there is nothing on row 1, it is still used and the form will populate row 2. If you delete the actual row 1 (which moves 2 up to 1) then the form will now populate row 1 since it is unused.

Paul Newcome

Are you having new entries at the top or bottom of the sheet? If at the bottom, try scrolling all the way to the bottom and see if they are there.

When a form is entered, it is entered on the next UNUSED row. So lets just say there was data on row 1 and you deleted it from the cells. That means that even though there is nothing on row 1, it is still used and the form will populate row 2. If you delete the actual row 1 (which moves 2 up to 1) then the form will now populate row 1 since it is unused.

margieg63

Thank you! Evidently there is a delay in the process on my end. It finally showed up after 20 minutes...

Paul Newcome

Happy to help. 👍️

I use the refresh button a lot when I am testing things like forms and automations.