School Register Spreadsheet to Coda

[Feroz]

Hi All

I wanted to start by saying a HUGE thank you to you all for contributing to this community and pooling our ideas help and support together.

I wanted to ask you all how to go about migrating this school register spreadsheet to Coda.

I’d like a practical solution as each academic year requires a new set of term dates. At the moment this is created manually - which is painfully time-consuming.

Love to hear from you

Feroz

[Math_24]

Hello,
I would see it as 3-4 tables:

• user table
• date table
• attendance table
• (optional) week table for KPIs

[Melanie_Teh]

@Feroz

welcome to the community !

what you have attached as an example works great for spreadsheets (excel, google sheets) but not so much in the sense of “database” first applications like Coda.
Before migrating over, you may want to carefully consider if this new way of thinking/working is suitable or worth the extra steps.

How i would tackle this/coda-fying it…

Tables required are

1. Students
2. Term Dates (here you can create a canvas button to create new rows for new set of term dates from a start date)
3. Attendance (junction table where Students and Term Dates are linked via each row)

From here, you can create a view of Attendance table and using grouping function. To look something like this

hope this helps!

Cheers!
Mel

p.s. sorry to double up replying @Math_24 - i was in the middle of building doc/answering post

[Math_24]

I built it a little differently, but it’s still in the same style Here’s the doc for example

DEMO Formation

[Feroz]

Thank you so much! This looks really interesting - will give it a go and keep you posted

[Feroz]

Thank you so much Math_24, I’ll try this out!