Skip to main content

Notifications

Announcements

No record found.

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 224,750 Super User 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.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans