News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Class Attendance

Dynamics 365 general forum

Suggested answer

Class Attendance

(1) Share

Report

Report

Posted on by Bahalzamon

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. :)

Categories:

Other Functionality

Dynamics 365 Administration

All responses Img

All responses (4)

Answers Img

Answers (0)

Bahalzamon 215 on at

Like (0)

Report

Class Attendance

@Martin Dráb

Correct, as this is for Dynamics 365 and not one of their additional modules.
Bahalzamon 215 on at

Like (0)

Report

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 Microsoft Employee on at

Like (1)

Report

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 228,493 Most Valuable Professional on at

Like (0)

Report

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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,493 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans