- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 25, 2024 04:18 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 25, 2024 05:33 AM
Hmm, if you want to just have it in a dashboard in an Interface, you could just do it like this?
---
If you want it to be actual records in your base you'd need another table though, call it "Summaries" or something and link it to the table that gets the form submissions. You could then create a formula field that would output whether it was the first or second half of the year as the text "First Half 2024", "Second Half 2024" etc, and then have an automation that'll paste the value from the formula field into the linked field, that way all the form submissions from the appropriate time periods will be linked to a single record in the Summaries table. After that, you could do rollups to do averages and such
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 25, 2024 06:28 PM
Here is an example that tracks vehicles over time. This could easily be your students scores each month.