Capture commissioner conflicts

[NormaJAC]

Background
We would like to provide applicants with the opportunity to declare any pre-existing relationships they have with the JAC Commissioners so that this information can be taken into account when assessing their applications. Currently only Commissioner email addresses are captured in the database; we need to add their names too.

User Story
As a JAC admin, I want to view the applicant JAC commissioner conflicts so that I can extract any declared pre-existing relationship data.

Features

• New link created in Reports under Selection Day
• Information captured from candidates is presented in a downloadable word document in a format tbc by Norma.
• A new row in the exported document for each commissioner conflict, i.e. 3 conflicts, 3 rows
• Where Commissioners have changed between candidates completing the form and the final SCC meeting, might there be some mechanism by which candidates could be alerted and asked for any conflicts with the new one(s)?

[User Testing Steps]
To be added

[Ticket Champion]
Joanne Dixon

[Screenshots / wireframes / designs / pictures]
https://miro.com/app/board/uXjVMhy_k0o=/?share_link_id=534627406243

Private Zenhub Image

[drieJAC]

This should be exported to Google Drive (as opposed to Word specifically)

Developer Tip: choose between:

• use htmlWriter function in DP to save to Google Drive
• use Google Drive API
• use npm package for admin to save to Word

[drieJAC]

The work required will be:

• Build the page in admin to display the data (see MIRO)
• Build the export report function
• Add the 'Commissioner Conflicts' section to the list of those in the draggable area (see MIRO)