Join Gini von Courter for an in-depth discussion in this video Creating a table from an Excel list, part of SharePoint 2013: Customizing List Forms.
- Notice that if I have an existing data source,…I can create a table from that data source.…So I'm going to choose Excel,…and we're going to go find my document.…Which is on my desktop…in the Exercise Files folder…and the Data folder and it is called Products, right here.…It says the source definition will be…imported into a new table in my app.…Yes, click OK.…If you have imported spreadsheets, or imported text,…or comma-separated value files,…you should be familiar with this.…
Notice that the first row is column headings.…That's correct, here's my data.…Gonna click Next, and I wanna make sure that…Power and other numeric fields…were correctly identified as numbers,…or as currency, or dates.…Those are the kinds of things you wanna check.…Don't be fooled by what this looks like…before we click on it.…Yes no field, that looks great.…And I'm going to import this…to a table that's called Products.…Click Finish,…and a lot is happening right now,…it's importing my table, but it's also creating…basic forms that I can use.…
AuthorGini von Courter
- Determine the steps for generating a SharePoint list from an Excel table.
- Recognize how to set options for default list forms.
- Modify form layouts using InfoPath Designer.
- Summarize how to put together an Access web app to utilize as a list form.
- Identify how to formulate Excel surveys.
- Discover how to share the results of Excel surveys.
Skill Level Intermediate
SharePoint Designer 2013: Custom Workflowswith Gini von Courter6h 51m Intermediate
1. Understanding Forms in SharePoint
2. Using InfoPath to Create List Forms
3. Creating Custom Forms with Access Web Apps
4. Using Excel Surveys to Create Forms
Next steps2m 56s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.