Skip to main content

Notifications

Dynamics 365 general forum
Suggested answer

Class Attendance

Posted on by 215
I am looking to make a class attendance piece into an app I have and I am unsure exactly how to go about it.
 
My current Plan:
 
  • Table Student
    • Name
  • Table Attendance
    • Date: Date/Time
    • Class: Choice
    • Present: Lookup-Student Attendance
    • Out: Lookup-Student Attendance
  • Table Student Attendance
    • Attendance: Choice
    • Many-to-Many to Student
 
Any guidance or recomendations are welcome. :)
  • Bahalzamon Profile Picture
    Bahalzamon 215 on at
    Class Attendance
    @Martin Dráb
    Correct, as this is for Dynamics 365 and not one of their additional modules.
  • Bahalzamon Profile Picture
    Bahalzamon 215 on at
    Class Attendance
    @Haig Liu
    Thank you for your post. Yes how you have it there is easiest for myself and to ensure proper data connectivity.
     
    Part of the problem is that there are anywhere from 15-30 students that attendance needs to be taken, doing it this way will take quite some time, that is why I was inclined to use the Many-to-Many relationship which within a subgrid will allow me to select the Add Existing Student and select the multiple children in one go.
  • Suggested answer
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    Class Attendance
    Hi Bahalzamon,
     
    I have created the following two tables based on my understanding.
    1.Student table, containing only the original name field.
    2.Student Attendance form with four custom fields.
    1)Choose Student: Lookup field - Lookup student table
    2)Class: Choice field
    3)Date: Date and time field
    4)Attendance: Yes/no field
     
    You can create a new view in the designer to make it easier for you to find records.
     
    If my answer was helpful, please click Like, and if it solved your problem, I hope you can verify it to help other community members find more.
    Please feel free to contact me if you have any further questions.
    Regards,
    Haig
  • Martin Dráb Profile Picture
    Martin Dráb 229,021 Most Valuable Professional on at
    Class Attendance
    D365 consists of many different applications, such as Finance & Operations, Sales or Business Central. You're asking in D365 general forum, therefore it's not clear which product you have in mind. Please add this information.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Forum Structure Changes Coming Soon!

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,734 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,021 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans