Automatically Download Microsoft Forms Data
DOWNLOAD https://urlin.us/2xUJkw
I'm using Microsoft forms to create a user friendly data entry for assets that need to be constantly updated. The reason for using forms is I like that your able to use it on the phone as well and enable multiple people outside the organization to have access to it.
My vision is to create the Microsoft form with all the required data entry fields and once filled out the data is populated into excel as a work book. (I know this is how forms works but its more for a questionnaire / exam type application.) Once the data has been entered in and its automatically populated into my excel worksheet, if an updated data entry is made through forms by the user with the same asset tag number (which would be my unique ID) I would like my excel sheet to update that cell that has the unique ID previously entered with the new data instead of creating a duplicate or adding another data line.
I can see future problems as well if someone wanted to mess with the data and enter a bunch of data that was incorrect it would automatically change whatever data was previously entered with the new "wrong" data. Or if a user accidently filled in the "unique ID" incorrectly it would change data.
Would it be easier just to make everything in excel including the data entry form or is there another way to utilize/mimic the user friendly interface of Microsoft forms and the convenience of using it on a mobile device? 5376163bf9
silver v 4.2.1 windows download