tomlovesgithub
commented
4 years ago Looking into solving this ive found a few solutions and backup plans. The ideal solution would materialise as a UI button which would trigger a cloud function to export data from firebase to a google sheet document. There is questions still to be answered about where to best securely store this file, and still allow it to be safely accessible by teams. Assuming we store a single document per test and use that file to show all test results, the best solution would be to create this sheet server-side with the google sheets API Quickstart Create sheet Then populate this with data from firestore, perhaps running the function when the time window for a QT closes, then providing a link via the UI button.
Other less preferable solutions, include a few out of the box sheet/firebase syncing tools. one firebase-own solution however these aren't ideal as they are syncing tools which will update a sheet as results change, which could be a useful tool for further requirements on QT's or a separate feature.
Equally its worth investigating and testing all solutions, as if we did want synchronised behaviour we wouldn't want the sheet changing the DB
warrensearle
When a qualifying test is completed admins will need to process the results data. For now this will be done outside of the admin tool. To facilitate this we will offer an 'Export to google sheets' function.
First we should investigate and decide whether to do this client-side or via a back-end cloud function.