I have created a webpage that includes a login system and a form that you are able to submit. The form includes the questions the customers are asked in participating in a Site Survey. This data is stored into google sheets and then taken to an excel using a query.
Currently the excel spreadsheet will show any uploaded forms once data is refreshed. I have created a macro that will gather the record data, copy an empty form, paste the record in its correct cells and rename the sheet as “Completed Survey”.
The problem with this is if I dropdown the cell where the button is located to copy it down to the rest of the rows, it will only create a form from the first record that is inputted not the record next to the button pressed.
This is what the raw data looks like :
And the data is placed in a file like this:
Currently the excel spreadsheet will show any uploaded forms once data is refreshed. I have created a macro that will gather the record data, copy an empty form, paste the record in its correct cells and rename the sheet as “Completed Survey”.
The problem with this is if I dropdown the cell where the button is located to copy it down to the rest of the rows, it will only create a form from the first record that is inputted not the record next to the button pressed.
This is what the raw data looks like :
And the data is placed in a file like this:
