Forum Discussion
BrendanFairTel
Jan 10, 2024Copper Contributor
Forms Questions Pulling Data From Excel
Hi everyone, I wonder if you can help me! I'm trying to setup an operational process between a requisitions form and a stock control excel spreadsheet. The excel spreadsheet lists all of our ...
BrendanFairTel
Jan 10, 2024Copper Contributor
Hi Tomsmith1122,
Thank you for your rapid response!
My only questions is where exactly do I locate the "Excel" tab? I cannot locate it in either the Forms home page or when creating a Form?
Thanks again!
Thank you for your rapid response!
My only questions is where exactly do I locate the "Excel" tab? I cannot locate it in either the Forms home page or when creating a Form?
Thanks again!
ruxMS
Jan 11, 2024Copper Contributor
Hi BrendanFairTel,
there is an "Open in Excel"-Button if you have at least one answer, but its just a static Excel Export.
The only way i know is to open your Excel in Excel Online (Browser or Teams)->Tab Insert->Section Table->you have a Forms Button to create a new Form which is connected to your Excel. Unfortunately, you cannot use an existing form, but have to create a new one.
Kind regards
there is an "Open in Excel"-Button if you have at least one answer, but its just a static Excel Export.
The only way i know is to open your Excel in Excel Online (Browser or Teams)->Tab Insert->Section Table->you have a Forms Button to create a new Form which is connected to your Excel. Unfortunately, you cannot use an existing form, but have to create a new one.
Kind regards