I have a NWC form and need to capture the data that users enter. Using SharePoint is NOT an option. Can I collect the NWC form data in an excel file? If yes, can you advise how to do this. Thanks.
Solved
Capture form data (NWC) but not in SharePoint
Best answer by Gavin-Adams
Sorry I cant see a way to do this with Excel.
I'm assuming you are thinking that for each form submitted (ie workflow instance) that a row is added to the spreadsheet.
You would have options of storing the spreadsheet file in Sharepoint, Onedrive, Box, Google Drive, Dropbox, however the bigger issue is being able to crack open the spreadsheet find the next available row and add to it. No real method for that unforetunately.
I don't think a document generation solution will work in this scenario either.
Sharepoint lists are the easiest to use to do this however I know you said that is not an option.
Other thoughts are:
- use SQL actions to insert to a database table. (SQL on premise or in Azure, or MySQL)
- call a web service to some custom thing you have developed or a cloud service that stores rows of information.
+13Sorry I cant see a way to do this with Excel.
I'm assuming you are thinking that for each form submitted (ie workflow instance) that a row is added to the spreadsheet.
You would have options of storing the spreadsheet file in Sharepoint, Onedrive, Box, Google Drive, Dropbox, however the bigger issue is being able to crack open the spreadsheet find the next available row and add to it. No real method for that unforetunately.
I don't think a document generation solution will work in this scenario either.
Sharepoint lists are the easiest to use to do this however I know you said that is not an option.
Other thoughts are:
- use SQL actions to insert to a database table. (SQL on premise or in Azure, or MySQL)
- call a web service to some custom thing you have developed or a cloud service that stores rows of information.
Thanks for the quick reply. We do have SharePoint but it is currently in our DEV environment and unlikely to be rolled out anytime soon. Attempting to link to the DEV environment is interesting as it needs to be in an incognito window. I will keep trying!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.