Forum Discussion

BrendanFairTel's avatar
BrendanFairTel
Copper Contributor
Jan 10, 2024

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 stock, broken down via mac address for each device (IP phones, modems, networking equipment, etc.). This spreadsheet already automatically tracks stock levels, as well as a few other things.

 

I would like to setup a Form my team can fill in remotely where they can select specific devices for the warehousing team to then set aside for programing. This would automatically remove that device from the spreadsheet to more efficiently track stock levels. 

 

Is there a way to link a Microsoft From and Excel spreadsheet to accomplish this? If not, is there another way to accomplish the same goal? 

 

Thanks!

2 Replies

No RepliesBe the first to reply

Resources