Is it possible to dynamically create a database field?

Ask the community
,
1

Hey, I work for a church and I’m trying to make a youth group check-in system using databases. I’ve already imported the database into a new collection. However, I want to actually keep track of attendance, I see myself doing that by having a new database field for every date that will hold a boolean on whether or not a student attended.

That being said, I really don’t want to have to go in and create a new field for every single week. Is it possible to create a new field in a database using a collection? Or am I going about this the wrong way? Is there an easier way to track attendance than through a collection?

2

" Is it possible to create a new field in a database using a collection?"
Yes, but you are making your life difficult in doing so.
“Or am I going about this the wrong way?”
Yes
“Is there an easier way to track attendance than through a collection?”

Yes, use a seperate collection for attendance and create a 1-n relation between Student-Attendance using a Reference Field (there´s a lot of doc about this).

Good luck.

3

Thanks. I can go searching for the reference docs. Would you mind just letting me know how it’d work? What would the other collection look like? Thanks so much for your help