Create script that rolls up the data from the participant record sheets

[sofiatajide]

Dependency

• Create participant record sample for V3+ of participant record dashboard #7710
• Requirements for the Participant Record Dashboard v3 #7640

Overview

We need to create a script that sweeps the data from a submitted participant record sheet out of the workbook into the roll up sheet

Details

This script should:

• advance the counters in Global Values
• lock the sheet that has been submitted, so that they can't edit or resubmit

Action Items

• [add some action items]
• Release dependency on Rebuild the dashboard using the new STATIC data source #7724

Resources

Related issues

• Epic: All Dashboards Epic: Initiative: Dashboards planning #6614
• Project Board (see all issues): HfLA Dashboards: Project Board, Participant Record
• Requirements for the Participant Record Dashboard v3 #7640
  • Create participant record sample for V3+ of participant record dashboard #7710
    • Create script that rolls up the data from the participant record sheets (this issue)
• Rebuild the dashboard using the new STATIC data source #7724

[github-actions]

Hi @sofiatajide.

Please don't forget to add the proper labels to this issue. Currently, the labels for the following are missing:

• Complexity, Role, Feature, Size

NOTE: Please ignore this comment if you do not have 'write' access to this directory.

To add a label, take a look at Github's documentation here.

Also, don't forget to remove the "missing labels" afterwards.
To remove a label, the process is similar to adding a label, but you select a currently added label to remove it.

After the proper labels are added, the merge team will review the issue and add a "Ready for Prioritization" label once it is ready for prioritization.

Additional Resources:

• Wiki: How to create issues
• Wiki: How to read and interpret labels