I have been asked to take an excel document that is being used to capture data and turn it into a SharePoint form. The form will then be used to create a Tableau dashboard. (see example of form in screen shot).
Background:
- Currently all the information is being gathered in an Excel document
- After the information is gathered in Excel, it will be enterd into the SharePoint/Nintex form
- The form will have several column types (Single Line, Multiple LInes, Choice, Date and Time, Person or Group, and Yes/No checkbox)
- From there a Tableau Dashboard will be built off the data in the SharePoint formprol
Problem:
- What is the best way to capture the information in a Nintex form? Using repeating rows? or is there something else available?
- In the Excel document I already have more than 300 rows of data
- If I use Repeating Rows I need to make sure the data is accessible so it can be used in a Tableau dashboard.
- What is the best way to capture the information in a Nintex form? Using repeating rows? or is there something else available?
I am using SharePoint 2013 and Nintex Forms 2013. Also I am on a work enviroment so some actions are not allowed.
Does anybody have any advice / recommendations on how to proceed?
- Thanks!