Hi everyone,
I’m developing an app that monitors a interclass competition in a public school in Portugal for students between the 7th and 9th grade. Each class is evaluated by their teachers and operational assistants that work with them in a scale of 1-5. The average grade reverts directly to points for each class. They can also receive points if they reach the objectives defined by the School Board when it comes to their performances in tests or the behaviors of merit they had during the semester. Finally, to further engage students Quizzes were also added to the app. The results are positive so far, but to further analyze the data from the competition and alert teachers and operational assistants of the grade submission I’m having a lot of manual work in the weekends. I have a Pro Account and I have Push Notifications that I send (even though I’m not yet figure out the best way to create a time trigger that sends the reminder to certain teachers) and I have to export the CSV of each GlideTable that contain the submissions and analyze them in an Excel. I already optimize the Excel so that the data is showcased in a more friendly manner and I’m even working with PowerBI to improve this.
My question is simple: can you help me pass the information from GlideApps to Excel in real time? What options do I have using GlideApps integrations and how expensive are they? I’ve tried Zappier, but my API key doesn’t work and I don’t understand why. If you could help me I would be extremely helpful. I’m a part of a bigger team that works in their off time with the goal of improving the way public school operate in Portugal accross all levels and we are extremely motivated in our mission. Thank you!