In the meeting, the State Changers discussed a project related to building a chart with reports and quizzes. The main goal was to sync data from ClickUp to Xano and generate a dynamic Google document. The team talked about the structure of the data, including fields such as week numbers, quiz scores, and term IDs. They explored using aggregation queries in Xano to calculate average quiz scores per term and per level. They also discussed filtering the data based on the current term and how to handle updates to term numbers. The team recommended experimenting with different data structures in Xano and testing queries before deciding on the final setup. They also suggested creating a meta table to store information about the current term. Finally, they discussed the idea of using meta data in ClickUp to track the current state and update relevant features.
(Source: Office Hours 7/17/2023 )
