Join Gini von Courter for an in-depth discussion in this video Creating a simple web macro, part of Creating Access Web Apps in SharePoint 2013.
- View Offline
- Exercise Files
- I've made some changes to this view,…and I also made one change to the Issues table,…because I'd like to create a process…that doesn't already exist in my app.…Normally, when someone has resolved…an issue, they change the Status,…and choose Resolved from the drop down.…When they do that, and only after…they have done that, they're then allowed…to change the Resolution.…So if I change the Resolution,…and I haven't already set the Status…to Resolve, it won't let me change it,…it just will throw it away,…when I go to save the record,…which is actually a pretty nifty piece…of functionality.…
But there's nothing here that captures for me…when this was actually resolved.…I have a date that the issue was opened,…I have a date that the issue is due,…but I don't have anything that tells me…when it was resolved.…So it will be really hard for me…to determine some basic information…about issue resolution.…Like are we resolving issues before…or after the due dates?…So here are the two changes that I made.…In the Issues table, I added a Resolved Date…
AuthorGini von Courter
- Creating a new app
- Building tables from different sources
- Creating relationships between tables
- Working with views
- Using macros for automation
- Saving your app in an app package
Skill Level Intermediate
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SharePoint 2013 for Site Champions and Power Userswith Mark Abdelnour2h 58m Intermediate
1. Creating a Simple Access App
2. Working with Views
3. Automating and Packaging
Next steps1m 24s
- 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.